OraFAQ Forum: Windows

Home » Infrastructure » Windows » SQL log in

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

SQL log in [message #211701]

Mon, 01 January 2007 09:16

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.

Report message to a moderator

Re: SQL log in [message #211702 is a reply to message #211701]

Mon, 01 January 2007 09:24

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

Report message to a moderator

Re: SQL log in [message #211705 is a reply to message #211702]

Mon, 01 January 2007 09:35

samsabsaf
Messages: 3
Registered: January 2007
Location: Elzbir

Junior Member

the Command prompt say:
C:\documents and Settings\user>
what do I do next

Report message to a moderator

Re: SQL log in [message #211708 is a reply to message #211705]

Mon, 01 January 2007 09:45

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

Report message to a moderator

Re: SQL log in [message #211709 is a reply to message #211708]

Mon, 01 January 2007 09:50

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

Report message to a moderator

Re: SQL log in [message #211719 is a reply to message #211709]

Mon, 01 January 2007 14:14

Littlefoot
Messages: 21826
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 ...

Report message to a moderator

Previous Topic:	Oracle 8i/ Developer 6i Installation
Next Topic:	Connectin with Developer Forms & Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Oct 20 11:24:58 CDT 2026