News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
13c OEM Information Publisher Reports: Error rendering element. Exception: ORA-00942: table or view does not exist – Make DBA Life Easy
When using the OEM Reporting System you are limited to access the repository only (MGMT_VIEW). So, the solution is to grant select on schema.table_name to MGMT_VIEW. You need give a read permission to MGMT_VIEW. grant select on sysman.TABLE_NAME to MGMT_VIEW; This will help you remove the error while reporting the data from OEM Information publisher.
RMAN-06023 Although Backups Are Available – Make DBA Life Easy
'RMAN RESTORE DATABASE' command fails with the following errors by using a backup control file: RMAN-00571: ==================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ======== RMAN-00571: ==================================================== RMAN-03002: failure of restore command at 21/11/2024 11:09:9 RMAN-06026: some targets not found - aborting restore ....RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no…
ORA-01157 When Standby Database Open Read Only – Make DBA Life Easy
The following errors occur when trying to open a standby database read only: SQL> alter database open read only;alter database open read only*ERROR at line 1:ORA-10458: standby database requires recoveryORA-01157: cannot identify/lock data file 1 - see DBWR trace fileORA-01110: data file 1: '+DATA2/TESTDB/DATAFILE/system.3203.1186181325' When checking ASM file for SYSTEM tablespace, the file exists but…
Opatch or Opatchauto takes long time Due to High Number of Inactive Patches – Make DBA Life Easy
"opatch lsinventory -inactive" shows many inactive patches.Large number of inactive patches can slow down the opatch apply process.Issue still reproduce after executing "opatch util deleteinactivepatches" in this case opatch.properties:retain was set to retain=2.There is also known issue with certain oracle homes where there are more than 1 inactive PSU or RU, a user needs to…
“ORA-16642: DB_UNIQUE_NAME mismatch” while adding a Standby Database into DG Broker – Make DBA Life Easy
The following error occurs while trying to add standby database into data guard broker. DGMGRL> ADD DATABASE TESTDB AS CONNECT IDENTIFIER is TESTDB_DR MAINTAINED AS PHYSICAL;Error: ORA-16642: DB_UNIQUE_NAME mismatch REASON Here primary and standby database DB_UNIQUE_NAME is same as "TESTDB". Make sure DB_UNIQUE_NAME for primary and all standby databases are different.
How to Manually Apply OCW Release Update onto Database Home – Make DBA Life Easy
Found OCW patch was not applied onto database home after applied 19.24 RU, so manual applying is required. $ORACLE_HOME/OPatch/opatch lspatches......30159782;OCW Interim patch for 30159782 For 19.24, the OCW patch id should be "36587798;OCW RELEASE UPDATE 19.24.0.0.0 (36587798)". Let's manually apply it. $ cd 36582629/36587798$ /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch applyOracle Interim Patch Installer version 12.2.0.1.44Copyright (c) 2024, Oracle Corporation.…
How to Connect Oracle GoldenGate Veridata Agent to Autonomous Data Warehouse – Make DBA Life Easy
This post demonstrate how to connect the Oracle GoldenGate Veridata to Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) by using the Oracle Wallet. Downloaded the Wallet_ADWTESTDB.zip from the ADW/ATP console. Unzip the Wallet in the location $ unzip Wallet_ADWTESTDB.zipArchive: Wallet_ADWTESTDB.zipinflating: cwallet.ssoinflating: tnsnames.orainflating: truststore.jksinflating: ojdbc.propertiesinflating: sqlnet.orainflating: ewallet.p12inflating: keystore.jks Add the following into sqlnet.ora WALLET_LOCATION…
GI Postpatch Command Fails Due To rpm Database Corruption At The OS Level – Make DBA Life Easy
The following errors occur when running "$ORACLE_HOME/crs/install/rootcrs.sh -postpatch": 2024-11-09 13:31:20: Executing cmd: /bin/rpm -q sles-release 2024-11-09 13:31:20: Command output: > error: rpmdb: BDB0113 Thread/process 128527/140400711669824 failed: BDB1507 Thread died in Berkeley DB library > error: db5 error(-30973) from dbenv->failchk: BDB0087 DB_RUNRECOVERY: Fatal error, run database recovery > error: cannot open Packages index using db5 -…
Installing a 13.5 Management Agent Using the agentDeploy Script – Make DBA Life Easy
We can install a Management Agent using the agentDeploy.sh script in the following ways: Using EM CLI from the Remote Destination Host Using EM CLI from the OMS Host Using EM CLI from the remote Destination Host Acquiring the Management Agent Software and Downloading it onto the destination Host Using EM CLI. Download and Set…
How to Connect to an Oracle Autonomous Database – Make DBA Life Easy
Connecting to an Autonomous Database using SQL Developer Firstly download a wallet for an Autonomous Database. Overview>Autonomous Database>Autonomous Database details>Database connection>Wallet type ( Instance wallet )>Download by giving password. Then open SQL Developer on your local computer. In the Connections panel, right-click Connections and select New Connection. Connecting to an Autonomous Database using tnsnames.ora Copy and…
OCI : How to copy/move files from Linux machine to object storage – Make DBA Life Easy
You need to go to your bucket details and click on the right side to open the tab with “Pre-Authenticated Requests” Click on “Create Pre-Authenticated Request”, choose the name and expiration time for the link. The link will appear in a pop-up window only once, and you have to copy and save it if you…
Installing Oracle Management Agent in Silent Mode by Using the AgentPull Script – Make DBA Life Easy
This is to demonstrate how to install 13.5 Oracle Management Agent in Silent Mode by Using the AgentPull Script . Note: To install a Management Agent using the AgentPull script, you DO NOT need to download the Management Agent software onto the destination host. The AgentPull script performs this action automatically. Get AgentPull script from…
ORA-15099: disk is larger than maximum size of 2097152 MBs – Make DBA Life Easy
The following errors occur when creating a new ASM diskgroup: SQL> CREATE DISKGROUP DATA1 EXTERNAL REDUNDANCY disk 'AFD:DATA1_DISK1' NAME DATA1_DISK1;CREATE DISKGROUP DATA1 EXTERNAL REDUNDANCY disk 'AFD:DATA1_DISK1' NAME DATA1_DISK1;*ERROR at line 1:ORA-15018: diskgroup cannot be createdORA-15099: disk 'AFD:DATA1_DISK1' is larger than maximum size of 2097152 MBs SOLUTION SQL> CREATE DISKGROUP DATA1 EXTERNAL REDUNDANCY disk 'AFD:DATA1_DISK1' NAME…
M 13c: Enterprise Manager 13c Cloud Control Agent Control Commands Respond with Message: Invalid EMSTATE valueEMD – Make DBA Life Easy
The "Invalid EMSTATE valueEMD" error occurs when reload/upload/pingOMS agent: oracle:/u01/app/oracle/product/13.5.0/agent_1/agent_inst/bin$ ./emctl reload agentOracle Enterprise Manager Cloud Control 13c Release 5Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved.---------------------------------------------------------------Invalid EMSTATE valueEMD reload completed successfully Check what value is for EMSTATE : $ cat emctl #!/bin/sh -f #++ # # 16-dec-02.15:38:56 vnukal # # Copyright (c) 2002,…
ORA-44305: service is running ORA-44311: service not running when STOP or DELETE a Service – Make DBA Life Easy
In RAC environment, 'DBMS_SERVICE.ALL_INSTANCES' is required to stop or delete a service. Otherwise ORA-44305 or ORA-44311 will occur. SQL> exec DBMS_SERVICE.DELETE_SERVICE('TEST_SERVICE');BEGIN DBMS_SERVICE.DELETE_SERVICE('TEST_SERVICE'); END;*ERROR at line 1:ORA-44305: service TEST_SERVICE is runningORA-06512: at "SYS.DBMS_SERVICE", line 68ORA-06512: at "SYS.DBMS_SERVICE", line 458ORA-06512: at line 1SQL> exec DBMS_SERVICE.STOP_SERVICE('TEST_SERVICE');BEGIN DBMS_SERVICE.STOP_SERVICE('TEST_SERVICE'); END;*ERROR at line 1:ORA-44311: service TEST_SERVICE not runningORA-06512: at "SYS.DBMS_SYS_ERROR", line…
ORA-15046: ASM file name ‘+DATA2/TESTDB/PASSWORD/pwdtestdb.256.1157213397’ is not in single-file creation form – Make DBA Life Easy
When relocating an ASM password file, the following errors occur: ASMCMD> pwcopy --dbuniquename TESTDB '+DATA1/TESTDB/PASSWORD/pwdtestdb.256.1157213397' '+DATA2/TESTDB/PASSWORD/' -f......ORA-15046: ASM file name '+DATA2/TESTDB/PASSWORD/pwdtestdb.256.1157213397' is not in single-file creation form...... The destination name cannot be an OMF format. so the command should be like : ASMCMD> pwcopy --dbuniquename TESTDB '+DATA1/TESTDB/PASSWORD/pwdtestdb.256.1157213397' '+DATA2/TESTDB/PASSWORD/pwdtestdb.pwfile' -f
How to Monitor Undo Tablespace Usage and the Free Space – Make DBA Life Easy
To check the current size of the Undo tablespace: SQL> select sum(a.bytes)/1024/1024/1024 as undo_size_GB, c.tablespace_name from v$datafile a, v$tablespace b, dba_tablespaces c where c.contents = 'UNDO' and c.status = 'ONLINE' and b.name = c.tablespace_name and a.ts# = b.ts# group by c.tablespace_name;UNDO_SIZE_GB TABLESPACE_NAME------------ ------------------------------ 31.9990234 UNDOTBS1 31.9990234 UNDOTBS2 2. To check the free space (unallocated) space…
ORA-25152: TEMPFILE cannot be dropped at this time – Make DBA Life Easy
Check whether the tempfile is being used by users. SQL> show parameter db_filesSQL> SELECT file#, name from v$tempfile;SQL> SELECT s.sid, s.serial#, s.username, s.status, u.tablespace, u.segfile#, u.contents, u.extents, u.blocksFROM v$session s, v$sort_usage uWHERE s.saddr=u.session_addrORDER BY u.tablespace, u.segfile#, u.segblk#, u.blocks; SQL> select sid, username, osuser, program, machine from v$session where sid in (<sid returned from above query>);…
OEM BI Publisher : SQL query time exceeds the limit (600 sec). Stopped processing – Make DBA Life Easy
Waiting Time: 0.7 secondsData Fetch Time: 9.8 minutesTotal Execution Time: 9.9 minutesJob Priority: NormalWaiting Time: 0.7 secondsData Fetch Time: 9.8 minutesTotal Execution Time: 9.9 minutesJob Priority: NormalSQL query time exceeds the limit (600 sec). Stopped processing.[INSTANCE_ID=bip.BIP3] WORKAROUND Tunning the SQL query OR Administration -> Runtime Configuration -> Properties -> SQL Query Timeout. Change it from…
Create CDB Error: Signature of package “SYS.DBMS_BACKUP_RESTORE” has been changed – Make DBA Life Easy
The following errors occur when creating a CDB database with patch level 19.23. ERROR=RMAN-00571: =======================================================ERROR=RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ERROR=RMAN-00571: ============================================ERROR=ORA-04062: signature of package "SYS.DBMS_BACKUP_RESTORE" has been changed SEVERE: [FATAL] Error while restoring PDB backup pieceoracle.sysman.assistants.util.step.StepExecutionException: Error while restoring PDB backup piece WORKAROUND As a workaround, by selecting the "Custom database" option instead of…
PL/SQL package SYS.DBMS_BACKUP_RESTORE version PL/SQL package SYS.DBMS_RCVMAN version in TARGET database is not current – Make DBA Life Easy
Try to connect to RMAN catalog with the following errors: PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.20.00.00 in TARGET database is not currentPL/SQL package SYS.DBMS_RCVMAN version 19.20.00.00 in TARGET database is not currentconnected to target database: TESTDB (DBID=1231118758)connected to recovery catalog database CAUSE Once the DBRU/DBRUR is applied datapatch was not run. While DBRU/DBRUR will update the…
EM GC_Domain OHS Target Alerts with Error: “The Percentage Of Requests That Resulted In Errors Is X%” – Make DBA Life Easy
The OHS log at <GC_INST>/user_projects/domains/GCDomain/servers/ohs1/logs/ohs1.log shows messages like the following: [2018-08-07T10:37:08.5618-05:00] [OHS] [ERROR:32] [] [core.c] [client_id: <client ip address>] [host_id: <OMS hostname>] [host_addr: <OMS IP address>] [tid: 140073893857024] [user: oracle] [ecid: 0000MIjGpMU3b6M5mNT4iZ1RHes^00000F] [rid: 0:5701] [VirtualHost: <OMS hostname>:0] client denied by server configuration: <PATH TO $GC_INST>/WebTierIH1/config/OHS/ohs1/htdocs/empbs Cause One of the agents was trying to upload data to…
ORA-00054: resource busy and acquire with NOWAIT – Make DBA Life Easy
To check which session is holding the object: select a.inst_id, sid, serial#, username, machine from gv$session a, gv$locked_object b, dba_objects cwhere b.object_id = c.object_idand a.sid = b.session_idand a.inst_id=b.inst_idand OBJECT_NAME='TABLENAME';INST_ID SID SERIAL# USERNAME MACHINE OWNER OBJECT_NAME ------- ----- ------- ---------- ----------- ---------- ------------- 2 3365 42069 SYS TESTSERVER TESTUSER TABLENAME Kill the session, then the error…
ORA-28003: password verification for the specified password failed – Make DBA Life Easy
The following error occurs when trying to change user password in Oracle Database. SQL> alter user TESTUSER identified by "TestPassword";alter user TESTUSER identified by "TestPassword";*ERROR at line 1:ORA-28003: password verification for the specified password failed Check user profile: SQL> select profile from dba_users where username='TESTUSER';PROFILE------------------------------------------------------TEST_USER_PROFILE Find password verify function SQL> select RESOURCE_NAME,RESOURCE_TYPE,LIMIT FROM DBA_PROFILES WHERE…
How to Restore a PDB into another CDB from Tape Backups – Make DBA Life Easy
This is to demonstrate how to restore a pdb from backups, then plug into a different cdb with same or another pdb name. Environment Source database name CDBDBA , pdb name pdba Target database name CDBDBB, pdb name pdbb Prepare Auxiliary Database create pfile from target db SQL> create file='/tmp/initCDBDUP1.ora' from spfile; File created. drop…
How to Skip Long Running Transaction in Oracle Goldengate using SKIPTRANS – Make DBA Life Easy
We always see the similar WARNING in ggserr.log: 2024-07-14T20:33:15.697+1000 WARNING OGG-01027 Oracle GoldenGate Capture for Oracle, EXTDB.prm: Long Running Transaction: XID 3708191792.181.17.473582, Items 0, Extract EXTDB, Redo Thread 2, SCN 1447.4108855138 (6218926532450), Redo Seq #38608, Redo RBA 88457232. Check the transaction in GGSCI: GGSCI > send extract EXTDB, showtrans OR show transactions lasting for more…
OGG: Not Able To Register Extract After DB Refresh – Make DBA Life Easy
After database is refreshed, the following errors occur: GGSCI> register extract DTCAP database2024-05-16 01:12:23 ERROR OGG-08221 Cannot register or unregister EXTRACT DTCAP because of the following SQL error: OCI Error ORA (status = 26668-ORA-26668: GoldenGate process OGG$DTCAP existsORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 145ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 186ORA-06512: at line 1). This is because dictionary tables were…
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…