News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
How to Create BI Publisher Report in Oracle OEM – Make DBA Life Easy
Create a Database Connection Go to BI Publisher -> Administration->JDBC Connection Create a Data Model New->Data Model -> Upper Left '+' icon -> SQL Query -> Data -> View -> Table View -> Save as Sample Data -> Top Right Save Data Model Create a Report Select Blank( Portrait ) -> Text Item ( for…
How to Change Global_Name for a PDB after Added Default Domain – Make DBA Life Easy
For some reason, a database has to be reconfigured with a domain name ".world". After change the spfile and bounced the database, we need change the global_name manually. Check current global_name in CDB: SQL> select * from global_name;GLOBAL_NAME--------------TESTDB 2. Drop database links now, and need recreate them later. because they are inaccessible after global_name changed.…
How to Drop an Orphan LOB in Oracle Database – Make DBA Life Easy
In Oracle 11.2.0.3 database, after dropped some tables, there are still lob objects in dba_objects and dba_segments. Find the table name the lob belongs to: SQL> show parameter recyclebinNAME TYPE VALUE------------------------------------ ----------- -----------------------recyclebin string on SQL> select u.name, o.name TABLENAME, decode(bitand(c.property, 1), 1, ac.name, c.name) as column_name from sys.obj$ o, sys.col$ c, sys.attrcol$ ac,sys.lob$ l,sys.obj$…
Can you delete a service still with connections in Oracle database – Make DBA Life Easy
Service created from srvctl SQL> select count(*) from gv$session where service_name='test'; COUNT(*)---------- 1SQL> select inst_id,SERVICE_ID,NAME,NAME_HASH,NETWORK_NAME,CREATION_DATE from gv$services where NAME='test'; INST_ID SERVICE_ID NAME NAME_HASH NETWORK_NA CREATION_DATE---------- ---------- ------ ---------- ---------- -------------------- 1 4 test 3237892936 test 19-APR-2024 13:43:50 SQL> exec dbms_service.DELETE_SERVICE('test');BEGIN dbms_service.DELETE_SERVICE('test'); END;*ERROR at line 1:ORA-44305: service test is runningORA-06512: at "SYS.DBMS_SERVICE", line 68ORA-06512: at "SYS.DBMS_SERVICE",…
emctl status agent : Status agent Failure:unable to connect to http server at [handshake has no peer] – Make DBA Life Easy
OEM agent is unhealthy with the following errors: $ emctl status agentOracle Enterprise Manager Cloud Control 13c Release 4Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.---------------------------------------------------------------Status agent Failure:unable to connect to http server at https://racnode1:3872/emd/lifecycle/main/. [handshake has no peer]$ emctl stop agentOracle Enterprise Manager Cloud Control 13c Release 4Copyright (c) 1996, 2020 Oracle Corporation.…
How to Debug ‘cluvfy” or “runcluvfy.sh” – Make DBA Life Easy
Debug “cluvfy” or “runcluvfy.sh”: $ rm -rf /tmp/cvutrace$ mkdir /tmp/cvutrace$ export CV_TRACELOC=/tmp/cvutrace$ export SRVM_TRACE=true$ export SRVM_TRACE_LEVEL=1$ cluvfy stage -pre dbinst -allnodes -r 12.2 -d /u01/app/oracle/product/12.2.0/dbhome_1$ ls -ltr /tmp/cvutracetotal 1960-rw-r--r-- 1 grid oinstall 0 Sep 8 21:46 cvutrace.log.0.lck-rw-r--r-- 1 grid oinstall 0 Sep 8 21:47 cvuhelper.log.0.lck-rw-r--r-- 1 grid oinstall 1586 Sep 8 21:47 cvuhelper.log.0-rw-r--r-- 1 grid…
Oracle Golden Gate Missing Archive Log Files – Make DBA Life Easy
OGG extract process is abended due to the missing archive logs as showing in GG error log: 2023-01-21T01:19:23.197+1100 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, CAP01.prm: Could not find archived log for sequence 99 thread 2 under default destinations SQL <SELECT name FROM v$archived_log WHERE sequence# = :1 AND thread# = :2 AND resetlogs_id =…
ERROR OGG-01172 Discard file (/home/oracle/ggs/dirrpt/REP01.dsc) exceeded max bytes (3000000) – Make DBA Life Easy
The replicate process ABENDING due to the following errors exist in replicate process report: ERROR OGG-01172 Discard file (/home/oracle/ggs/dirrpt/REP01.dsc) exceeded max bytes (3000000). SOLUTION Increase the discardfile maximum size in replicate parameter file from default 3M to 100M: discardfile /home/oracle/ggs/dirrpt/REP01.dsc, purge, megabytes 100
OGG-00901 Failed to lookup object ID – Make DBA Life Easy
When starting up OGG extract with the following error in ggserr.log : ERROR OGG-00901 Failed to lookup object ID for table GG.D7A_GGS_TRACEERROR OGG-01668 Oracle GoldenGate Capture for Oracle,CAP.prm:PROCESS ABENDING Check the parameter file of capture with one line: tractable GG.D7A_GGS_TRACE SOLUTION Manually create trace table as required. GGSCI>info credentialstoreGGSCI> DBLOGIN USERIDALIAS ggorGGSCI>DBLOGIN USERID gg, PASSWORD…
[INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’ – Make DBA Life Easy
Running Oracle 19c gridSetup.sh or runInstaller on Linux 8, the following errors occur: [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’ SOLUTION Set the following variable: $ export CV_ASSUME_DISTID=OEL7.8 OR Edit the file cvu_config which is located in $ORACLE_HOME/cv/admin, change the line from # Fallback to this distribution id #CV_ASSUME_DISTID=OEL5 to # Fallback…
[INS-06006] Passwordless SSH connectivity not set up between the following node(s): [racnode2] – Make DBA Life Easy
When attempting to configure 19c grid infrastructure on Linux 8 by running gridSetup.sh the following error occurs in SSH connectivity step: [INS-06006] Passwordless SSH connectivity not set up between the following node(s): [racnode2] Even after manually setup SSH equivalence successfully, the error still exists and user cannot continue the GI installation and configuration. SOLUTION Apply…
19c gridSetup.sh throws errors: PRVG-11095 : The TCP system call “connect” failed with error “113” while executing exectask on node “racnode2” – Make DBA Life Easy
The following errors occur when running Oracle 19c gridSetup.sh: Summary of node specific errors racnode2 - PRVG-11067 : TCP connectivity from node "racnode2": "10.2.2.2" to node "racnode1": "10.2.2.1" failed. PRVG-11095 : The TCP system call "connect" failed with error "113" while executing exectask on node "racnode2" No route to host - Cause: Errors occurred while attempting…
ORA-01950: no privileges on tablespace ‘USERS’ – Make DBA Life Easy
SQL> create table test ( id number );create table test ( id number )*ERROR at line 1:ORA-01950: no privileges on tablespace 'USERS' SOLUTION SQL> select TABLESPACE_NAME,USERNAME,MAX_BYTES,BYTES from dba_ts_quotas where USERNAME='SCOTT';no rows selected SQL> alter user scott default tablespace users quota 10m on users; User altered. SQL> create table test ( id number ); Table created.…
ORA-65036: pluggable database not open in required mode – Make DBA Life Easy
When clone a pluggable database from remote CDB database, the following error occurs: SQL> create pluggable database PDB1 from PDB1@remote_db_link;create pluggable database PDB1 from PDB1@remote_db_link*ERROR at line 1:ORA-17628: Oracle error 65036 returned by remote Oracle serverORA-65036: pluggable database not open in required mode SOLUTION Make sure source PDB is opened on all instances, otherwise on…
What is SYSRAC ? – Make DBA Life Easy
The SYSRAC administrative privilege is used only by the Oracle agent of Oracle Clusterware to connect to the database using operating system authentication. Unlike SYSDBA, SYSDG, SYSBACKUP and SYSKM , the SYSRAC privilege only allows OS authentication by the Oracle agent of Oracle Clusterware. Password files and strong authentication cannot be used with the SYSRAC privilege. SQL>…
Could not load program sqlplus:Dependent module libsqlplus.so could not be loaded. Could not load module libsqlplus.so – Make DBA Life Easy
Trying to run sqlplus from Oracle 19c client on AIX, the following errors occur: $ sqlplus Could not load program sqlplus: Dependent module libsqlplus.so could not be loaded. Could not load module libsqlplus.so. System error: No such file or directory SOLOTION $ oslevel 7.1.0.0 $ export LIBPATH=$LIBPATH:/u01/oracle/product/19.0.0/client_1/lib It seems AIX does not use LD_LIBRARY_PATH.
ORA-28007: the password cannot be reused – Make DBA Life Easy
Tring to change the user password to an old one, it failed: SQL> alter user tester identified by "Welcome123#test"; alter user tester identified by "Welcome123#test"; * ERROR at line 1: ORA-28007: the password cannot be reused SOLUTION Check the profile used by user tester. SQL> alter profile default limit PASSWORD_REUSE_MAX unlimited; Profile altered. SQL> alter…
EM 13c: The agent has been blocked by the OMS – Make DBA Life Easy
OEM agent was blocked with the following messages in agent log: ...... 2023-12-05 20:16:59,448 [158:905DEBE9] INFO - The agent has been blocked by the OMS. 2023-12-05 20:16:59,448 [158:905DEBE9] INFO - Reason the OMS blocked the agent: Resync...... SOLUTION Perform agent resynchronization from OEM console.AND / OR Modify bounceCtr value in agntstmp.txt file to one less than…
PRVG-11138 PRVG-11352 When Running cluvfy or runcluvfy.sh – Make DBA Life Easy
When running runcluvfy.sh or cluvfy, the following messages appear: Multicast or broadcast check - This task checks that network interfaces in subnet are able to communicate over multicast group or broadcast IP address Details: - PRVG-11138 : Interface "ens8" on node "racnode1" is not able to communicate with interface "ens8" on node "racnode1" over multicast group "224.0.0.251"…
gridSetup.sh ERROR: Unable to verify the graphical display setup. This application requires X display. Make sure that xdpyinfo exist under PATH variable. – Make DBA Life Easy
When setting up 19c GI by running "gridSetup.sh", the following errors occur: $ ./gridSetup.sh ERROR: Unable to verify the graphical display setup. This application requires X display. Make sure that xdpyinfo exist under PATH variable. No X11 DISPLAY variable was set, but this program performed an operation which requires it. SOLUTION Enable X11forwarding in /etc/ssh/sshd_config.…
OPatch Error: This Java instance does not support a 64-bit JVM.opatch – Make DBA Life Easy
When trying to run opatch, the following error occurs: $ opatch Error: This Java instance does not support a 64-bit JVM. Please install the desired version. OPatch failed with error code 1 SOLUTION Download the right opatch. For 19c opatch on Linux x86-64 download "p6880880_190000_Linux-x86-64.zip" instead of "p6880880_190000_Linux.zip".
How to Add a Disk into ASM DiskGroup Safely – Make DBA Life Easy
For a client, there are situations when adding a disk into ASM disk group failed, finally rebooting the server is required to resolve this issue. According to Oracle support suggestion, we can create a test diskgroup by using this new disk, if everything is successful, then we can drop this test diskgroup, and add the…
How to Find DBID from OEM Repository – Make DBA Life Easy
A client has drooped an Oracle database, and client wants to know DBID of the dropped database. From OEM repository, we can query some tables or views to get DBID for a specific database. for example : SQL> select HOST_NAME,TARGET_NAME,TARGET_TYPE,TARGET_GUID,DBID,VERSION from MGMT$DB_CPU_USAGE where upper(TARGET_NAME)='DB_NAME';
[FATAL] [INS-32042] The Installer has detected that the user (oracle) is not member of the central inventory group – Make DBA Life Easy
Silent installation of Oracle client 19c gets the following fatal error: [FATAL] [INS-32042] The Installer has detected that the user (oracle) is not member of the central inventory group: ACTION: Make sure that the user (oracle) is member of the central inventory group (). INFO: [Nov 26, 2023 12:08:20 PM] Advice is ABORT CAUSE Check…
Increase Voting Diskgroup Size – Make DBA Life Easy
Here is an example of how to increase GI voting disk group size. Add a new disk with bigger size into current voting disk group. Drop the old small size disk. SQL> select NAME, STATE,VOTING_FILES,total_mb, free_mb from v$asm_diskgroup where NAME='VOTE_OCR"; NAME STATE VOTING_FILES TOTAL_MB FREE_MB VOTE_OCR MOUNTED Y 51196 6352 SQL> alter diskgroup VOTE_OCR add…
ORA-20247: EMD_URL is Invalid: Cannot provide null emd url – Make DBA Life Easy
When adding a cluster database into OEM, and click "Submit" , the following error occurs: ORA-20247: EMD_URL is Invalid: Cannot provide null emd url Workaround Manually add the cluster database into OEM by using emcli on OMS server: $ emcli login -username=sysman Enter password : Login successful Add first instance target of the cluster database…
ORA-12532: TNS:invalid argument – Make DBA Life Easy
Trying to run sqlplus to logon to a database, the following error occurs: $ sqlplus scott SQL*Plus: Release 12.2.0.1.0 Production on Tue Nov 14 14:46:12 2022 Copyright (c) 1982, 2016, Oracle. All rights reserved. Enter password: ERROR: ORA-12532: TNS:invalid argument CAUSE User password contains character "@"
PRCA-1000 : ASM Disk Group DSGRP123 does not exist – Make DBA Life Easy
Trying to start up a database, and got the following error messages: $ srvctl start database -d testdb PRCR-1079 : Failed to start resource ora.testdb.db CRS-2640: Required resource 'ora.DSGRP123.dg' is missing. $srvctl config database -d TESTDB ... .. . PRCD-1012 : Failed to retrieve disk group list for database TESTDB. PRCR-1035 : Failed to look…
PKI-04015: Trusted cert cannot be removed – Make DBA Life Easy
Trying to remove the trusted certificates from the wallet and getting the errors $ orapki wallet remove -wallet . -trusted_cert_all Oracle PKI Tool : Version 11.2.0.4.0 - Production Copyright (c) 2004, 2013, Oracle and/or its affiliates. All rights reserved. Enter wallet password: PKI-04015: Trusted cert cannot be removed. CN=A,O=B,C=C SOLUTION $ orapki wallet display -wallet…
ORA-01591: lock held by in-doubt distributed transaction 1.23.456789 – Make DBA Life Easy
SQL> select local_tran_id from dba_2pc_pending; LOCAL_TRAN_ID ---------------------- 1.23.456789 SQL> select local_tran_id, state,fail_time,force_time, retry_time from dba_2pc_pending; LOCAL_TRAN_ID STATE FAIL_TIME RETRY_TIME MIXED ------------ ----- --------- ---------- ----- 1.23.456789 prepared 1-OCT-23 22-OCT-23 no SQL> rollback force '1.23.456789'; Rollback complete. SQL> exec dbms_transaction.purge_lost_db_entry( '1.23.456789'); BEGIN dbms_transaction.purge_lost_db_entry( '1.23.456789'); END; * ERROR at line 1: ORA-01453: SET TRANSACTION must be first…
OGG Agent instance directory should be outside ORACLE_HOME – Make DBA Life Easy
The following error occurs when creating OGG monitoring instance: $ ./createMonitorAgentInstance.sh Please enter absolute path of Oracle GoldenGate home directory : /home/oracle/ggs Please enter absolute path of OGG Agent instance : /home/oracle/oggmon_agent/instance1 OGG Agent instance directory should be outside ORACLE_HOME. RESOLUTION $ unset ORACLE_HOME $ ./createMonitorAgentInstance.sh Please enter absolute path of Oracle GoldenGate home directory…
How to Clone 11.2 Oracle Client Software – Make DBA Life Easy
Client accidently uninstalled Oracle 11.2 Oracle client. Here is the quick way to clone 11.2 Oracle client from another server installations. Make a tar or zip of the Oracle Client home from another server. $ tar -cvf 11204.tar ./client_1 2. scp the tar file to the server 3. Untar the file to the location of the…
Software Library OMS Shared location default_loc is not accessible – Make DBA Life Easy
Failed to pass checking accessibility by : Login to EM > Setup > Provisioning and Patching > Software LibraryClick to highlight the row > Actions(drop-down) > Check Accessibility Solution Make sure OMS host preferred credential is setup correctly.
Short Running Metric Collection Status is DOWN in OEM Cloud Control – Make DBA Life Easy
Short Running Task Worker metric collection status is shown as Down from OMS and Repository monitoring : From the Management Services and Repository target page, Navigate: OMS and Repository > Monitoring > All Metrics > select Repository Operations Status Following query running as sysman shows No Short Running task workers are running, which causes a…
How to Relocate Flashback Logs to New Disk Group – Make DBA Life Easy
we do not have any method to manually move old restore logs to new location via OS commands. Please drop any old restore points & create new restore points so that +FRAOLD gets cleared & new logs start generating in +FRANEW. For restore point only: SQL> select GUARANTEE_FLASHBACK_DATABASE,NAME from v$restore_point; Drop Restore Point in primary…