关闭Oracle 时候出现以下错误的解决方法
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted
解决方法
在root下vi /etc/host
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
删除上面红色一行,然后重新进入oracle用户,进sqlplus 执行
产生原因
执行了两次shutdown immediate
SAP启动过程记录
bash-3.2# su - oraprd
SAPPRD:oraprd 1> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 4 12:26:54 2017
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected.
SQL> shutdown abort ----shutdown abort是不等待事务正常结束就停止数据库实例。
ORACLE instance shut down.
SQL> exit
Disconnected
SAPPRD:oraprd 2> exit
SAPPRD:oraprd 3> logout
bash-3.2# ps -ef|grep ora
root 2474288 635110 0 12:27:37 pts/4 0:00 grep ora
启动监听-启动数据库-启动SAP应用
bash-3.2# su - oraprd
SAPPRD:oraprd 1> lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 04-AUG-2017 12:27:53
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /oracle/PRD/102_64/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
System parameter file is /oracle/PRD/102_64/network/admin/listener.ora
Log messages written to /oracle/PRD/102_64/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.XX)(PORT=1527)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PRD.WORLD))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
Start Date 04-AUG-2017 12:27:53
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/PRD/102_64/network/admin/listener.ora
Listener Log File /oracle/PRD/102_64/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.XX)(PORT=1527)))
Services Summary...
Service "PRD" has 1 instance(s).
Instance "PRD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
SAPPRD:oraprd 2> sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 4 12:28:02 2017
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 1.3975E+10 bytes
Fixed Size 2108080 bytes
Variable Size 3221226832 bytes
Database Buffers 1.0737E+10 bytes
Redo Buffers 14667776 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
SAPPRD:oraprd 3> exit
SAPPRD:oraprd 4> logout
bash-3.2# su - prdadm
[YOU HAVE NEW MAIL]
SAPPRD:prdadm 1> cd /sapmnt/PRD/exe/
SAPPRD:prdadm 2> startsap r3 WLERPPRD
Checking PRD Database
------------------------------
Database is running
Starting Startup Agent sapstartsrv
-----------------------------
Instance Service on host SAPPRD started
Starting SAP Instance DVEBMGS10
------------------------------
Startup-Log is written to /home/prdadm/startsap_DVEBMGS10.log
Instance on host SAPPRD started
Starting SAP-Collector Daemon
------------------------------
***********************************************************************
* This is Saposcol Version COLL 20.95 701 - AIX v11.65 5L-64 bit 090119
* Usage: saposcol -l: Start OS Collector
* saposcol -k: Stop OS Collector
* saposcol -d: OS Collector Dialog Mode
* saposcol -s: OS Collector Status
* The OS Collector (PID 516532) is already running .....
************************************************************************
saposcol already running
SAPPRD:prdadm 3> exit
SAPPRD:prdadm 4> logout
bash-3.2# exit
阅读(11565) | 评论(0) | 转发(0) |