DB 13バックアップが失敗し、Oracleデータベースが起動できません
8044 ワード
[root@bvqas ~]# su - qasadm bvqas:qasadm 28> startsap all
Checking QAS Database Database is not available via R3trans
Trying to start QAS database ... Log file:/home/qasadm/startdb.log/usr/sap/QAS/SYS/exe/run/startdb: Terminating with error code 12 DB startup failed
please send the tracefile/home/qasadm/startsap.trc to support
bvqas:qasadm 29> exit
logout [root@bvqas ~]# su - oraqas bvqas:oraqas 51> lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-OCT-2014 21:13:03
Copyright (c) 1991, 2013, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started bvqas:oraqas 52> lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-OCT-2014 21:13:11
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=QAS.WORLD)) The command completed successfully bvqas:oraqas 53> lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-OCT-2014 21:13:23
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting/oracle/QAS/112_64/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is/oracle/QAS/112_64/network/admin/listener.ora Log messages written to/oracle/QAS/saptrace/diag/tnslsnr/bvqas/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bvqas.byvin.com)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=QAS.WORLD)) STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 04-OCT-2014 21:13:23 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File/oracle/QAS/112_64/network/admin/listener.ora Listener Log File/oracle/QAS/saptrace/diag/tnslsnr/bvqas/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bvqas.byvin.com)(PORT=1521))) Services Summary... Service "QAS"has 1 instance(s). Instance "QAS", status UNKNOWN, has 2 handler(s) for this service... The command completed successfully bvqas:oraqas 54> sqlplus/as sydba
SQL*Plus: Release 11.2.0.4.0 Production
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Use SQLPlus to execute SQL, PL/SQL and SQLPlus statements.
Usage 1: sqlplus -H | -V
Usage 2: sqlplus [ [] [{logon |/nolog}] [] ]
is: [-C ] [-L] [-M ""] [-R ] [-S]
is: {[/][@] |/} [AS {SYSDBA | SYSOPER | SYSASM}] [EDITION=value]
When SQLPlus starts, and after CONNECT commands, the site profile (e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile (e.g. login.sql in the working directory) are run. The files may contain SQLPlus commands.
Refer to the SQL*Plus User's Guide and Reference for more information. bvqas:oraqas 55> sqlplus/as sys
SQL*Plus: Release 11.2.0.4.0 Production on Sat Oct 4 21:13:41 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORA-00845: MEMORY_TARGET not supported on this system
SQL> exit Disconnected bvqas:oraqas 56> cd/oracle/QAS bvqas:oraqas 57> cd 11204 bvqas:oraqas 59> cd dbs bvqas:oraqas 61> create spfile from pfile='initQAS.ora'; create: Command not found. bvqas:oraqas 62> sqlplus/as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Oct 4 21:16:39 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile='initQAS.ora';//これが解決策ですinitQASをしっかりと行います.oraのバックアップ.
File created.
SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started.
Total System Global Area 1.8841E+10 bytes Fixed Size 2261048 bytes Variable Size 9596571592 bytes Database Buffers 9193914368 bytes Redo Buffers 48054272 bytes Database mounted. Database opened. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options bvqas:oraqas 63> exit
logout [root@bvqas ~]# su - qasadm bvqas:qasadm 28> startsap all
Checking QAS Database Database is running
Starting Startup Agent sapstartsrv OK Instance Service on host bvqas started
starting SAP Instance ASCS01 Startup-Log is written to/home/qasadm/startsap_ASCS01.log
/usr/sap/QAS/ASCS01/exe/sapcontrol -prot NI_HTTP -nr 01 -function Start Instance on host bvqas started Starting Startup Agent sapstartsrv OK Instance Service on host bvqas started
starting SAP Instance DVEBMGS00 Startup-Log is written to/home/qasadm/startsap_DVEBMGS00.log
/usr/sap/QAS/DVEBMGS00/exe/sapcontrol -prot NI_HTTP -nr 00 -function Start Instance on host bvqas started bvqas:qasadm 29>
Checking QAS Database Database is not available via R3trans
Trying to start QAS database ... Log file:/home/qasadm/startdb.log/usr/sap/QAS/SYS/exe/run/startdb: Terminating with error code 12 DB startup failed
please send the tracefile/home/qasadm/startsap.trc to support
bvqas:qasadm 29> exit
logout [root@bvqas ~]# su - oraqas bvqas:oraqas 51> lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-OCT-2014 21:13:03
Copyright (c) 1991, 2013, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started bvqas:oraqas 52> lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-OCT-2014 21:13:11
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=QAS.WORLD)) The command completed successfully bvqas:oraqas 53> lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-OCT-2014 21:13:23
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting/oracle/QAS/112_64/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is/oracle/QAS/112_64/network/admin/listener.ora Log messages written to/oracle/QAS/saptrace/diag/tnslsnr/bvqas/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bvqas.byvin.com)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=QAS.WORLD)) STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 04-OCT-2014 21:13:23 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File/oracle/QAS/112_64/network/admin/listener.ora Listener Log File/oracle/QAS/saptrace/diag/tnslsnr/bvqas/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bvqas.byvin.com)(PORT=1521))) Services Summary... Service "QAS"has 1 instance(s). Instance "QAS", status UNKNOWN, has 2 handler(s) for this service... The command completed successfully bvqas:oraqas 54> sqlplus/as sydba
SQL*Plus: Release 11.2.0.4.0 Production
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Use SQLPlus to execute SQL, PL/SQL and SQLPlus statements.
Usage 1: sqlplus -H | -V
-H Displays the SQL*Plus version and the
usage help.
-V Displays the SQL*Plus version.
Usage 2: sqlplus [ [] [{logon |/nolog}] [] ]
is: [-C ] [-L] [-M ""] [-R ] [-S]
-C Sets the compatibility of affected commands to the
version specified by . The version has
the form "x.y[.z]". For example, -C 10.2.0
-L Attempts to log on just once, instead of
reprompting on error.
-M "" Sets automatic HTML markup of output. The options
have the form:
HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text]
[ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
-R Sets restricted mode to disable SQL*Plus commands
that interact with the file system. The level can
be 1, 2 or 3. The most restrictive is -R 3 which
disables all user commands interacting with the
file system.
-S Sets silent mode which suppresses the display of
the SQL*Plus banner, prompts, and echoing of
commands.
is: {[/][@] |/} [AS {SYSDBA | SYSOPER | SYSASM}] [EDITION=value]
Specifies the database account username, password and connect
identifier for the database connection. Without a connect
identifier, SQL*Plus connects to the default database.
The AS SYSDBA, AS SYSOPER and AS SYSASM options are database
administration privileges.
can be in the form of Net Service Name
or Easy Connect.
@[ | [//]Host[:Port]/]
is a simple name for a service that resolves
to a connect descriptor.
Example: Connect to database using Net Service Name and the
database net service name is ORCL.
sqlplus myusername/mypassword@ORCL
Host specifies the host name or IP address of the database
server computer.
Port specifies the listening port on the database server.
specifies the service name of the database you
want to access.
Example: Connect to database using Easy Connect and the
Service name is ORCL.
sqlplus myusername/mypassword@Host/ORCL
The /NOLOG option starts SQL*Plus without connecting to a
database.
The EDITION specifies the value for Session Edition.
is: @|[.] [ ...]
Runs the specified SQL*Plus script from a web server (URL) or the
local file system (filename.ext) with specified parameters that
will be assigned to substitution variables in the script.
When SQLPlus starts, and after CONNECT commands, the site profile (e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile (e.g. login.sql in the working directory) are run. The files may contain SQLPlus commands.
Refer to the SQL*Plus User's Guide and Reference for more information. bvqas:oraqas 55> sqlplus/as sys
SQL*Plus: Release 11.2.0.4.0 Production on Sat Oct 4 21:13:41 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORA-00845: MEMORY_TARGET not supported on this system
MEMORY_TARGETというパラメータSAPはサポートされておらず、修正が必要です。
パス:/oracle/QAS/11204/dbs/initQAS.ora
cp initQAS.ora initQAS.ora.bak(バックアップ)
vim initQAS.ora,memory_を削除するmax_targetという行。
SQL> exit Disconnected bvqas:oraqas 56> cd/oracle/QAS bvqas:oraqas 57> cd 11204 bvqas:oraqas 59> cd dbs bvqas:oraqas 61> create spfile from pfile='initQAS.ora'; create: Command not found. bvqas:oraqas 62> sqlplus/as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Oct 4 21:16:39 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile='initQAS.ora';//これが解決策ですinitQASをしっかりと行います.oraのバックアップ.
File created.
SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started.
Total System Global Area 1.8841E+10 bytes Fixed Size 2261048 bytes Variable Size 9596571592 bytes Database Buffers 9193914368 bytes Redo Buffers 48054272 bytes Database mounted. Database opened. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options bvqas:oraqas 63> exit
logout [root@bvqas ~]# su - qasadm bvqas:qasadm 28> startsap all
Checking QAS Database Database is running
Starting Startup Agent sapstartsrv OK Instance Service on host bvqas started
starting SAP Instance ASCS01 Startup-Log is written to/home/qasadm/startsap_ASCS01.log
/usr/sap/QAS/ASCS01/exe/sapcontrol -prot NI_HTTP -nr 01 -function Start Instance on host bvqas started Starting Startup Agent sapstartsrv OK Instance Service on host bvqas started
starting SAP Instance DVEBMGS00 Startup-Log is written to/home/qasadm/startsap_DVEBMGS00.log
/usr/sap/QAS/DVEBMGS00/exe/sapcontrol -prot NI_HTTP -nr 00 -function Start Instance on host bvqas started bvqas:qasadm 29>