SafeFeel.com

Free Computer Networking Security & Software Questions and Answers Website

I own oracle 8i,but my sql login doesnot accept the username and password what should i do?

it say that in that is a protocol error!


Answers: Could be a couple things.

You might hold 2 databases on that server, so you hold to specify which database you want to connect to. Say, for example, you one database call ORCL and the other call CSI (watching CSI in a minute, so for insufficiency of a better signature :-)

So from directly on that server, do:
cmd>set ORACLE_SID=ORCL
cmd>svrmgrl
SVRMGR>connect internal
password: oracle

Of course replace the password next to the actual password. If your database contained by on Linux or Unix, replace
cmd>set ORACLE_SID

with

$export ORACLE_SID=ORCL

If you needed to connect to database CSI, consequently directly on the database server do:

$export ORACLE_SID=CSI

or

cmd>set ORACLE_SID=CSI

Another scenario, could be that your listener isn't started. Either start it contained by the Services Panel on window or from the command row (DOS or shell) resembling this

$lsnrctl start

Or if you're connecting over the introduce yourself, which will be using the tnsnames.ora wallet, you'll enjoy to specify the database to which you want to connect to:

SQL>connect username/password@ORCL

or

SQL>connect username/password@CSI


Hope this help :-)
Oracle Interview question and answers-
http://oracleqa2.blogspot.com/

Oracle tutorial-
http://oracletutorials.blogspot.com/...

Oracle tutorials- http://oracletutorials.info/