重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: DBCA and Local SQL*Plus Connection Fails With: ORA-12547 [打印本页]

作者: 郑全 时间: 2018-4-30 11:02
标题: DBCA and Local SQL*Plus Connection Fails With: ORA-12547

[size=130%]DBCA and Local SQL*Plus Connection Fails With: ORA-12547: TNS:Lost Contact ORA-12753 (文档 ID 2206832.1)

转到底部

In this Document

Applies to: Oracle Database Configuration Assistant - Version 12.1.0.1 to 12.2 BETA1 [Release 12.1 to 12.2]
Information in this document applies to any platform.
SymptomsInstalling 12.1.0.1 binary and creating database option failed with below error
"Database configuration assistant failed to detect options for this Oracle installation. ORA - 12547: TNS: lost contact".

Changes This was a new server with fresh Oracle software installation.

CauseUsing the strace or DBCA or SQL*Plus following errors were identified:
17717 write(5, "ORA-12753: The Oracle home user "..., 131) = 131
17717 write(5, "\n", 1) = 1
17717 times(NULL) = 531051181
17717 write(5, "ORA-27300: OS system dependent o"..., 91) = 91
17717 write(5, "\n", 1) = 1
17717 times(NULL) = 531051181
17717 write(5, "ORA-27301: OS failure message: E"..., 38) = 38
17717 write(5, "\n", 1) = 1
17717 times(NULL) = 531051181
17717 write(5, "ORA-27302: failure occurred at: "..., 39) = 39
17717 write(5, "\n", 1) = 1
17717 times(NULL) = 531051181
17717 write(5, "ORA-27303: additional informatio"..., 92) = 92
In trace file you will find the full error message:
ORA-12753: The Oracle home user ID does not match the effective user ID of the local client which connected to the Oracle instance.
ORA-27300: OS system dependent operation:check $ORACLE_HOME ownership failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: spstp:4
ORA-27303: additional information: ORACLE_HOME uid does not match euid. uid: 237 euid: 145

The DBCA was launched with oracle user but the ORACLE_HOME was owned by another OS user, eg test.
The problem can also happen when the directory of $ORACLE_HOME itself (top directory of $ORACLE_HOME) owned by another OS user.
SolutionUse correct user to launch dbca ($ORACLE_HOME owner)

ReferencesBUG:18997967 - DBCA FAILS WITH ORA-12547: TNS: LOST CONTACT

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)