Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 30884
  • Last Modified:

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?
0
Rosa2003
Asked:
Rosa2003
1 Solution
 
sajuksCommented:
try using
>conn sys/change_on_install as sysdba.

change_on_install is default password for sys
0
 
seazodiacCommented:
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;

0
 
bcpprnCommented:
try this
C:> sqlplus "/ as sysdba"

this statement same connect internal/xxx  by svrmgrl on oracle8
0
 
mohammadzahidCommented:
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!!

0
 
schwertnerCommented:
If you have the account of the OS user who has installed Oracle (belongs to DBA  Windows group)
log so:

C:>sqlplus /nolog
SQL>connect    /  as sysdba
SQL>alter user sys identified by my_friend
SQL>alter user system identified by my_friend

Now the passwords will be my_friend!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now