ORA-01012 in a cluster

[Rezet]

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

[davey23uk]

provide the full copy and paste from the session you are running in

[Rezet]

Never mind guys... i found the solution

[vnktummala]

would you mind to share the solution?

Thanks,

[Rezet]

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

[vnktummala]

Pretty confusing to understand ... anyway thanks for sharing.

Thanks,