cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SP2-0310: unable to open file "run_control.sql"

Former Member

on ‎11-22-2011 2:21 PM

0 Kudos

Hi Basis Expert,

I am doing BW 3.5 installation with system copy i.e Backup/Restore method

When doing DB installation i am facing problem

SP2-0310: unable to "open file run_control.sql"

In ora_sql_results.log the output is as follows

================================================================================

2011-11-22, 09:29:15 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 10.2.0.4.0 - Production on Tue Nov 22 09:29:16 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SP2-0310: unable to open file "ora_scr_tmp.sql"

================================================================================

2011-11-22, 12:16:51 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 10.2.0.4.0 - Production on Tue Nov 22 12:16:51 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SP2-0310: unable to open file "ora_scr_tmp.sql"

================================================================================

2011-11-22, 12:32:19 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 10.2.0.4.0 - Production on Tue Nov 22 12:32:19 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SP2-0310: unable to open file "ora_scr_tmp.sql"

================================================================================

2011-11-22, 13:31:00 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 10.2.0.4.0 - Production on Tue Nov 22 13:31:00 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SP2-0310: unable to open file "ora_scr_tmp.sql"

================================================================================

2011-11-22, 13:44:44 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 10.2.0.4.0 - Production on Tue Nov 22 13:44:45 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SP2-0310: unable to open file "run_control.sql"

Disconnected

SAPINST: End of output of SQL executing program /oracle/PBW/102_64/bin/sqlplus.

SAPINST found errors.

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

2011-11-22, 13:44:45 SAPINST ORACLE stop logging

================================================================================

2011-11-22, 13:49:22 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 10.2.0.4.0 - Production on Tue Nov 22 13:49:22 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SP2-0310: unable to open file "run_control.sql"

Disconnected

SAPINST: End of output of SQL executing program /oracle/PBW/102_64/bin/sqlplus.

SAPINST found errors.

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

2011-11-22, 13:49:22 SAPINST ORACLE stop logging

================================================================================

2011-11-22, 13:49:33 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 10.2.0.4.0 - Production on Tue Nov 22 13:49:33 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SP2-0310: unable to open file "run_control.sql"

Disconnected

SAPINST: End of output of SQL executing program /oracle/PBW/102_64/bin/sqlplus.

SAPINST found errors.

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

2011-11-22, 13:49:34 SAPINST ORACLE stop logging

Please help me in fixing this issues

Regards,

Anil Shenoy

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188883
Active Contributor
‎11-22-2011 3:12 PM
0 Kudos

Hi,

Please check whether your database is up and running and you can connect using SQL prompt

After this create a file with name run_control.sql in the installation log directory.

Contents of the run_control.sql file should be only

EXIT;

Repeat the sapinst process after you create this file in the installation log directory.

Hope this helps.

Regards,

Deepak Kori

Show replies
Show replies
Former Member
‎11-22-2011 3:34 PM
0 Kudos

Hi Deepak and others,

I have not understood what you have told.

Can you please let me knowand explain what i need to do to fix this issue.

Regards,

Anil Shenoy

former_member189725
Active Contributor
‎11-23-2011 1:10 AM
0 Kudos

Please check the permission of the installation directory . Give full permission 777 to the installation directory.

Check umask and set it to 022.

Retry again.

Former Member
‎11-23-2011 6:14 AM
0 Kudos

Hi Basis Expert,

After giving full permission 777 to the installation directory and setiing umask 022. It is not working.

Checked ora_sql_results.log and this time the log is giving

================================================================================

2011-11-23, 05:55:47 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 10.2.0.4.0 - Production on Wed Nov 23 05:55:48 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

Connected to an idle instance.

ORACLE instance shut down.

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORA-01506: missing or illegal database name

CREATE CONTROLFILE REUSE SET DATABASE "PBW" NORESETLOGS ARCHIVELOG

*

ERROR at line 1:

ORA-01034: ORACLE not available

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

IBM AIX RISC System/6000 Error: 2: No such file or directory

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORA-01506: missing or illegal database name

ALTER DATABASE ARCHIVELOG

*

ERROR at line 1:

ORA-01034: ORACLE not available

ALTER DATABASE OPEN

*

ERROR at line 1:

ORA-01034: ORACLE not available

Disconnected

SAPINST: End of output of SQL executing program /oracle/PBW/102_64/bin/sqlplus.

SAPINST found errors.

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

2011-11-23, 05:55:49 SAPINST ORACLE stop logging

The DB installation stops at run_control.sql and gives an error.

Also when i try to manually start the DB it is giving

os>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Nov 23 06:12:41 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup;

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORA-01506: missing or illegal database name

SQL>

Please help me in fixing this issue.

Regards,

Anil Shenoy

former_member188883
Active Contributor
‎11-23-2011 6:14 AM
0 Kudos

Hi Anil,

Please check whether your database is up and running at this point of time.

If yes, You can bypass this step with a work around as mentioned below.

Create a file run_control.sql with the contents as shown below.

EXIT;

Place this file in the installation log directory. You will be required to execute SAPinst again and continue with old installation.

By doing this we are trying to bypass the error w/o impacting your system.

Hope this helps.

Regards,

Deepak Kori

Former Member
‎11-23-2011 6:52 AM
0 Kudos

Hi Deepak,

Thanks for the reply.

My database is not up and running. The oracle process is not running.

As mentioned earlier when i try to start the DB manually. It is giving the error as

os>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Nov 23 06:51:26 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup;

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORA-01506: missing or illegal database name

SQL>

Former Member
‎11-23-2011 7:00 AM
0 Kudos

Hi Anil,

As I understood you are creating control files by running @control.sql, Please check if u201Cstartup nomountu2019 is specified on control.sql script file. If it is not specified in please check with following steps.

sqlplus / as sysdba

SQL> startup nomount

SQL>@control.sql

Please let me know if this helps you..?

Thanks,

Kapil Pandey

Edited by: Kapil K Pandey on Nov 23, 2011 8:03 AM

Former Member
‎11-23-2011 7:52 AM
0 Kudos

Hi Kapil / Deepak,

Thanks for the reply

See when i say os>startup or startup nomount. The DB is not getting started and it is giving an error

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORA-01506: missing or illegal database name

Can you please help me in resolving this issue

Regards,

Anil.

Former Member
‎11-25-2011 9:12 AM
0 Kudos

Hi Kapil / Deepak,

Thanks for your help.

This issue is resolved.

Regards,

Anil Shenoy

Ask a Question