on 11-22-2011 2:21 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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>
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
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.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.