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

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

Hi

At the command line you can type

sqlplus /nolog

SQLPLUS> connect sys/password as sysdba

Hope it helps.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.