-
Is 18c available on-premise?
As you know, 18c come into our lives. Many people asking about DBA job will die or We should choose the dba path for our carriers. This subject is one other blog post topic I only want to say, I believe that If data exists than DBA or some other title will be available in… Continue reading
-
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
AWARDED TOP 60 ORACLE BLOGS SINCE 2018
Recent Posts
- Most Common Oracle Wait Events
- Oracle Multitenant architecture at 26ai
- ORA-01555 vs ORA-01628
- RMAN in Oracle 19c vs 26ai — What Changed??
- Oracle AI Database 26ai — The Features That Will Change How You Build Applications?
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 