943,587 Members | Top Members by Rank

Ad:
  • Oracle Discussion Thread
  • Unsolved
  • Views: 2980
  • Oracle RSS
Jun 27th, 2009
0

Sqlplus startup logon

Expand Post »
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
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
OracleJig is offline Offline
1 posts
since Jun 2009
Jul 1st, 2009
0

Re: Sqlplus startup logon

Click to Expand / Collapse  Quote originally posted by OracleJig ...
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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
srirammutnuri is offline Offline
1 posts
since Jul 2009
Jul 27th, 2009
0

Re: Sqlplus startup logon

Hi

At the command line you can type

sqlplus /nolog

SQLPLUS> connect sys/password as sysdba

Hope it helps.
Reputation Points: 10
Solved Threads: 3
Junior Poster in Training
alit2002 is offline Offline
52 posts
since Dec 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Oracle Forum Timeline: multiple data insertion
Next Thread in Oracle Forum Timeline: files of tables





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC