While runnig duplicate database, oracle can give ORA-17627, ORA-12154, ORA-17629 errors. Error [oracle@oracle19cdg2 admin]$ rman target sys@ORA19C auxiliary sys@DG2 Recovery Manager: Release 19.0.0.0.0 – Production on Sat Jul 6 14:21:44 2024 Version 19.22.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. target database Password: connected to target database: ORA19C (DBID=1219995577) auxiliary database…
Category: Errors and Solutions
ORA-28031: Maximum of 148 enabled roles exceeded for user SYS. Not loading all the roles.
If you take “Maximum of 148 enabled roles exceeded for user SYS. Not loading all the roles” error, ıt means of your SYS user’s roles are exceed 148. Solution You can connect with sys user and revoke unnessesary roles. This will resolve your problem.
ORA-01078 failure in processing system parameters LRM-00108 could not open parameter file Oracle RAC
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
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…