Problem ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ‘//dbs/init.ora’ Solution cd $GRID_HOME/bin chmod 6751 oracle
Category: Errors and Solutions
Turkish Characters Order By Sort Problem in Oracle
Using order by in column that contains special Turkish characters like ç,ğ,ö,ş,ü can be problem. All special Turkish characters can be listed at the end of the list. You can resolve this problem with NLSSORT. select * from tablename order by NLSSORT(columnname,’NLS_SORT=TURKISH’)
TNS-12547: TNS:lost contact and Linux Error: 32: Broken pipe While Connect Oracle 12c Data Guard
I installed Oracle 12c Data Guard, everything was okey. But, I got an error like below when I wanted to connect data guard database with Toad or SQL Developer. tnsping was okey. Error SQL Developer : Status : Failure -Test failed: IO Error: Got minus one from a read call Listener.log 10-OCT-2017 15:01:16 * (CONNECT_DATA=(CID=(PROGRAM=SQL…
Oracle 11g R2 Resize Redo Log Size on Data Guard and Primary Database
Sometimes, you may need to change redo log size to perform optimum size for performance. If you want to change redo log size of both standby side and primary side, you can use below commands. Current Status Of Redo Logs Primary Side SQL> select group#,sum(bytes/1024/1024)”Size in MB” from v$log group by group#; GROUP# Size in…
Update Another Column On The Same Table With Trigger While Updating Table in Oracle
If you want to do update another column when execute an update on table, you can use before update trigger. If you use after update trigger, you can get some errors. if you use pragma autonomous_transaction parameter as declare in trigger you can get errors like that are “ORA-00060: deadlock detected while waiting for resource”, “ORA-06512:…
Oracle 11g Oracle Checkpoint Not Complete, Cannot Allocate New Log Warning
Error: Checkpoint not complete, Cannot Allocate New Log Warning Thread 1 cannot allocate new log, sequence 125487 Checkpoint not complete Solution: Checkpoint not complete messages are generated due to the logs are switching so fast that the checkpoint associated with the log switch isn’t complete. You should increase redo log file size and amount to…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19700 to ORA-20000
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19700 to ORA-20000 ORA-19700: device type exceeds maximum length of string Cause: The device type indicated is invalid. Action: Supply a correct device type and retry the allocation. ORA-19701: device name exceeds maximum length of string Cause: The device name indicated is invalid. Action: Supply a correct device name and retry the…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19500 to ORA-19700
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19500 to ORA-19700 ORA-19500: device block size string is invalid Cause: the device block size returned by sequential I/O OSD is invalid Action: If the block size was set by using the PARMS option of the Recovery Manager ALLOCATE CHANNEL command, then the specified block size must be changed. If…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19200 to ORA-19400
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19200 to ORA-19400 ORA-19200: Invalid column specification Cause: All input arguments must be valid columns Action: Specify a valid list of columns ORA-19201: Datatype not supported Cause: The particular datatype is not supported in the XMLGEN operator Action: Specify only supported datatypes as arguments to the XMLGEN operator ORA-19202: Error…
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19000 to ORA-19200
Oracle 12c R2 Error Codes and Solution Suggestions from ORA-19000 to ORA-19200 ORA-19000: missing RELATIONAL keyword Cause: The keyword RELATIONAL in the work OBJECT RELATIONAL is missing in the XMLTYPE storage clause specification. Action: Supply the RELATIONAL keyword in the storage clause ORA-19001: Invalid storage option specified Cause: An invalid storage option was specified for the XMLType. Action: Supply…