Chinaunix首页 | 论坛 | 博客
  • 博客访问: 436894
  • 博文数量: 72
  • 博客积分: 2120
  • 博客等级: 大尉
  • 技术积分: 789
  • 用 户 组: 普通用户
  • 注册时间: 2009-03-02 11:21
个人简介

简单

文章分类

全部博文(72)

文章存档

2019年(4)

2018年(2)

2017年(2)

2014年(1)

2011年(6)

2010年(7)

2009年(50)

我的朋友

分类: Oracle

2017-08-04 12:59:02

关闭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) |
给主人留下些什么吧!~~