|
- sql - ORA-12560: TNS:protocol adaptor error - Stack Overflow
-2 In my case, (ORA-12560: TNS protocol adapter error)Issue cause of database connection issue like database, user name and password Once you got the issue Initially you have to check connection details, after check the oracle service and further more
- SQL Error: ORA-00942 table or view does not exist
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
- sql - ORA-00904: invalid identifier - Stack Overflow
More informations about your ERROR ORA-00904: string: invalid identifier Cause: The column name entered is either missing or invalid Action: Enter a valid column name A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #
- ORA-12154: TNS:could not resolve the connect identifier specified . . .
ORA-12154: TNS:could not resolve the connect identifier specified I am able to use SQLPLUS from the command line to connect to the database, and tnsping returns successfully, but I can't figure out why PLSQL Developer will not work - it's using the right tnsnames ora file, and the connection string in there is correct because it's the same one
- ORA-03113 while executing a sql query - Stack Overflow
I have a 400 line sql query which is throwing exception withing 30 seconds ORA-03113: end-of-file on communication channel Below are things to note: I have set the timeout as 10 mins There is one
- ORA-03113: end-of-file on communication channel after long inactivity . . .
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
- ORA-01403: no data found for Select into - Stack Overflow
I am getting ORA-01403: no data found exception for the following query What are the possibilities of this error? SELECT trim (name) INTO fullname FROM ( SELECT n name FROM directory
- How to fix Oracle SQL Developer - vendor code 17002?
Vendor code 17002 usually comes when Listener Control is down lsnrctl (Listener Control) is an SQL*Net utility used for controlling database listeners A listener is required for allowing remote (not local) clients to connect to the Oracle database via the network You can validate it by using below command lsnrctl status If its down you can use the below command to start it lsnrctl start
|
|
|