Home » Infrastructure » Windows » SQL log in
SQL log in [message #211701] Mon, 01 January 2007 09:16 Go to next message
samsabsaf
Messages: 3
Registered: January 2007
Location: Elzbir
Junior Member
I have installed Oracle 9i to an WinXp machine I’m trying to log in to SQL Im getting an error message TNS: protocol adapter how do I go around this? I run the netca program and configured a listener still want solve the problem.
Re: SQL log in [message #211702 is a reply to message #211701] Mon, 01 January 2007 09:24 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

go through below procedure

1.On Command prompt.
start >>> run >>> cmd <<enter>>
cmd>set ORACLE_SID=<SID>
cmd>net start OracleService<sid> <<enter>>
cmd>sqlplus sys as sysdba <<enter>>


regards
Taj
Re: SQL log in [message #211705 is a reply to message #211702] Mon, 01 January 2007 09:35 Go to previous messageGo to next message
samsabsaf
Messages: 3
Registered: January 2007
Location: Elzbir
Junior Member
the Command prompt say:
C:\documents and Settings\user>
what do I do next
Re: SQL log in [message #211708 is a reply to message #211705] Mon, 01 January 2007 09:45 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
C:\documents and Settings\user>cd\ <<enter>>
C:\>set oracle_sid=<sid>
C:\>NET START ORACLESERVICE<SID>
C:\>SQLPLUS SYS AS SYSDBA
PASSWORD : ***********

SQL>SELECT STATUS FROM V$INSTANCE;


regards
Taj
Re: SQL log in [message #211709 is a reply to message #211708] Mon, 01 January 2007 09:50 Go to previous messageGo to next message
samsabsaf
Messages: 3
Registered: January 2007
Location: Elzbir
Junior Member
thanks for your effort taj

when i type
C:\>set oracle_sid=<sid> and hit enter
I got a message say

the syntax of the command is incorrect
Re: SQL log in [message #211719 is a reply to message #211709] Mon, 01 January 2007 14:14 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
<sid> is to be replaced for actual SID. For example, it looks like this: setting environment variable:
C:\>set oracle_sid=ora10
Checking envirnonment variable's value:
C:\>set oracle_sid
oracle_sid=ora10

C:\>

P.S. I hope you don't type ****** when prompted for password ...
Previous Topic: Oracle 8i/ Developer 6i Installation
Next Topic: Connectin with Developer Forms & Oracle
Goto Forum:
  


Current Time: Thu Mar 28 15:31:40 CDT 2024