OraFAQ Forum: Unix » sqlplus in shell

Home » Infrastructure » Unix » sqlplus in shell (red hat )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlplus in shell [message #632026]

Fri, 23 January 2015 08:57

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 ?

Report message to a moderator

Re: sqlplus in shell [message #632028 is a reply to message #632026]

Fri, 23 January 2015 09:08

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: sqlplus in shell [message #632029 is a reply to message #632028]

Fri, 23 January 2015 09:15

kvoky
Messages: 2
Registered: January 2015
Location: pRAGUE

Junior Member

hm where can I find the log ?

Report message to a moderator

Re: sqlplus in shell [message #632031 is a reply to message #632029]

Fri, 23 January 2015 09:22

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: sqlplus in shell [message #632032 is a reply to message #632029]

Fri, 23 January 2015 09:22

Lalit Kumar B
Messages: 3174
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.

Report message to a moderator

Re: sqlplus in shell [message #632133 is a reply to message #632026]

Mon, 26 January 2015 03:03

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, 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?

Report message to a moderator

Previous Topic:	Shell script - update dates every month
Next Topic:	Table is full

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 04 00:30:11 CDT 2023