Issue in connecting to database through SQLplus

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

Issue in connecting to database through SQLplus

Post by ag_ram »

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!
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply