OraFAQ Forum: Server Administration » ORA-12154: TNS:could not resolve the connect identifier specified

Home » RDBMS Server » Server Administration » ORA-12154: TNS:could not resolve the connect identifier specified (Oracle 10G, windows XP)

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

ORA-12154: TNS:could not resolve the connect identifier specified [message #328574]

Fri, 20 June 2008 09:25

kirankoirala
Messages: 1
Registered: June 2008
Location: Nepal

Junior Member

Hi,

I am new on oracle 10G. I have oracle 10G installed in my PC. It was working fine before. Now I can connect to oracle server (using ORCL) from the "C:\>sqlplus / as sysdba" and even using "C:\>sqlplus" and followed by username and password. However, while connecting to the server using "sqlplusw" or "isqlplus - using iexplorer" I get the message "ORA-12154: TNS:could not resolve the connect identifier specified". I tried many things visiting forums, but could not be solved.

I am really stuck now as I could not practice anything more because of this.

Thank you in advance.

Kiran

Report message to a moderator

Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #328577 is a reply to message #328574]

Fri, 20 June 2008 09:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above

if sqlplus works, why do you need the others?

[Updated on: Fri, 20 June 2008 09:27] by Moderator

Report message to a moderator

Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #328593 is a reply to message #328574]

Fri, 20 June 2008 10:46

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

Senior Member
Account Moderator

I agree with Ana, don't use a tool that no more exists.

Regards
Michel

Report message to a moderator

Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #329815 is a reply to message #328574]

Thu, 26 June 2008 11:23

hhelgen
Messages: 12
Registered: April 2007
Location: Duluth MN

Junior Member

In SQLPLUSW, make sure to specify the AS SYSDBA in the host string.
User Name: SYS
Password: *********
Host String: ORCL AS SYSDBA

Another thing to try is to add .WORLD to the host string
ORCL.WORLD AS SYSDBA. This is an older default TNSNAMES configuration.

Report message to a moderator

Previous Topic:	Oracle 10.2.0.1 to 10.2.0.4 software only (no DB created)
Next Topic:	how to find a table located in particular datafile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 17 23:51:23 CDT 2024