OraFAQ Forum: Networking and Gateways » Could not connect to SQL PLUS (Error 12154).Plz Help?

Home » RDBMS Server » Networking and Gateways » Could not connect to SQL PLUS (Error 12154).Plz Help?

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

Could not connect to SQL PLUS (Error 12154).Plz Help? [message #245256]

Fri, 15 June 2007 12:16

g.s1223
Messages: 17
Registered: May 2007

Junior Member

Hi,

I'm a begginer in Oracle.I recentlydownloaded Oracle 10g (hich i use it at my home)and installed all the four options given during the installations.The Problem is that I'm not able to login to SQL PLUS.When I enter only scott/tiger or system/manager it is giving ORA-12560 TNS :Protocol adapter error.

Please what to enter in Username,Password and Host String.
I dont know if i'm totally right about the host string but i tried entering Beq-local.world from the below TNSNAMES.ORA, I get the
following error : ORA 12154 TNS:could not resolve service name
Hope you will help me out.
My TNSNAMES.ORA is as following :

*****************************************************************
tnsnames E:\orant\NET80\ADMIN
*****************************************************************
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle73)
(ARGV0 = oracle73ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
)
Example2.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example3.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Rep60_COMPUTER-195CD2,Rep60_COMPUTER-195CD2.world=(ADDRESS=(PROTOCOL=tcp)(HOST=COMPUTER-195CD2)(PORT=1949))

*****************************************************************

Gowtham

Report message to a moderator

Re: Could not connect to SQL PLUS (Error 12154).Plz Help? [message #245257 is a reply to message #245256]

Fri, 15 June 2007 12:22

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Did you create sample database?
Ist connect as user SYS unlock the accout for scott

by command

Code: [Select all] [Show/ hide]

sqlplus '/ as sysdba'

SQL>alter user scott identified by tiger account unlock;

then 

SQL>scott/tiger@servicename

Report message to a moderator

Re: Could not connect to SQL PLUS (Error 12154).Plz Help? [message #245258 is a reply to message #245256]

Fri, 15 June 2007 12:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What is different between this current thread AND http://www.orafaq.com/forum/m/243819/74940/#msg_243819

Report message to a moderator

Re: Could not connect to SQL PLUS (Error 12154).Plz Help? [message #245315 is a reply to message #245256]

Fri, 15 June 2007 21:44

g.s1223
Messages: 17
Registered: May 2007

Junior Member

Hi,

I'm not able to create any sample database as i'm not able to log in to sqlplus only.
As suggested above I went to command prompt and typed
sqlplus '/ as sysdba'.I'm not able to log in and i'm getting the message

Usage :SQLPLUS [ [<option>] [<logon>] [<start>]]
where (another 4 lines of command are coming)

I typed the same thing in run with no success.
Pls help me to connect to sql plus

Report message to a moderator

Re: Could not connect to SQL PLUS (Error 12154).Plz Help? [message #245317 is a reply to message #245256]

Fri, 15 June 2007 21:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

open a command window, the type the following:
sqlplus
/ as sysdba

Use CUT & PASTE the whole session back here.

Report message to a moderator

Re: Could not connect to SQL PLUS (Error 12154).Plz Help? [message #245318 is a reply to message #245256]

Fri, 15 June 2007 22:28

g.s1223
Messages: 17
Registered: May 2007

Junior Member

Hi,
Can u suggest if i have followed the steps rightly

1.opened command propmt
2. Typed the following in window command prompt
sqlplus / as sysdba

but i'm getting the same error as i got earlier.

Usage :SQLPLUS [ [<option>] [<logon>] [<start>]]
where (another 4 lines of command are coming)
I have attached the scrrenshot for reference.

Attachment: command_prompt_error.doc
(Size: 341.50KB, Downloaded 2303 times)

Report message to a moderator

Re: Could not connect to SQL PLUS (Error 12154).Plz Help? [message #245320 is a reply to message #245256]

Fri, 15 June 2007 22:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It appears you have trouble reading & following simple directions
where is my previous post did I say to use "sqlplus / as sysdba"?

Did I not clearly state to enter the following on TWO seperate lines?

sqlplus
/ as sysdba

Computers are VERY particular about what they deem acceptable.

You're On Your Own.

Report message to a moderator

Previous Topic:	Accessing Oracle from Excel Outside the Firewall
Next Topic:	dblink problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 05:26:08 CDT 2025