42 ORA-00904-invalid identifier errors are frequently caused by case-sensitivity issues. Normally, Oracle tables and columns are not case sensitive and cannot contain punctuation marks and spaces. But if you use double quotes to create a quoted identifier, that identifier must always be referenced with double quotes and with the correct case.
The Listener in the DB Server set to localhost. Put the hostname for the computer solve my problem. hi, my problem is i cannot find oracleservice in service, what should i do? thank u my admin folder doesn't have a lister.ora file, and my Services don't list "Oracle [anything]" where is %ORAACLE_HOME% directory and how to get it ?
-1 ORA-12154: TNS:could not resolve the connect identifier specified (PLSQL Developer) Answer: Go to the folder where you have installed ORACLE DATABASE. such as E:\oracle\product\10.2.0 [or as your oracle version]\db-1\network\ADMIN and then copy the two files (1) sqlnet.ora, (2) tnsnames.ora and close this folder.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small Asked 12 years, 7 months ago Modified 5 years, 9 months ago Viewed 749k times
The id/pw I was using was correct, but I was getting ORA-01017 Invalid Username/Password on one particular connection only. It turned out that my connection settings in Oracle SQL Developer had the "Use DB Proxy Authentication" turned on in the "Proxy User" tab.
19 ORA-03113: end-of-file on communication channel Is the database letting you know that the network connection is no more. This could be because: A network issue - faulty connection, or firewall issue The server process on the database that is servicing you died unexpectedly. For 1) (firewall) search tahiti.oracle.com for SQLNET.EXPIRE_TIME.