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
|