| 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
|
|
|
|
|
|
|
|
| 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
|
|
|
|
|
|
| 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.
|
|
|
|
| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
