Category: Database Issues
-
ORA-00051: time-out occurred while waiting for resource
This error indicates there was timeout and you can try to restart the database with the following commands: $ sqlplus / as sysdba $shutdown immediate $startup
-
ORA-00918: column ambiguously defined
This error is faced when we use JOINS where a column name is present in both the tables and we try to Select it in the query. In the below example , if column_1 is present in both, table_1 and table_2, you will face the error ORA-00918: SELECT column_1, column_2FROM table_1INNER JOIN table_2ON table_1.column_1 =…
-
ORA-02010: missing host connect string
When I had faced this error , I resolved it by adding single quotes to the SID name. The original query was like: which I modified into:
-
ORA-01461: can bind a LONG value only for insert into a LONG column
You will get this error when you try to insert a LONG value into a column which is not of a LONG Datatype. You will need to check if any LONG value is getting inserted and modify the statement accordingly.
-
ORA-01830: date format picture ends before converting entire input string
If you get such an error , it means that you may need to use the TO_DATE function. For example, you may get this error for a query like below: INSERT INTO Website_NamesVALUES(100, ‘IT_Sector_Help’, ’11-JAN-2014 8:26 PM’); Solution : Use the TO_DATE function in order to solve the error. INSERT INTO Website_NamesVALUES(100, ‘IT_Sector_Help’, TO_DATE(’11-JAN-2014 8:26…
-
ORA-00933: SQL command not properly ended
This is an ORA Error which is faced when there something unexpected before the semicolon ; Most commonly, it occurs when you try to use ORDER BY in the WHERE Clause for an INSERT or DELETE Operation.
-
ORA-00257:archiver error
One day suddenly you may get this runtime error. It happens when the archivelog has reached the limit. In such case it is good to delete the archivelogs. Below are the steps: Connect to the Command prompt and login with your Database user. Execute the below commands: SQL> rman TARGET / RMAN> delete archivelog all;…
-
ORA-20900: RDS only supports Oracle Managed Files
While setting up a database on AWS RDS, I got the error (ORA-20900) while creating a tablespace with the below query: SQL> CREATE TABLESPACE “IT_HELP” DATAFILE ‘IT_HELP.dbf’ size 10G; Solution: As per the AWS documentation I used the below query instead and the tablespace got created. We need to use BIGFILE keyword and skip the…
-
ORA-01034: ORACLE not available
ORA-01034 means that the Oracle Database is in Shutdown state and hence you are not able to login with your user. I got the below error: ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No such file or directoryProcess ID: 0Session ID: 0 Serial number: 0 In order to solve it,…
-
ORA-12631: Username retrieval failed
While trying to login to Oracle Database via sqlplus you may get the error : ORA-12631: Username retrieval failed In order to fix the issue I made the following changes and it worked : Search for sqlnet.ora file. It will be present in ORACLE_HOME/NETWORK/ADMIN directory. Open it. Change the parameter SQLNET.AUTHENTICATION_SERVICES= (NTS) to SQLNET.AUTHENTICATION_SERVICES =…