Insatallation error at create database statistics..

[Former Member]

Hi all,

I am trying to install ecc6 abap+java on win 2003 sp2 and oracle 10.1

I got error at create database statistics..When i checked in brconnect.lon it says that "BR0484I BRCONNECT log file: O:\oracle\NAG\sapcheck\cebiwbzb.sta

BR0613E Database instance NAG is shut down"

But when i cross check the oracle it is working fine ..up and running..

i checked it by executing "SQL>select name,open_mode from v$database;"

out put SQL> select name,open_mode from v$database;

NAME OPEN_MODE

-

---

-

---

ORCL READ WRITE

SQL>

I restarted the server,but stil gettng the same error...

Three days back i installed using the same dump installation was perfect without a single error.(( used oracle 10.1 without the patch )

Please help to sort out this error.Please suggest the logs that needs to checked in case of installation failure.

Thanks,

Kasperr.

[Former Member · Accepted solution]

Hi,

Try to proceed with the installation after setting the env variable ORACLE_HOME and ORACLE_SID. Hope this will resolve your issue.

Regards,

Varadhu

[markus_doehr2]

> I am trying to install ecc6 abap+java on win 2003 sp2 and oracle 10.1

Neither Oracle 10.1 no Oracle 10.2.0.1 are supported. You must install at least patch 10.2.0.2. If you installed the database already with an older version there may be corrupt blocks. That version has SERIOUS bugs.

Markus

[Former Member]

Hi All,

Thanks for your helping hand..Installation was very informative and with all your timely help i am able to learn new concepts..

I installed sap ecc6 on win 2003 and oracle 10..g(10.2) with out any patch with ut any trouble.....successfull.

Thanks,

Kasperr.

Edited by: kasperr on Aug 31, 2009 1:48 PM

[markus_doehr2]

> I installed sap ecc6 on win 2003 and oracle 10..g(10.2) with out any patch with ut any trouble.....successfull.

Well - you may have now blocks on your disk that are not detected because there were not read.

You're running an unsupported combination, if you read the installation guides (and the relevant installation notes) you'll see that this version is buggy and is not released for used. That does not mean it won't work technically - but expect problems.

Markus

[lbreddemann]

Hey there...

looks like you're cross-checking the wrong instance...

> BR0613E Database instance NAG is shut down"

>SQL> select name,open_mode from v$database;

>

> NAME OPEN_MODE

>

> ORCL READ WRITE

NAG != ORCL

Make sure you're using the same instance here!

regards,

Lars

[Former Member]

Hi All,

what you are pointing is right i gave wrong sid henct the error.

How evre i am facing some diffent error,this one i am facing error at same "create database statistics' it says that particulr sid is shut down.

when tried for sqlplus "/as sysdba"----

---

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name:

Than i loged off administrator and loged in as sidadm and started up oracle it was up and runing...than i loged of and loged in as administrator ans continued the installation and it runing....

Now when i try to check the status by sqlplus "/as sysdba" it gives the same response

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name:

Please help how to correlate this thimg administratot and sid adm..do i need to do some modification like add sid adm to adminstrator... please let me know how this is done,,...

when i checked the task manager the oracle.exe is runing under SYSTEM user......

Thanks,

Kasperr.

[fidel_vales]

Hi,

why have you created two posts for the same issue?

in addition

1) have you checked SAP Notes, i'm pretty sure that there are at least a couple of them for that error?

what OS user are you using to conect to the database?

are you on the system console or connected remotely?

beforeanswering my question, check the sap notes (and ideally, search on the forum too)