Posted by Mir Sayeed Hassan on October 31st, 2023
Apply the Latest OPatch (12.2.0.1.40) for Oracle Database 19C
Check the status of Database
SQL> select instance_name, version, open_mode from v$database, v$instance;
INSTANCE_NAME VERSION OPEN_MODE
----------------------------------------------
testdb1 19.0.0.0.0 READ WRITE
Check the last updated OPatch
[oracle@test19cdb...
Read more..
Posted in DB Patch | Comments Off on Apply the Latest OPatch (12.2.0.1.40) for Oracle Database 19c
Posted by Mir Sayeed Hassan on October 29th, 2023
Installation of Ansible Packages in Oracle Linux
Download the below require Packages to configure ansible.
[root@ansible-test]# cd /u02/SOURCE/RPM_PKG/ansible/
[root@ansible-test]# ll
total 17808
-rwxrwxrwx. 1 root root 17832207 Oct 29 15:26 ansible-2.9.27-1.el7.noarch (2).rpm
-rwxrwxrwx. 1 root root 42303 Oct 29 15:26 python2-jmespath-0.9.4-2.el7.noarch...
Read more..
Posted in DBA Administration | Comments Off on Installation of Ansible Packages on Oracle Linux 7
Posted by Mir Sayeed Hassan on August 27th, 2023
OEM 13.5C Installation stuck at 54% at Repository Configuration due to locked statistics in sysman schema
<OMS_HOME>/cfgtoollogs/cfgfw/CfmLogger.log
INFO: oracle.sysman.top.oms:Still Running...
INFO: oracle.sysman.top.oms:Still Running...
Read more..
Posted in OEM (Oracle Enterprise Manager) | Comments Off on OEM 13.5C Installation stuck at 54% at Repository Configuration due to locked statistics in sysman schema
Posted by Mir Sayeed Hassan on August 27th, 2023
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
The above error accour while creation of the table in database.
Create table statement
create table MIR.RELATION
(
ID VARCHAR2(255 char) not null primary key,
DESTINATION_ID VARCHAR2(255 char) not null,
SOURCE_ID VARCHAR2(255 char) not null,
);
Posted in ORA-Error | Comments Off on ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Posted by Mir Sayeed Hassan on August 27th, 2023
Cannot open the Pluggable DB due to ORA-65086: cannot open/close the pluggable database
Check the status of database
SQL> select instance_name, open_mode, version from V$database, v$instance;
INSTANCE_NAME OPEN_MODE VERSION
-----------------------------------------
ORA19c READ WRITE 19.0.0.0.0
Posted in DBA Administration | Comments Off on Cannot open the Pluggable Database due to ORA-65086: cannot open/close the pluggable database
Posted by Mir Sayeed Hassan on August 10th, 2023
Error occur while configuration of OEM 13c as installation failed with The referenced database doesn’t contain a valid management Repository.
This error is occur due to the database objects already created earlier which needs proper cleanup of the Repository Database before proceeding for the fresh of OEM installation.
Read more..
Posted in ORA-Error | Comments Off on Error occur while configuration of OEM 13c as installation failed with the referenced database doesn’t contain a valid management Repository