I Google[d] for this error ORA-12560: TNS:protocol adaptor error but not able to find the actual reason and how to solve this error ? Can anyone tell me a perfect ...
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 result will be "ORA-00942: table or view does not exist" even though user2 does have insert and select privileges on user1.customer table and is correctly prefixing the table with the schema owner name. To avoid the problem, you must grant select privilege on the sequence:
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.
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.
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.
This is really useful if you're getting the ORA-00054 from batch jobs, but I suspect most people landing here (including the OP, and me) are doing some development and have left a session open doing inserts on the same table they're trying to drop and recreate. KILL SESSION is the right answer for these people.