0

Hi,
I am not able to logn in sqlplus.. while I can logon with the same username and password in Enterprise Manager...
EM- username: sys
password: *****
option as sysdba..

but with the same username and password i am not able to logon in sqlplus..

can anybody tell me the exact procedure, or what i m missing??

thnx

3
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by alit2002
0

Hi,
I am not able to logn in sqlplus.. while I can logon with the same username and password in Enterprise Manager...
EM- username: sys
password: *****
option as sysdba..

but with the same username and password i am not able to logon in sqlplus..

can anybody tell me the exact procedure, or what i m missing??

thnx

Make sure you have an Oracle password file

On UNIX should be under $ORACLE_HOME/dbs
On Windows under $ORACLE_HOME/database

To create it, use the orapwd utility

It should be named orapw<SID> where <SID> is your ORACLE_SID

--sriram

0

Hi

At the command line you can type

sqlplus /nolog

SQLPLUS> connect sys/password as sysdba

Hope it helps.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.