1 安装过程中执行sh /runInstaller,出现错误:
准备从以下地址启动 Oracle Universal Installer /tmp/OraInstall2013-05-10_12-33-25PM. 请
稍候...[oracle@localhost database]$ Warning: Cannot convert string "-isas-song ti-
medium-r-normal--*-140-*-*-c-*-gb2312.1980-0" to type FontStruct
字符集问题,导致字符无法显示,解决方法是改修改字符集
cat /etc/profile
export LC_ALL=en_US
source /etc/profile
2 客户端连接oracle service 出错:
ORA-28547:connection to server failed,probable Oracle Net admin error”
解决方法:
将listener.ora的这一行注释掉,就行了,(PROGRAM = extproc)
修改为:
SID_LIST_LISTENER =
准备从以下地址启动 Oracle Universal Installer /tmp/OraInstall2013-05-10_12-33-25PM. 请
稍候...[oracle@localhost database]$ Warning: Cannot convert string "-isas-song ti-
medium-r-normal--*-140-*-*-c-*-gb2312.1980-0" to type FontStruct
字符集问题,导致字符无法显示,解决方法是改修改字符集
cat /etc/profile
export LC_ALL=en_US
source /etc/profile
2 客户端连接oracle service 出错:
ORA-28547:connection to server failed,probable Oracle Net admin error”
解决方法:
将listener.ora的这一行注释掉,就行了,(PROGRAM = extproc)
修改为:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = prod)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
# (PROGRAM = extproc)
3 oracle网络监听启动失败:
LSNRCTL> start
Starting /u01/app/oracle/product/10.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)
(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted
通过日志错误信息可知,应该跟权限有关,最后发现了一个隐藏的信息,/var/tmp/.oracle目录下保存着一些socket文件,用于客户端通过 ipc协议连接oracle进程的。如果oracle没有对此目录的操作权限的话,oracle用户就无法进入/var/tmp/.oracle文件夹。
解决方法: chown oracle.oinstall /var/tmp/.oracle -R
(SID_DESC =
(SID_NAME = prod)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
# (PROGRAM = extproc)
3 oracle网络监听启动失败:
LSNRCTL> start
Starting /u01/app/oracle/product/10.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)
(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted
通过日志错误信息可知,应该跟权限有关,最后发现了一个隐藏的信息,/var/tmp/.oracle目录下保存着一些socket文件,用于客户端通过 ipc协议连接oracle进程的。如果oracle没有对此目录的操作权限的话,oracle用户就无法进入/var/tmp/.oracle文件夹。
解决方法: chown oracle.oinstall /var/tmp/.oracle -R
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27181165/viewspace-775860/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27181165/viewspace-775860/