OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » password with @

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

password with @ [message #537755]

Fri, 30 December 2011 21:55

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

hi,all .i have a test that adding @ to the password,the following steps is my test:

SQL> ALTER USER SCOTT IDENTIFIED BY "TRIGER@";

when i logon on the local ,the password works:

SQL> CONNECT SCOTT/"TRIGER@"

but,when i logon from the remote,the password doesn't work.it occured an error: ORA-12154

SQL> CONNECT SCOTT/"TRIGER@"@SZCARGO_10.7.1.61;

WHY?

Report message to a moderator

Re: password with @ [message #537756 is a reply to message #537755]

Fri, 30 December 2011 22:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>but,when i logon from the remote,the password doesn't work.it occured an error: ORA-12154

ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/

Report message to a moderator

Re: password with @ [message #537757 is a reply to message #537756]

Fri, 30 December 2011 22:59

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

Hi,Black Swan,thank you for replying.
but if you test by yourself according to the steps which i mentioned,you will find the ora-12154 occurs again.(though your tnsnames.ora is normal)

Report message to a moderator

Re: password with @ [message #537758 is a reply to message #537757]

Fri, 30 December 2011 23:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It works for me!

bcm@bcm-laptop:~$ sqlplus scott/tiger@v112

SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 30 18:44:34 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> connect / as sysdba
Connected.
SQL> alter user scott identified by "tiger@";

User altered.

SQL> connect scott/"tiger@"@v112
Connected.
SQL>

Report message to a moderator

Re: password with @ [message #537764 is a reply to message #537758]

Sat, 31 December 2011 00:19

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

Hi,BlackSwan,look here.There are two ways to login ,but it have two results.

[oracle@shenzhengair admin]$ 
[oracle@shenzhengair admin]$ 
[oracle@shenzhengair admin]$ sqlplus scott/"tiger@"@orcl

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 31 14:20:58 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


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


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

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@shenzhengair admin]$ 
[oracle@shenzhengair admin]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 31 14:21:14 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect scott/"tiger@"@orcl;
Connected.
SQL> 
SQL>

[Updated on: Sat, 31 December 2011 00:21]

Report message to a moderator

Re: password with @ [message #537767 is a reply to message #537764]

Sat, 31 December 2011 00:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Congratulations! no error, so problem has been solved.

Report message to a moderator

Re: password with @ [message #537770 is a reply to message #537767]

Sat, 31 December 2011 00:41

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

> Congratulations! no error, so problem has been solved.

No,No.... The problem has not been solved. BlackSwan,looking carefully the contents that i post .the following code is very important.

[oracle@shenzhengair admin]$ 
[oracle@shenzhengair admin]$ 
[oracle@shenzhengair admin]$ sqlplus scott/"tiger@"@orcl

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 31 14:20:58 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


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


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

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

why this way can't login the database successfully

Report message to a moderator

Re: password with @ [message #537771 is a reply to message #537770]

Sat, 31 December 2011 00:47

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Escape the ", it is a Unix shell issue not an Oracle one:

sqlplus scott/\"tiger@\"@orcl

Regards
Michel

Report message to a moderator

Re: password with @ [message #537772 is a reply to message #537770]

Sat, 31 December 2011 00:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You just did

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 31 14:21:14 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect scott/"tiger@"@orcl;
Connected.

Report message to a moderator

Re: password with @ [message #537776 is a reply to message #537772]

Sat, 31 December 2011 01:02

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

according to the command that Michel listed ,it execute successfully.

thanks Michel and BlackSwan. the problem has been solved .so happly.

Report message to a moderator

Re: password with @ [message #537796 is a reply to message #537776]

Sat, 31 December 2011 03:57

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Do you now understand the importance of following Forum Guide - in your case, point 5:Post your Operating System (OS) name & version ? If you did that when you were opening a topic, your problem might have been resolved much sooner.

Report message to a moderator

Re: password with @ [message #537800 is a reply to message #537796]

Sat, 31 December 2011 06:15

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

>Do you now understand the importance of following Forum Guide - in your case, point 5:Post your Operating System (OS) name & version ? If you did that when you were opening a topic, your problem might have been resolved much sooner.

i'm sorry . i will remember how to open a topic next one .thanks "lie to me".

Report message to a moderator

Previous Topic:	how to drop a datafile
Next Topic:	ORA-01555 during expdp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 14:31:23 CDT 2024