Error during solution manager 3.2 installation.

[Former Member]

Hi !

I am getting the error in solution manager 3.2 installation . I am doing installation using system copy / backup restore method .

Getting ther following error -

"CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: SP2-0310: unable to open file

"CONTROL.SQL"ORA-01012: not logged onORACLE instance started."

Kindly suggest the solution.

Regards-

sanjay

[markus_doehr2 · Accepted solution]

check the file ora_sql_result.log and if in doubts post it here.

--

Markus

[Former Member · Accepted solution]

hi Markus!

The ora_sql_results.log file shows the following-

"2007-06-07, 18:32:21 SAPINST ORACLE start logging for

connect / as sysdba ;

CONNECT / AS SYSDBA

SHUTDOWN ABORT

@CONTROL.SQL

SHUTDOWN IMMEDIATE

STARTUP MOUNT

ALTER DATABASE ARCHIVELOG;

ALTER DATABASE OPEN;

EXIT

exit;

Output of SQL executing program:

SQL*Plus: Release 9.2.0.6.0 - Production on Thu Jun 7 18:32:21 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected.

Connected.

ORACLE instance shut down.

SP2-0310: unable to open file "CONTROL.SQL"

ORA-01012: not logged on

ORACLE instance started.

Total System Global Area 546906764 bytes

Fixed Size 455308 bytes

Variable Size 293601280 bytes

Database Buffers 251658240 bytes

Redo Buffers 1191936 bytes

ORA-00205: error in identifying controlfile, check alert log for more info

ALTER DATABASE ARCHIVELOG

*

ERROR at line 1:

ORA-01507: database not mounted

ALTER DATABASE OPEN

*

ERROR at line 1:

ORA-01507: database not mounted

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.6.0 - Production

SAPINST: End of output of SQL executing program E:\oracle\SMP\920/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2007-06-07, 18:32:28 SAPINST ORACLE stop logging"

What to follow... pls guide

Regards-

sanjay

[former_member204746 · Accepted solution]

your problem is:

SP2-0310: unable to open file "CONTROL.SQL"

you need to find that file or make sure that it is it the current directory when calling SQLPLUS

[Former Member · Accepted solution]

thks!!!

[Former Member]

Hi,

Chk the note nos : <a href="https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=539921&nlang=EN&smpsrv=https%3a%2f%2fwebsmp209%2esap-ag%2ede">539921</a> and <a href="https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=101020&nlang=EN&smpsrv=https%3a%2f%2fwebsmp209%2esap-ag%2ede">101020</a>

Regards, Umesh K

[Former Member]

Hi Umesh,

As suggested we had referred SAP Note 539921. We have resolved our issue.

Thank alot!!!

Regards

Jagadeesh