-
Hi,
I am facing a problem in Oracle8i in Sun Solaris. The problem is there is an existing database with db_name as orcl. Now I want to create another database with db_name as rg. Now if I change the ORACLE_SID parameter at O/S level and type svrmgrl and say connect internal, I get an error stating insufficient privileges. I would like to know why this is happening and the solution to solve this error.
Regards
Ganesh .R
-
try creating a new orapw or set "remote_login_passwordfile = none" in the init.ora
where SID is your new instance name.
-
Vesrions of existing db and new one same or different ? If different set ORACLE_HOME also.
If you can, tTry bouncing the database after removing the orapwd file and commenting remote_login_passwordfile=exclusive/shared.
Recreate the passwordfile afterwards.