Home » RDBMS Server » Server Administration » Oracle LOGIN Problem
Oracle LOGIN Problem [message #60113] Fri, 16 January 2004 00:07 Go to next message
Vishal Goyal
Messages: 9
Registered: January 2004
Junior Member
 

when i logon to database from sql promt  using sys as sysdba, then i m able to connect to database

but when i try to connect to database from DBA Studio using sys as sysdba, then i get invalid username/password error. however when i login as sys as normal user then it connects fine.

Pls help me
Re: Oracle LOGIN Problem [message #60120 is a reply to message #60113] Fri, 16 January 2004 03:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
did u set the password file for sys?
Re: Oracle LOGIN Problem [message #60126 is a reply to message #60120] Fri, 16 January 2004 19:42 Go to previous messageGo to next message
Vishal Goyal
Messages: 9
Registered: January 2004
Junior Member
Dear Mahesh , Could u tell me how to see if passpowd file for sys user has been set.
and if it is not set then how to set it

Thanx
Re: Oracle LOGIN Problem [message #60127 is a reply to message #60126] Fri, 16 January 2004 20:06 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please have a look here
Previous Topic: Multiplie Homes - TNS Problems
Next Topic: Need few mock questions for DBA certifications
Goto Forum:
  


Current Time: Fri Sep 20 10:29:19 CDT 2024