Hello Friend's,
What is the ORA-12547 Error?
The ORA-12547 error represents a TNS that relates to a Transparent Network Substrate. It usually indicates that the Oracle client cannot connect to the Oracle database server. More specifically, the error message "TNS:lost contact" indicates that the client has lost contact with the server while attempting to connect. Since this might be sometime during the connection process, it becomes difficult to diagnose and resolve.
So lets get started
Error :
oracle@DXDSRV:/u01/app/oraInventory/ContentsXML> sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 27 22:48:35 2024
Version 19.10.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Shutdown Database :
oracle@DXDSRV:/u01/app/oraInventory/ContentsXML> sqlplus sys@RTDSDR as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 27 22:48:49 2024
Version 19.10.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Enter password:
Last Successful login time: Mon Feb 03 2025 22:35:04 +03:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
SQL> col DB_UPTIME for a35
col DATABASE_ROLE for a20
SQL> SQL> col DB_VERSION for a20
set lines 200
SQL> SQL> col LOG_MODE for a20
set pages 9999 lines 300
col OPEN_MODE for a10
col HOST_NAME for a30
select name DB_NAME,HOST_NAME,DATABASE_ROLE,OPEN_MODE,version DB_VERSION,LOGINS,LOG_MODE,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB_UPTIME" from v$dSQL> atabase,gv$instance;SQL> SQL> SQL>
DB_NAME HOST_NAME DATABASE_ROLE OPEN_MODE DB_VERSION LOGINS LOG_MODE DB_UPTIME
--------- ------------------------------ -------------------- ---------- -------------------- ---------- -------------------- -----------------------------------
RTDS DXDSRV PRIMARY READ WRITE 19.0.0.0.0 ALLOWED ARCHIVELOG 02-FEB-2025 14:08:49
SQL>
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
Detach oracle Home :
oracle@DXDSRV:/u01/app/oraInventory/ContentsXML> $ORACLE_HOME/oui/bin/runInstaller -detachHome -silent ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME="Ora19cDBHome1"
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 32767 MB Passed
The inventory pointer is located at /etc/oraInst.loc
You can find the log of this install session at:
/u01/app/oraInventory/logs/DetachHome2024-05-27_10-50-23PM.log
'DetachHome' was successful.
Clone Oracle Home :
oracle@DXDSRV:/u01/app/oraInventory/ContentsXML> cd $ORACLE_HOME/clone/bin
oracle@DXDSRV:/u01/app/oracle/product/19.0.0/dbhome_1/clone/bin> echo $ORACLE_HOME
/u01/app/oracle/product/19.0.0/dbhome_1
oracle@DXDSRV:/u01/app/oracle/product/19.0.0/dbhome_1/clone/bin> perl clone.pl -silent -defaultHomeName ORACLE_HOME="/u01/app/oracle/product/19.0.0/dbhome_1" ORACLE_BASE="/u01/app/oracle"
[INFO] [INS-32183] Use of clone.pl is deprecated in this release. Clone operation is equivalent to performing a Software Only installation from the image.
You must use /u01/app/oracle/product/19.0.0/dbhome_1/runInstaller script available to perform the Software Only install. For more details on image based installation, refer to help documentation.
Starting Oracle Universal Installer...
You can find the log of this install session at:
/u01/app/oraInventory/logs/cloneActions2024-05-27_10-52-08PM.log
.................................................. 5% Done.
.................................................. 10% Done.
.................................................. 15% Done.
.................................................. 20% Done.
.................................................. 25% Done.
.................................................. 30% Done.
.................................................. 35% Done.
.................................................. 40% Done.
.................................................. 45% Done.
.................................................. 50% Done.
.................................................. 55% Done.
.................................................. 60% Done.
.................................................. 65% Done.
.................................................. 70% Done.
.................................................. 75% Done.
.................................................. 80% Done.
.................................................. 85% Done.
..........
Copy files in progress.
Copy files successful.
Link binaries in progress.
..........
Link binaries successful.
Setup files in progress.
..........
Setup files successful.
Setup Inventory in progress.
Setup Inventory successful.
..........
Finish Setup successful.
The cloning of OraHome1 was successful.
Please check '/u01/app/oraInventory/logs/cloneActions2025-05-03_10-52-08PM.log' for more details.
Setup Oracle Base in progress.
Setup Oracle Base successful.
.................................................. 95% Done.
As a root user, execute the following script(s):
1. /u01/app/oracle/product/19.0.0/dbhome_1/root.sh
.................................................. 100% Done.
Check Spfile location
oracle@DXDSRV:/u01/app/oracle/product/19.0.0/dbhome_1/dbs> cat initRTDS.ora
spfile='+DATA/RTDSDR/PARAMETERFILE/spfile.258.1160671729'
Add database to ASM
oracle@DXDSRV:/u01/app/oracle/product/19.0.0/dbhome_1/dbs> srvctl add database -d RTDS -o /u01/app/oracle/product/19.0.0/dbhome_1 -spfile +DATA/RTDSDR/PARAMETERFILE/spfile.258.1160671729
Start Database and check , Error will be resolved
oracle@DXDSRV:/u01/app/oracle/product/19.0.0/dbhome_1/dbs> srvctl start database -d RTDS
Hope This helps
Regards
Sultan Khan
