-
ORA-01012 in a cluster
Hi All
im new here but i have a thing that you might be able to help me with.
Im trying to do a simple thing like enabling archivelog files in a cluster.
The init file has been changed so that it now can make the archive log files.
i have done the command in sqlplus archive log list;
and it tells me the location of where it would put the files if activated.
so i go to sqlplus as sysdba and type:
shut immediate;
startup mount;
Error: ora-01012 not logged on.
then i try again to login as the sys as sysdba, and it tells me that the users is already authenticated.....
then i try to shut immediate again and startup nomount;
but again i get the same error...
Any ideas?
Thank you
-
provide the full copy and paste from the session you are running in
-
Never mind guys... i found the solution :)
-
would you mind to share the solution?
Thanks,
-
Yeah sure...
Well we use oracle in my company and on it we create a user called opera, so when i logged in to try and do the mount mode i was login in as the sys user but in the opera schema... i found out that if i excluded the opera schema name and just loged into oracle with the sys user then i was able to preform the task.
I hope that you know what i mean...
this was what i did in the first run that did not work:
sqlplus "sys/xxxxx@opera as sysdba"
then i found out that login in like this logs you directly into oracle and not into the schema:
sqlplus "sys/xxxxx as sysdba"
simple, but not when you have tried a 100 options hehe
Best regards
Jesper
-
Pretty confusing to understand ... anyway thanks for sharing.
Thanks,