Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create a new user for oracle 10G ASM instance with sysdba system privilege

Param - OracleSep 25 2013 — edited Sep 26 2013

Hi,

In our Golden Gate Project, we require the SYS user credential to connect to the Oracle 10g  ASM instance to read the database transaction logs.But our client is not providing the SYS user credential to  connnect to ASM instance.

I'm getting the error message "ORA-01109:  database not open",When I tried to create a new user using the  below the steps in oracle 10g ASM instance

1. Login using "sqlplus / as sysdba"

2. Create user <username> identified by <password>;

But in oracle 11g ASM instance, I'm able to create new  user  by connecting the ASM instance with SYSASM role without issues.

Is there is any workaround to create a new user with sysdba system privilege in oracle 10g ASM instance?.

Thanks in advance .
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2013
Added on Sep 25 2013
#asm, #performance-availability, #rac-asm-clusterware-installation, #user
3 comments
3,094 views