Some of the Oracle database errors I encountered
Posted by jpluimers on 2021/05/26
For my future self:
'Invalid Oracle Home: '
Not sure what exactly fixed this, but likely either of these:
- Setting the [WayBack]
TNS_ADMINpointing to a directory having a [WayBack]TNSNAMES.ORA - Having Oracle Instant Client installed and on the
PATH.
It can also have to do with Win32 versus Win64.
Related:
- [WayBack] Invalid Oracle Home: <nothing> – Devart Forums
- [WayBack] delphi – TOraSession.Connect => Invalid Oracle Home: <nothing> – Stack Overflow
- [WayBack] Invalid Oracle_Home in Toad for Oracle Xpert Trial (32bit) DBA Edition 13.0.0.80 – Toad for Oracle – Toad World® Forums
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
This was using tnsping (actually the alternative McTnsPing); cause was the DBMS server VM being down..
ORA-12545: Connect failed because target host or object does not exist
It meant the VPN connection to the site having the Oracle server was down.
Related: [WayBack] ORA-12545 – Oracle FAQ
ORA-01017: invalid username/password; logon denied
There was confusion on which test credentials to use.
Related (as there are some bugs, case sensitivity issues, and confusion around special characters like $):
- [WayBack] Oracle ORA-01017 tips
- [WayBack] oracle – ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client – Stack Overflow
Need Oracle 8 Call Interface
a
ORA-06550: line 2, column 36:
Actual error:
ORA-06550: line 2, column 36: PLS-00103: Encountered the symbol ":" when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with character set speci.
The cause was a bit of PL/SQL as per [WayBack] ORA-06550 tips.
It was odd, as I was calling
Source: “SYS.DBMS_APPLICATION_INFO.SET_CLIENT_INFO” – Google Search which is part of package “SYS.DBMS_APPLICATION_INFO”.
In the end it all turned out that the underlying library was trying to use OCI 7 in stead of more modern OCI, so the OCI 7 API did not accept the more modern data.
ORA-03135: connection lost contact Process ID: 14513 Session ID: 19 Serial number: 8319
VPN connection died; application did not have re-connect logic to restore the database connection.
ORA-12545: Connect failed because target host or object does not exist
a
ORA-12545: Connect failed because target host or object does not exist
a
ORA-12545: Connect failed because target host or object does not exist
a
ORA-12545: Connect failed because target host or object does not exist
a
ORA-12545: Connect failed because target host or object does not exist
a
–jeroen
The Wiert Corner - irregular stream of stuff 
Leave a comment