-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|