Posted by Mir Sayeed Hassan on October 4th, 2021
How to create a RMAN Catalog & register in Oracle Database 12c(12.2.0.0)
Overview of recovery catalog
The recovery catalog contains metadata about RMAN operations for each registered target database. therefore when RMAN is connected to a recovery catalog, the RMAN obtains its metadata exclusively from the catalog db, to perform this operation you need to have a dedicated user...
Read more..
Posted in RMAN | Comments Off on How to create a RMAN Catalog & register in Oracle Database 12c(12.2.0.0)
Posted by Mir Sayeed Hassan on October 2nd, 2021
ORA-65162: The password of the common user has expired
The above error is occur due to the user password was expired in your database
Check the status of the user
SQL> select username,account_status from dba_users where account_status like '%EXPIRED%';
USERNAME ACCOUNT_STATUS
-----------------------------
SYSTEM EXPIRED
Posted in ORA-Error | Comments Off on ORA-65162: The password of the common user has expired
Posted by Mir Sayeed Hassan on September 6th, 2021
How to set the alternative archive destination in Oracle database
In case of the archivelog destination space is filled/exausted., the database will be hang until the space release from server.
Error log:
0RA-00257: Archiver error, connect internal only until freed
ORA-16014: Log 1 sequence# 3981 not archived, no available destinations
Solution:
Posted in ORA-Error | Comments Off on How to set the alternate archive destination in Oracle database
Posted by Mir Sayeed Hassan on July 28th, 2021
How to change the existing Https Port from OEM 13.5C
First you need to verify the existing https console port used in OEM Server
[oracle(oemsw)@cloudctl bin]$ ./emctl get property...
Read more..
Posted in OEM (Oracle Enterprise Manager) | Comments Off on How to change the existing Https Port from OEM 13.5C
Posted by Mir Sayeed Hassan on July 7th, 2021
Instantiating disk failed while creation of ASM Disk.
The below error is occur while creation of the ASM Disk in one of my test server.
[root@testdb asm_rpm]# /usr/sbin/oracleasm createdisk DATA /dev/sdc1
Writing disk header: done
Instantiating disk: failed ------- error
Clearing disk header: done
This issue can be resolved by diable & enable the...
Read more..
Posted in ASM | Comments Off on Instantiating disk failed while creation of ASM Disk.
Posted by Mir Sayeed Hassan on June 19th, 2021
Install & Configure the Oracle Database 11gR2 on Centos 7
To install, you need to download the software available from the OTN, edelivery or Oracle Support Login.
Download the below DB Software files for Oracle 11gR2 (11.2.0.4) & Unzip of specific directory.
Downloaded files.
linux.x64_11gR2_database_1of2.zip
linux.x64_11gR2_database_2of2.zip
Posted in DB Install & Create | Comments Off on Install & Configure the Oracle Database 11gR2 on Centos/Oracle linux 7
