sysdba

[ag_201074]

how do i connectas sysdba,
i have tried the following
connect sys/change_on_install as sysdba;
but it is giving a error
INVALID PASSWORD LOGON DENIED

but when again i connect with
connect sys/change _on_install;
it is connecting to oracle

[sreddy]

<font face=courier>
prod% svrmgrl

Oracle Server Manager Release 3.0.6.0.0 - Production

(c) Copyright 1999, Oracle Corporation. All Rights Reserved.

Oracle8 Enterprise Edition Release 8.0.6.2.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.6.2.0 - Production

SVRMGR> connect / as sysdba
Connected.
SVRMGR>
</font>

If not, you have a password file setup. Your user id needs sydba privileges. you have to grant sysdba privileges to the userid you are connecting to.

[Edited by sreddy on 02-01-2001 at 09:51 AM]

[ag_201074]

thanks for your reply it was very helpful