DSXchange

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.

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

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.

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

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

Checked, the user has right privileges.

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

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.

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