AIX6.1安装ORACLE10G,数据库刚安装完毕,进入正常,但系统重启,提示监听无法正常启动
说明:数据库安装在/database 原文件安装在/backup中,数据库库名:zydb
1.hosts 名称:
# hostname
p570sybase
2.hosts配置:
# 10.2.0.2 x25sample # x.25 name/address
# 2000:1:1:1:209:6bff:feee:2b7f ipv6sample # ipv6 name/address
127.0.0.1 loopback localhost # loopback (lo0) name/address
192.198.1.1 p570sybase
3.环境变量配置:
$ cat .profile
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
export PATH
if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.
ORACLE_BASE=/database
ORACLE_SID=zydb
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
PATH=$PATH:$ORACLE_HOME/bin:.:/usr/local/bin
umask=022
export PATH
export ORACLE_BASE
export ORACLE_SID
export ORACLE_HOME
$
4.listener.ora 配置
# cat listener.ora
# listener.ora Network Configuration File: /database/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /database/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = p570sybase)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
5.tnsnames.ora 配置
# cat tnsnames.ora
# tnsnames.ora Network Configuration File: /database/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ZYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = p570sybase)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = zydb)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
6.数据连接报错:
# su - oracle
$ sqlplus
system/oracle@zydbSQL*Plus: Release 10.2.0.1.0 - Production on Sun Jun 7 08:38:56 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
7.监听状态:
$ lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 07-JUN-2009 08:39:43
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=p570sybase)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
Start Date 07-JUN-2009 07:34:44
Uptime 0 days 1 hr. 4 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /database/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /database/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=p570sybase)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
麻烦各位老大帮我看看,如果有不全的地方,请在QQ群里告诉我,我在粘贴!!
附件:
oracle10G+aix6.1错误.rar (1.63 KB)