ORA-01012 in a cluster
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-01012 in a cluster

  1. #1
    Join Date
    Oct 2008
    Posts
    3

    Exclamation 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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    provide the full copy and paste from the session you are running in

  3. #3
    Join Date
    Oct 2008
    Posts
    3
    Never mind guys... i found the solution

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  5. #5
    Join Date
    Oct 2008
    Posts
    3
    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

  6. #6
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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
  •  



Click Here to Expand Forum to Full Width