Error: Database connect failed with: ORA-12560: TNS:protocol adapter error (DBD ERROR: OCIServerAttach)
Datapatch give error while try to connecting to the database.
datapatch -verbose
SQL Patching tool version 19.26.0.0.0 Production on Thu Jun 12 08:51:04 2025
Copyright (c) 2012, 2025, Oracle. All rights reserved.
Log file for this invocation: F:\Test\oracle19\cfgtoollogs\sqlpatch\sqlpatch_8992_2025_06_12_08_51_04\sqlpatch_invocation.log
Connecting to database...
Error: prereq checks failed!
Database connect failed with: ORA-12560: TNS:protocol adapter error (DBD ERROR: OCIServerAttach)
Please refer to MOS Note 1609718.1 and/or the invocation log
F:\Test\oracle19\cfgtoollogs\sqlpatch\sqlpatch_8992_2025_06_12_08_51_04\sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Thu Jun 12 08:51:05 2025Cause:
The Oracle Service for database is not started in windows or database is not in open state in Linux
Solution:
Start the database service from services.msc or Start the database
sqlplus / as sysdba
Startup