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
Posted by Mir Sayeed Hassan on June 19th, 2021
Checking swap space: 0 MB available, 150 MB required. Failed or Configure the swap space
Error log while installation.
[oracle@miroradb database]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 36214 MB Passed
Checking swap space: 0 MB available, 150 MB required. Failed <<<<
Checking monitor: must...
Read more..
Posted in ORA-Error | Comments Off on Checking swap space: 0 MB available, 150 MB required. Failed or Configure the swap space
Posted by Mir Sayeed Hassan on June 14th, 2021
TNS-00583: Valid node checking: unable to parse configuration parameters in Oracle 12c
Check the status of database
SQL> select status,instance_name,open_mode, version from V$database,v$instance;
STATUS INSTANCE_NAME OPEN_MODE VERSION
------------ ---------------- -------------------- -----------------
OPEN oemdb READ WRITE 12.1.0.2.0
Start the listerner
[oracle@oemdb...
Read more..
Posted in ORA-Error | Comments Off on TNS-00583: Valid node checking: unable to parse configuration parameters in Oracle 12c
