Metadata Repository (Datastage 8.5 Installation)

[Yarko]

Hi, I am trying to install Datastage 8.5 (Windows 7 64 bit) and connect Datastage to Oracle 11g. This Validation error i get. May be somebody can explain me what i am doing incorrect???

Here is validation error:

CDIIN2001E: Error when validating database connection and
requirements: oracle, dbName=xmeta, dbHost=MONSTER, dbPort=1521,
dbUser=xmeta, error message=[IBM][Oracle JDBC Driver]Error
establishing socket to host and port: MONSTER:1521. Reason:
Connection refused: connect<br>
java.sql.SQLException: [IBM][Oracle JDBC Driver]Error
establishing socket to host and port: MONSTER:1521. Reason:
Connection refused: connect<br>
at com.ibm.isf.jdbc.base.BaseExceptions.createException(Unknown
Source)<br>
at com.ibm.isf.jdbc.base.BaseExceptions.getException(Unknown
Source)<br>
at
com.ibm.isf.jdbc.oracle.OracleImplConnection.makeConnectionHelper(Unknown
Source)<br>
at
com.ibm.isf.jdbc.oracle.OracleImplConnection.makeConnection(Unknown
Source)<br>
at
com.ibm.isf.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown
Source)<br>
at com.ibm.isf.jdbc.oracle.OracleImplConnection.open(Unknown
Source)<br>
at com.ibm.isf.jdbc.base.BaseConnection.connect(Unknown
Source)<br>
at
com.ibm.isf.jdbc.base.BaseConnection.setupImplConnection(Unknown
Source)<br>
at com.ibm.isf.jdbc.base.BaseConnection.open(Unknown Source)<br>
at com.ibm.isf.jdbc.base.BaseDriver.connect(Unknown Source)<br>
at com.ibm.is.inst[IBM][Oracle JDBC Driver]Error establishing
socket to host and port: MONSTER:1521. Reason: Connection
refused: connect<br>
java.sql.SQLException: [IBM][Oracle JDBC Driver]Error
establishing socket to host and port: MONSTER:1521. Reason:
Connection refused: connect<br>
at com.ibm.isf.jdbc.base.BaseExceptions.createException(Unknown
Source)<br>
at com.ibm.isf.jdbc.base.BaseExceptions.getException(Unknown
Source)<br>
at
com.ibm.isf.jdbc.oracle.OracleImplConnection.makeConnectionHelper(Unknown
Source)<br>
at
com.ibm.isf.jdbc.oracle.OracleImplConnection.makeConnection(Unknown
Source)<br>
at
com.ibm.isf.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown
Source)<br>
at com.ibm.isf.jdbc.oracle.OracleImplConnection.open(Unknown
Source)<br>
at com.ibm.isf.jdbc.base.BaseConnection.connect(Unknown
Source)<br>
at
com.ibm.isf.jdbc.base.BaseConnection.setupImplConnection(Unknown
Source)<br>
at com.ibm.isf.jdbc.base.BaseConnection.open(Unknown Source)<br>
at com.ibm.isf.jdbc.base.BaseDriver.connect(Unknown Source)<br>
at com.ibm.is.inst......<br>
log=PASSED: CDIPR2103I: Ensure that the port number 9633 is not
in use.<br>
<br>
FAILED: CDIPR2079I: Ensure that user xmeta can connect to the
database xmeta on host MONSTER at port number 1521 and has create
table, create view, create index, and create trigger rights.
Resolution: Ensure that user xmeta can connect to database xmeta
on host MONSTER at port number 1521 and has create table, create
view, create index, and create trigger rights.<br>
<br>
FAILED: CDIPR2079I: Ensure that user xmeta can connect to the
database xmeta on host MONSTER at port number 1521 and has create
table, create view, create index, and create trigger rights.
Resolution: Ensure that user xmeta can connect to database xmeta
on host MONSTER at port number 1521 and has create table, create
view, create index, and create trigger rights.

[lstsaur]

It's so obvious a permission issue for user xmeta!

[ray.wurlod]

Check that your Oracle port (1521) is not blocked by a firewall and that the host machine on which Oracle is running is accepting connections.

[Yarko]

The firewall is turned off and I able to connect to the db with xmeta user (+ create tables)

[chulett]

Not just tables. From the error message: and has create table, create view, create index, and create trigger rights.

[Yarko]

Checked, the user has right privileges.

[priyadarshikunal]

Also check if the ASO is enabled, it should not be.

[lstsaur]

In that case, I would suspect that the Listener was down during the installation. Make sure the Listener is up and then try to run the install again.

[babbu9]

This error may occur if your /opt/IBM/InformationServer directory is not empty. Delete the contents and reinstall.