Home » RDBMS Server » Networking and Gateways » Could not connect to SQL PLUS (Error 12154).Plz Help?
Could not connect to SQL PLUS (Error 12154).Plz Help? [message #245256] Fri, 15 June 2007 12:16 Go to next message
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
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 Go to previous messageGo to next message
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


sqlplus '/ as sysdba'

SQL>alter user scott identified by tiger account unlock;

then 

SQL>scott/tiger@servicename
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
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 Go to previous messageGo to next message
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.
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 Go to previous message
BlackSwan
Messages: 25046
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.
Previous Topic: Accessing Oracle from Excel Outside the Firewall
Next Topic: dblink problem
Goto Forum:
  


Current Time: Thu Dec 08 18:18:28 CST 2016

Total time taken to generate the page: 0.05892 seconds