Home » Infrastructure » Unix » sqlplus in shell (red hat )
sqlplus in shell [message #632026] Fri, 23 January 2015 08:57 Go to next message
kvoky
Messages: 2
Registered: January 2015
Location: pRAGUE
Junior Member
Hi,

I got a doofy question, when I launch sqlplus from shell in unix
sqlplus mylogin/mypassword@db1


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


the password & login are correct there are no special characters just letters and numbers.


Any idea how to solved it ?


Re: sqlplus in shell [message #632028 is a reply to message #632026] Fri, 23 January 2015 09:08 Go to previous messageGo to next message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
kvoky wrote on Fri, 23 January 2015 06:57
Hi,

I got a doofy question, when I launch sqlplus from shell in unix
sqlplus mylogin/mypassword@db1


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


the password & login are correct there are no special characters just letters and numbers.


Any idea how to solved it ?




Oracle is really too dumb to lie with "ORA-01017: invalid username/password; logon denied"

I believe Oracle better reports reality than you do.

How do we/you know that you are really connect to the DB you think you are connecting to?
Every SQL*Net connection is logging into listener.log file.
Post excerpt from target DB Server that shows you request is getting to the expected listener & database.

Re: sqlplus in shell [message #632029 is a reply to message #632028] Fri, 23 January 2015 09:15 Go to previous messageGo to next message
kvoky
Messages: 2
Registered: January 2015
Location: pRAGUE
Junior Member
hm where can I find the log ?
Re: sqlplus in shell [message #632031 is a reply to message #632029] Fri, 23 January 2015 09:22 Go to previous messageGo to next message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
>where can I find the log ?

while logged onto DB Server issue OS command below

lsnrctl status

>sqlplus mylogin/mypassword@db1

is above being issued from same system as DB Server?
Re: sqlplus in shell [message #632032 is a reply to message #632029] Fri, 23 January 2015 09:22 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
>sqlplus mylogin/mypassword@db1

Did you really try logging in using above? Can you copy paste the SQL*Plus session to show it really succeeded.
Re: sqlplus in shell [message #632133 is a reply to message #632026] Mon, 26 January 2015 03:03 Go to previous message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, UK
Senior Member
What are the contents of your ${ORACLE_HOME}/network/admin/tnsnames.ora file? Are you sure "db1" is the database that you're trying to connect to?
Previous Topic: Shell script - update dates every month
Next Topic: Table is full
Goto Forum:
  


Current Time: Sun Dec 17 06:20:46 CST 2017

Total time taken to generate the page: 0.01255 seconds