foalabs

Backup of a Container Database (CDB) and a Pluggable Database (PDB) Oracle in detail step by step I am sharing the  are step-by-step instructions to backup a CDB and PDBs in Oracle to a custom location: Database name: SQL> select name from v$database; NAME --------- DB19 PDB name: SQL> show pdbs     CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 PDB1                           READ WRITE NO Database is on OCI VM DB system (DBCS). DB version is 19c Create Backup  Directory mkdir -p /u01/app/oracle/backup/DB19 Full CDB and PDB backup A full backup of the CDB you are also doing ...

OEM 13c-12c: Container Database Target in Enterprise Manager Cloud Control shows DOWN Status when using OCI Error: EM 13c / 12c Cloud Control shows a container database target (CDB) with DOWN status and this corresponding message: The <OMS_HOME>/em/EMGC_OMS1/sysman/log/emoms.log will show the below exception:   ERROR conf.Task logp.251 - Caught Exception in thread pool-2308-thread-1 java.sql.SQLException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor I was using OCI DBCS where listener was running from Grid Home USE_SID_AS_SERVICE_LISTENER=ON was set in the listener.ora file for the database listener. USE_SID_AS_SERVICE_LISTENER converts the SID connection string to service name and the EM Agent is connecting using the SID designation, hence the agent connection fails. It will only be an issue if the database SID value is different from its SERVICE_NAME value. Solution: Crea...

Installing VNC on DBCS Server Oracle Cloud OCI I have a DBCS Server on OCI. I need to install the VNC viewer on it so that I can use few GUI setups. I am going to share the steps in this post. 1) Connect to the DBCS server as root [root@foadbserver ~]# cat /etc/os-release  NAME="Oracle Linux Server" VERSION="7.9" 2) Install the libraries for VNC yum install tigervnc-server -y yum install xterm xsetroot xclock -y 3) Start VNC Services  [root@foadbserver ~]# vncserver You will require a password to access your desktops. Password: Verify: Would you like to enter a view-only password (y/n)? n A view-only password is not used xauth:  file /root/.Xauthority does not exist New 'foadbserver:1 (root)' desktop is foadbserver:1 Creating default startup script /root/.vnc/xstartup Creating default config /root/.vnc/config Starting applications specified in /root/.vnc/xstartup Log file is /root/.vnc/foadbserver:1.log 4) Allow IP tables connectivity iptables-save > /tmp...

Weblogic Admin Console not working due to the IPv6 Mapping on IP address Error: If there is a problem using IPv6, we will see error messages like these in the server log: Caused By: java.net.ConnectException: Tried all: '1' addresses, but could not connect over HTTP to server: '[x:x:x:x:x:x:x:x]', port: 'PORT' At the same time, the following messages are in stdout: <Notice> <Log Management> <BEA-170019> <The server log file MW-HOME\user_projects\domains\DOMAIN-NAME\servers\SERVER-NAME\logs\SERVER-NAME.log is opened. All server side log events will be written to this file.> <Notice> <Security> <BEA-090082> <Security initializing using security realm myrealm.> <JTAMigrationHandler> Unexpected exception while getting RemoteMigratableServiceCoordinator : javax.naming.CommunicationException [Root exception is java.net.ConnectException: t3://[x:x:x:x:x:x:x:x]:PORT: Destination unreachable; nested exception is: java...

WebLogic Console Access Fails with Error 503-Service Unavailable Error: In the FMW environment, when trying to access Weblogic console, it fails with the error "Error 503-Service Unavailable". Admin Server is up and running and Fusion Middleware Control is accessible. The log file shows below errors: <Error> <HTTP> <BEA-101216> <Servlet: "action" failed to preload on startup in Web application: "console". <Error> <HTTP> <HOSTNAME> <AdminServer> <[ACTIVE] ExecuteThread: '14' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <>  <ECID> <TID> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-101064> <[WebAppModule(consoleapp:console)]  Error parsing descriptor in Web appplication "/wlserver/server/lib/consoleapp/webapp" javax.xml.stream.XMLStreamException: Error at line:438 col:6 ' ' e...

Oracle VM Manager SSL Certificates ReGeneration with ovmkeytool.sh Changing Oracle VM Manager certificates involves updating the SSL certificates used by the Oracle WebLogic Server that Oracle VM Manager runs on. It might be required when the certificates are expired as well. 1) Confirm if the below folder exists locally (/u01) on the Active Management Node. # ll /u01/app/oracle/ovm-manager-3/domains/ovm_domain/security # ll /u01/app/oracle/ovm-manager-3/domains/ovm_domain/config 2) Regenerate the certificates using the below command from root user # export MW_HOME=/u01/app/oracle/Middleware # /u01/app/oracle/ovm-manager-3/ovm_upgrade/bin/ovmkeytool.sh setup Please make sure that you answer the setup questions as belowIit should always be pointing to the local storage(/u01) as per below: # /u01/app/oracle/ovm-manager-3/ovm_upgrade/bin/ovmkeytool.sh setup Dec 17, 2023 10:07:15 AM oracle.security.jps.JpsStartup start INFO: Jps initializing. Dec 17, 2023 10:07:17 AM oracle.security.jps.Jp...

Oracle VM Manager Login Fails - After Entering Credentials, Returning to Login Page Error: OVM GUI and CLI login fails. Entering the credentials returns to the login page. CLI login fails with Authorization failed. But can login to Weblogic console. Resetting the password form Weblogic console also does not help. AdminServer.log shows below error message: <Error> <com.oracle.appfw.common.utils.AbstractConnectionManager> <ch-oraclemgr2v> <AdminServer> <[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'> <admin> <> <639bd9d6-1cde-45f9-b72a-59eac3f3b9d8-00000017> <1532617015451> <BEA-000000> <AppFw session 1001 has failed to connect to WebService API. com.oracle.ovm.mgr.ws.model.WsException: AUTH_000002:Connection to manager failed: AUTH_000002:Connection to manager failed: OVMAPI_6000E Internal Error: Authentication callback unavailable. Please try again later. Solution: Stop and st...

How to Reset the admin login for the Oracle  VM Manager 3.0 We can reset the password using the OVM Admin tool. # /u01/app/oracle/ovm-manager-3/bin/ovm_admin --modifyuser admin oldpassword Welcome1 Oracle VM Manager Release 3.0.1 Admin tool Please enter the password for weblogic : Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Connecting to WebLogic server ... Connecting to t3://localhost:7001 with userid weblogic ... Successfully connected to Admin Server 'AdminServer' that belongs to domain 'base_adf_domain'. Warning: An insecure protocol was used to connect to the server. To ensure on-the-wire security, the SSL port or Admin port should be used instead. Connected ... Modifying user 'admin' ... Modified user 'admin' successfully ... Disconnected from weblogic server: AdminServer Exiting... Exiting WebLogic Scripting Tool. Note: Password needs to be 8 c...

Oracle Data Guard Evolution from 8i ORACLE 8i ————————- * Read-Only Standby Database * Managed recovery * Remote archiving redo log files ORALCE 9i ————————- * “Zero Data Loss” Integration * Data Guard Broker and Data Guard Manager GUI * Swithcover and Failover operations * Automatical synchronous * Logical Standby Database * Maximum Protection ORACLE 10g ————————- * Real-Time Apply * Fast-Start Failover * Asynchronous redo transfer * Flashback Database ORACLE 11g ———————— * Active Standby Database (Active Data Guard) * Snapshot Standby * Heterogeneous platform support (Production –Linux, Standby – Windows) If you like please follow and comment

How to Unlock Oracle VM Manager admin user Account Error: Trying to login with admin user in VM manager console and getting error "Login Denied" Solution: 1. Log into the Weblogic Console. https://OVM_MANGER:7002/console/ The userid should be "weblogic" unless the system has been customized The password is usually the same as the OVM Manager Admin password unless specifically altered 2. In the "Change Center" box (top left) of the Administration Console, click the "Lock & Edit" button. 3. In the left pane, in the "Domain Structure" box, click on the name of the domain - "ovmdomain"  4. In the right pane, under the "Settings for ovm_domain" bar, click the Security tab. Then click the "Unlock User" tab' 5. In the "Unlock Username:" box, enter the user name of the user whose account you want to unlock (e.g. "Admin") 6. In the "Change Center" box (top left) click the "...

ORA-00392: log 4 of thread 1 is being cleared, operation not allowed Error: While cloning the database and opening in reset log we might encounter below error. SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00392: log 4 of thread 1 is being cleared, operation not allowed ORA-00312: online log 4 thread 1: ‘/u02/oracle/oradata/TEST/redo4.log’ Solution : SQL> select group#,thread#,status from v$log; GROUP# THREAD# STATUS ——- ——— —————- 1 1 CLEARING 3 1 CLEARING 2 1 CLEARING 4 1 CLEARING_CURRENT SQL> alter database clear unarchived logfile group 4; Database altered. SQL> alter database open resetlogs; Database altered If you like please follow and comment