Home » RDBMS Server » Server Administration » How to login as SYS
How to login as SYS [message #63198] Thu, 16 September 2004 22:38 Go to next message
M Kumar
Messages: 38
Registered: August 2004
Member
Hi All,
I can login using system/manager using SQL+... however, I cannot login using sys, sysdba, or sysop, which are accessed using the sys account. Even using the default password change_on_install does not work and using alter user to change the password seems to have no effect. I only get the message "invalid login". How do I get the password so I can login as sysdba?

Thanks in advance

Report message to a moderator

Re: How to login as SYS [message #63199 is a reply to message #63198] Thu, 16 September 2004 22:51 Go to previous messageGo to next message
priti
Messages: 18
Registered: July 2002
Junior Member
in SQL prompt

SQL> conn as sys/dba
or

Create one more user as sysdba n try to login as sysdba...

Report message to a moderator

Re: How to login as SYS [message #63201 is a reply to message #63198] Thu, 16 September 2004 23:35 Go to previous messageGo to next message
Vivek Vijai
Messages: 67
Registered: April 2004
Member
suppose ur pwd for sys is ABC, u may login as

SQL> connect sys/ABC as sysdba

it will work

Vivek

Report message to a moderator

Re: How to login as SYS [message #63205 is a reply to message #63201] Fri, 17 September 2004 00:52 Go to previous messageGo to next message
M Kumar
Messages: 38
Registered: August 2004
Member
Thanks a lot Vivek.
Its working.

Kumar

Report message to a moderator

Re: How to login as SYS [message #63298 is a reply to message #63199] Fri, 24 September 2004 12:08 Go to previous message
Jamuna
Messages: 2
Registered: September 2004
Junior Member
I am using
conn /as sysdba
and also
conn system/manager as sysdba

Both of them are giving same error:

ORA-01030 : insufficient privileges

What should I check or rectify?

Thanks.

Report message to a moderator

Previous Topic: Can Initialization parameter on client side?
Next Topic: Export error Error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 08:23:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.