ORA-01034: ORACLE not available

[Former Member]

Hello experts,

i have a problem with oracle:

i have 2 instances in the server (1 Abap and the other Java) the abap is migrated for oracle 11.2 and the java not yet (still in 10.2)

the problem that the archivage failed i got the error on arch log:

...

BR0613I Database instance <SID> is shut down

...

when i try to connect to database i got that :

C:\Users\<sid>adm>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Sep 14 14:35:01 2011

....

Connected to an idle instance.

SQL> select * from v$instance;

select * from v$instance

ERROR at line 1:

ORA-01034: ORACLE not available

could you please help me

thanks very much in advance

[Former Member · Accepted solution]

What were you doing with the database ? What activity ?

What happens when you try sqlplus> startup

Thanks

[Former Member]

Thank you very much for your help.

yes the databases was down i started its with startup.

thxxxxxxxxxxx

[Former Member]

start it before.

Then reply with the error log (if present)

[Former Member]

Database is down ..

Did you start Database ??

Try to start database manually and check ..

[Former Member]

Hello Nana

Do you mean to say you have two different versions of Oracle running on single host?

Can you be little clear.

What I can see is you are trying to connect to Oracle 10 and which is not started.

Regards

Vivek