DSXchange

Hi All

I have an issue connecting to oracle database through SQLPLUS.
Datastage is installed in one server and Oracle database is in another server.
I have updated TNSNAMES.ORA file with connectivity details to above mentioned oracle database.
i am able to connect to oracle database through datastage using Oracle stage,
But i am not able to establish to oracle database through SQLPLUS from the server where datastage is installed.
i am getting the below error message:

ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_string>] | /
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_string>] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

there are no problems with my id/pwd as i am able to connect from datastage to the same database.

appreciate your help.

Thanks!

How are you attempting this sqlplus connection? Manually? Give us some details around what you are doing and the sqlplus syntax you are attempting to use.