-
Recovering Standby Database Using Incremental RMAN (Roll Forward )
Sometimes standby database lags far behind from the primary database leading to Archive Gap. There are some reasons could be for that such as Network issue between the primary and the standby database leading to the archive gaps. Standby archive log dest may be full or Standby db disk becomes full so the primary and the… Continue reading
-
How to Monitor Data Pump Job (IMPDP)
Datapump (expdp&impdp) is very useful tool while you need to take data from one DB to another or on the same database. So its very critical to know what is import status, what import do exact time etc. In this post, I will share some useful SQL to can monitor data pump jobs. Continue reading
-
How to enable Flashback on Standby Database
Flashback Database quickly rewinds an Oracle database to a previous point in time to correct any problems caused by logical data corruptions or user errors. Flashback A database is like a ‘rewind button’ for your database. To revert the entire database to a prior point in time, you can either revert the entire database to… Continue reading
-
How to Change SYSMAN Password on 13c
You may lose or you may want to change SYSMAN password. So here are the steps Step 1: Set related env. such as ORACLE_HOME, ORACLE_SID Continue reading
-
Who use the ports in AIX
Sometimes We may need to know which process or user use a specific port on a unix system. In this post, I will show you how you can find a port in use or not and who use this port. Continue reading
-
$ORACLE_HOME/sysman/lib/ins_emagent.mk relink_sharedobj SHAREDOBJ=libnmemso
During 11gR1 and 11gR2 installation on AIX6 you can hit this error: make -f $ORACLE_HOME/sysman/lib/ins_emagent.mk relink_sharedobj SHAREDOBJ=libnmemso The solution is described in below Metalink note: Linking Fails With “ld: 0706-010 The binder was killed by a signal: Segmentation fault” On AIX 6.1 [ID 1264074.1] Continue reading
-
ORA-10878: parallel recovery slave died unexpectedly
I hit this error message while trying to add standby file on standalone 11.2.0.4 database+ ASM disks on AIX operating system: Symptoms: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE * ERROR at line 1: ORA-10878: parallel recovery slave died unexpectedly Continue reading
-
ERROR conn.ConnectionService verifyRepositoryEx.891 – Invalid Connection Pool. ERROR = ORA-28000: the account is locked
I faced with that issue on “Oracle Enterprise manager” on one of my client environments. Here is the error message while I try to start dbconsole [oracle@yourhostname alert]$ emctl status dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved. http://yourhostname:1158/em/console/aboutApplication Oracle Enterprise Manager 11g is not… Continue reading
be sure not to write to the OutputStream or to trigger a commit due to any other action before calling this method., ERROR conn.ConnectionService verifyRepositoryEx.891 – Invalid Connection Pool. ERROR = ORA-28000: the account is locked, java.lang.IllegalStateException: Response has already been committed, racle Enterprise Manager 11g is not running. -
The database is down. Please specify the host credentials to access database restart and diagnostics tools.
I faced with that issue on “Oracle Enterprise manager” on one of my client environments. Here is the screen: Continue reading
-
How to Rename or Move Data Files in Oracle
If your Oracle datafiles host on filesystem architecture than you may need to move your datafiles to one other path because of not enough disk size etc. In this post, I am talking about a move or rename datafiles to a new location. We will use cp command to achieve move data file from one… Continue reading
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Oracle CDB vs Non-CDB: A Future-Ready Database Architecture
- Hot Cloning of a PDB in Oracle Database
- Oracle + Artificial Intelligence = Smarter Database Management
- Understanding UNDO Tablespace in Oracle Database: Importance and Best Practices
- Fortifying Your Cloud: Understanding the OCI Zero Trust Landing Zone
CATEGORIES
- Cloud Computing Tutorials
- My Presentations
- Oracle Cloud Journey
- Oracle Database&EBS General
- Oracle E-Business Suite Release 11
- Oracle E-Business Suite Release 12
- Scripts for Oracle E-Business Suite
- Some other Oracle Products Installation
- Step by Step Oracle E-Business Suite Installation
- Video Tutorials
HELIOS BLOG 