asked on

Password of sysdba

Hello,
I have installed Oracle 9i and now I'm installing its patch. I have to connect to sql*plus as sysdba, but I don't know its password. When I installed Oracle, I remember to set up passwords only for system or sys. Can anyone help, me please?

sajuks

try using
>conn sys/change_on_install as sysdba.

change_on_install is default password for sys

seazodiac

sysdba is not a USER account but a database role.

sys or system instead are accounts.

but these two account have usually sysdba role by default:

so you have to use SYS or system password,

try this:

C:\> sqlplus "sys/*****@<db_service_name or SID name> as sysdba"

or
C:\>sqlplus /nolog
SQL>connect sys/******@<db_name> as sysdba;

bcpprn

try this
C:> sqlplus "/ as sysdba"

this statement same connect internal/xxx by svrmgrl on oracle8

mohammadzahid

You can log in the database with any user as long as it has DBA privileges. Here are the steps:
.. Quote between /**/ are comments and are for your reference.

/* First connect to the database as a user with DBA privileges */
sql> connect userdba/userdba;

/* if connected successfully then */
sql> alter user sys identified by XXXXXX; /* This will change the password of the SYS user */

/* You can then connect to the database as SYS user from the sql prompt with SYSDBA role. */
sql> connect sys/sys as sysdba;

Hope this helps!!

ASKER CERTIFIED SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial