ORA-12537 if Listener (including SCAN Listener) and Database are Owned by Different OS User [ID 1069
来源:互联网 发布:武汉大学软件学院怎样 编辑:程序博客网 时间:2024/05/17 15:35
ORA-12537 if Listener (including SCAN Listener) and Database are Owned by Different OS User [ID 1069517.1]
修改时间 05-JUN-2011类型 PROBLEM状态 PUBLISHED
Information in this document applies to any platform.
1. Listener owner (including SCAN listener) can not access oracle binary in database home:
As listener owner:
2. Oracle binary in database home has wrong permission:
The permission "-rwxr-x--x" is wrong as it's missing suid bit, oracle binary should have permission of 6751:
Note: If Job Role Separation is in place, the group will be <asmadmin>, otherwise it will be <oinstall>
3. File System for database home does not support setuid/suid or has nosetuid/nosuid set:
If its Job Role Separation environment, please refer to the following document:
Oracle® Grid Infrastructure
Installation Guide
11g Release 2 (11.2)
Oracle ASM Job Role Separation Option with SYSASM
NOTE:975457.1 - How to Troubleshoot Connectivity Issue with 11gR2 SCAN Name
产品
DATABASE CONFIGURATION; DBCA; LISTENER.LOG; OWNERSHIP; PERMISSION DENIED; TNS; TNS CONNECTION CLOSED; TNS LISTENER
修改时间 05-JUN-2011类型 PROBLEM状态 PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
Oracle Database Configuration Assistant - Version: 11.2.0.1 and later [Release: 11.2 and later ]Information in this document applies to any platform.
Symptoms
In environment where listener home (including SCAN listener which resides in Grid Infrastructure/ASM home) and database home are owned by different OS user, ORA-12537 could happen when connecting through listener, when creating database through DBCA, or when installing database software and creating a database in runInstaller. Job Role Separation is a typical example as SCAN and local grid home listener is owned differently than database.- Error detail
12537, 00000, "TNS:connection closed"
// *Cause: "End of file" condition has been reached; partner has disconnected.
// *Action: None needed; this is an information message.
Before the error is reported, connection could hang for a while, and a core file may also be generated.
- Screen output:
SQL> conn system/xxx@OSES
ERROR:
ORA-12537: TNS:connection closed
OR
PRCR-1079 : Failed to start resource ora.db11.db
CRS-5011: Check of resource db11 failed: details at ..
CRS-2674: Start of ora.db11.db on racnode1 failed
ORA-12546: TNS:permission denied
- listener_scann.log or listener.log
TNS-12518: TNS:listener could not hand off client connection
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
Linux Error: 13: Permission denied
OR
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
- runInstaller error if installing
INFO: Starting Output Reader Threads for process /ocw/grid/bin/kfod
INFO: Parsing KFOD-00300: OCI error [-1] [OCI error] [ORA-12547: TNS:lost contact
INFO: Parsing ] [12547]
INFO: Parsing
INFO: The process /ocw/grid/bin/kfod exited with code 1
..
SEVERE: [FATAL] [INS-30502] No ASM disk group found.
CAUSE: There were no disk groups managed by the ASM instance +ASM1.
Cause
1. Listener owner (including SCAN listener) can not access oracle binary in database home:
As listener owner:
$ ls -l $RDBMS_HOME/bin/oracle
ls: /home/oracle/app/oracle/product/11.2/db/bin/oracle: Permission denied
ls: /home/oracle/app/oracle/product/11.2/db/bin/oracle: Permission denied
2. Oracle binary in database home has wrong permission:
ls -l $RDBMS_HOME/bin/oracle
-rwxr-x--x 1 oracle asmadmin 184286251 Aug 9 16:25 /home/oracle/app/oracle/product/11.2/db/bin/oracle
-rwxr-x--x 1 oracle asmadmin 184286251 Aug 9 16:25 /home/oracle/app/oracle/product/11.2/db/bin/oracle
The permission "-rwxr-x--x" is wrong as it's missing suid bit, oracle binary should have permission of 6751:
-rwsr-s--x 1 oracle asmadmin 184286251 Aug 9 16:25 /home/oracle/app/oracle/product/11.2/db/bin/oracle
Note: If Job Role Separation is in place, the group will be <asmadmin>, otherwise it will be <oinstall>
3. File System for database home does not support setuid/suid or has nosetuid/nosuid set:
mount| grep <mount_point_of_ORACLE_HOME>
/home/oracle on /dev/dsk/diskoracle read/write/nosuid..
/home/oracle on /dev/dsk/diskoracle read/write/nosuid..
Solution
Solution is to make sure file system for database home has setuid/suid set, database binary($RDBMS_HOME/bin/oracle) has correct ownership and permission, and listener owner is able to access database oracle binary (as listener owner, "ls -l $RDBMS_HOME/bin/oracle" will tell)If its Job Role Separation environment, please refer to the following document:
Oracle® Grid Infrastructure
Installation Guide
11g Release 2 (11.2)
Oracle ASM Job Role Separation Option with SYSASM
References
NOTE:970619.1 - ORA-12545 or ORA-12537 Reported while Connecting to RAC through SCAN nameNOTE:975457.1 - How to Troubleshoot Connectivity Issue with 11gR2 SCAN Name
相关内容
产品
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Database Configuration Assistant
DATABASE CONFIGURATION; DBCA; LISTENER.LOG; OWNERSHIP; PERMISSION DENIED; TNS; TNS CONNECTION CLOSED; TNS LISTENER
- ORA-12537 if Listener (including SCAN Listener) and Database are Owned by Different OS User [ID 1069
- ORA-12537 ORA-12547 or TNS-12518 if Listener (including SCAN Listener) and Data
- SCAN listener and Node listener – How does it work
- TNSNAMES.ORA, LISTENER.ORA and SQLNET.ORA
- TNSNAMES.ORA, LISTENER.ORA and SQLNET.ORA
- listener.ora
- listener.ora
- listener.ora
- "Invalid username/password or database/scan listener not up"
- 9.user input and frame listener
- 11.2 : ORA-12518 Listener Hangs and Reports "Too Many Open Files" (Doc ID 1527483.1)
- tnsnames.ora & listener.ora
- tnsnames.ora&listener.ora
- How to Modify SCAN Setting or SCAN Listener Port after Installation (文档 ID 972500.1)
- the simplest sample of listener.ora and tnsnames.ora
- scan listener is not running
- 主机名与listener.ora
- listener.ora 配置说明
- C# 使用定时任务 之 Timer类
- asp.net的google分页
- LINUX下文件字符集编码查看与转换并文件名编码转换
- Myeclipse弹出 Multiple Errors have Occurred
- 二叉堆排序
- ORA-12537 if Listener (including SCAN Listener) and Database are Owned by Different OS User [ID 1069
- 谢尔排序-shell sort
- 佳能软件不用光盘安装升级包的方法
- 用R语言计算信息熵
- error LNK2019: 无法解析的外部符号
- EXT JS学习网站
- 神舟III号 USART-COM1工程配置
- PostgreSQL启动过程中的那些事七:初始化共享内存和信号十七:shmem中初始化AutoVacuum相关结构
- Launcher源码初探