Getting error when database creating in ECC 6.0 installation

[Former Member]

Dear all,

i am installing ECC 6.0 with win 2003 and orcale..

every thing is ok but when database is creating it is showing error in the step catprocu2026sqlu2026.

and get the log

ERROR 2009-02-24 13:32:48

CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: ORA-01092: ORACLE instance terminated. Disconnection forced

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

.<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

ERROR 2009-02-24 13:32:48

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2009-02-24 13:32:48

FCO-00011 The step runCatprocSql with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|runCatprocSql was executed with status ERROR .

after getting this when i am trying at CMD level and typing SQLPLUS and logging as sysdba

then it is showing

ORA-12560:-TNS : protocol adapter error

provide me the solution how can i rectify...

[former_member185031 · Accepted solution]

Markus is right. I have missed that database is 10.2.0.1.0

It is not supported by SAP. You need to apply the patch first up to 10.2.0.2.0 or 10.2.0.4.0

Regards,

Subhash

[Former Member · Accepted solution]

hi to every one

facing that error when

ERROR 2009-02-24 13:32:48

CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: ORA-01092: ORACLE instance terminated. Disconnection forced

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

.<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for detail

and then i check the ora_eql_results.log then i found

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

DOC>######################################################################

DOC>######################################################################

DOC> The following statement will cause an "ORA-01722: invalid number"

DOC> error and terminate the SQLPLUS session if the user is not SYS.

DOC> Disconnect and reconnect with AS SYSDBA.

DOC>######################################################################

DOC>###

[markus_doehr2 · Accepted solution]

> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

> With the Partitioning, OLAP and Data Mining options

> .<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for detail

Again - 10.2.0.1 is not supported - the error you get is due to a database error that is fixed with 10.2.0.2 (+ interim patches) or 10.2.0.4.

Markus

[former_member204746 · Accepted solution]

check file alert_SID.log

as Markus said, you will probably find out that your Oracle binaries are not of the same version of your database.

so, upgrade your binaries, then upgrade your DB.

[Former Member · Accepted solution]

Yes i am getting error in ORCALE binary....

i want your suggestion i do not want to reinstall OS....while i am using win2003.

can i REinstall orcale....

in same drive.....

please suggest

[markus_doehr2 · Accepted solution]

The reason is not a wrongly installed Oracle but the fact, that you are missing a patch installation....

Markus

[Former Member · Accepted solution]

Dear Markus,

that is ok but why it is saying....

OUI-10091:There are no patches that need to be applied from the patchset orcale 10 g release to patch set 1 10.2.0.2.0

when i am applying patches....

regards,

anuj

[markus_doehr2 · Accepted solution]

Did you install the patchset 10.2.0.2 before you're tried to apply patches for that version?

Markus

[Former Member · Accepted solution]

Dear Markus,

i follow... below steps...tell me these or ok or not and where i sholud have install patchset...

please describe ....or suggest

Go to the drive for orcale

\orcale\10G\NT\I386

now i have option

Database

Sap

but i choose Database

means

\orcale\10G\NT\I386\database\setup.exe

then got the screen

SELECT INSTALLATION METHOD

Basic installation installation or Advances installation

here i choose Advanced installation

SELECT INSTALLATION TYPE

EntrpriseEdition 10.2.0.1.0

SELECT CONFIGRATION OPTION

Install database software only

i got the message after all 8th step

END OF INSTALLATION

the installation of orcale database 10g was successful.

then i aply the patches

i choose the path

orcale10g\ORA Patch\NT\I386\setup.exe

i got orcale welcome window

Orcale Universal Installation 10.2

SPECIFY HOME DETAILautomatically take the path

D:\Orcale\Product\10.2.0\db_3

but after that give the same error

OUI-10091:There are no patches that need to be applied from the patchset orcale 10 g release to patch set 1 10.2.0.2.0

[markus_doehr2 · Accepted solution]

> Go to the drive for orcale

> \orcale\10G\NT\I386

> now i have option

> Database

> Sap

> but i choose Database

wrong - you should use sapserver.cmd in the SAP subdirectory to install the database (read the guide).

Markus

[Former Member · Accepted solution]

Thanks for reply Markus

wrong - you should use sapserver.cmd in the SAP subdirectory to install the database

as you suggest

now i am doing fresh installation i am choosing SAp subdirectory and then i am choosing sapserver.cmd

it is asking me type the drive where you want to install...

i simply type

[D:]:

then ask for <SID> i type MRP

but now it is showing same thing and opening patch window ....

same OUI message

what can i do....

if i run simply orcale exe then what's wrong...

please suggest..

Anuj

[Former Member · Accepted solution]

i simply type

[D:]:

when sapserver.cmd ask path for orcale...what path should type...

please rectify.....

Or else i have to give there D:\orcale\product\10.2.0\db_1

or what..?

Anuj

[markus_doehr2 · Accepted solution]

I repeat again:

the sapserver.cmd uses a predefined response file with configuration that need to be done for a SAP system. Of course it will show the same diaglos but with fewer questions.

Please: read the installation guide, it will tell you exaclty which paths you should install the database.

Markus

[Former Member · Accepted solution]

Thanks for reply i got the solution with orcale help.....

[Former Member · Accepted solution]

When you get that message from the patch installation DVD is because the Oracle Installer uses a different Oracle Home Path so you must use the ARROW at the right to choose the correct Oracle Home.

If this message is solved please close it.

[Former Member]

thanks for all

[Former Member]

I think your oracle tablespace is full or the disk is full.Pls check the alert_<SID>.log.

[Former Member]

Hi,

Oracle version is showing 10.2.0.1.0. Please upgrade the oracle patch set either on 10.2.0.2.0 or 10.2.0.4.0.

Regards,

Sachin Rane.

[markus_doehr2]

> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

> With the Partitioning, OLAP and Data Mining options

That version 10.2.0.1 is not supported. Read the installation guide, it tells you what to install to make this working...

Markus

[Former Member]

Thanks to all of you for reply and suggestion....

i want to share some more information here ...after editing listener.ora file and copy that file and renamed it to LISTENER1.ora and change the post 1521 and also add in envaronment Variable LOCAL=<SID> ...

after that i am able to go in

SQLPLUS and sql

SQL>

NOT FACING ERROR RELATED TO TNS PROTOCOLE ADAPTER

but problem is that

whenever through CMD level i am checking

SQL> shutdown immediate

ORA-01034: ORCALE not available

ORA-27101:Shared Memory Realm

SQL>

SQL>startup

ORCALE instance started

Total gobale area shows buffer ..area

Database mounted

ORA-01092: Orcale Instance Terminated. Disconnection Forced.

i hope this is due to orcale patch level.

but for information i install orcale 10 g then i apply patches 10.2

but when i was apply patches...

it shows..

OUI-10091:There are no patches that need to be applied from the patchset orcale 10 g release to patch set 1 10.2.0.2.0

so what that mean...

should i apply any thing ....

please tell me.....

Regards

Anuj

[Former Member]

Anuj,

Please refer to the link below. Also post log files from ..\NETWORK\log and your ORACLE_HOME environment variable.

http://www.dbmotive.com/oracle_error_codes.php?errcode=27101

Are you sure you have 10.2.0.2.0 version because earlier it was showing different?

Hope this helps.

Manoj

[former_member204746]

Is it so hard to read your error message:

SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

[former_member185031]

Have you tried to search the same in SDN.

Its a common error your TNS listner is not configured properly. Please have a search

Regards,

Subhash

[markus_doehr2]

> Its a common error your TNS listner is not configured properly. Please have a search

I don't believe it's related to TNS, if Oracle does a "forced disconnection" is most likely a database error (followed by an ORA-00600).

The most common case for this is that people install just the version on the DVD and don't add patch 10.2.0.2 plus interim or 10.2.0.4....

Markus