Transforming Ideas into Innovation with Cloud, AI, and Data

 The following Error was encountered when we tried starting up the database manually:   SQL> startup ORACLE instance started.   Total System Global Area 4.8694E+11 bytes Fixed Size                 37521640 bytes Variable Size            5.5298E+10 bytes Database Buffers         4.3111E+11 bytes Redo Buffers              499347456 bytes Database mounted. Database opened.         " was non-numeric Usage: { EXIT | QUIT }e [ SUCCESS | FAILURE | WARNING | n |        <variable> | :<bindvariable> ]  [ COMMIT | ROLLBACK ] Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.18.0.0...

In one of the customer environment while performing the Oracle EBS R12.2.0 Base install it failed with the following error message. RW-50010: Error: - script has returned an error: 1 RW-50004: Error code received when running external process. Check log file for details. Running Database Install Driver for VIS instance RMAN Log file Phase 3 Rename Database Executing command: sh -c "ORACLE_SID=ORCLVIS;export ORACLE_SID;ORACLE_HOME=/u01/oracle/VIS/12.1.0;export ORACLE_HOME; /u01/oracle/VIS/12.1.0/bin/rman target / nocatalog @/u01/oracle/VIS/12.1.0/appsutil/out/VIS_ebsapps/restore-rac3.rman > /u01/oracle/VIS/12.1.0/appsutil/out/VIS_ebsapps/restore-rac3.log" Unable to rename database RW-50010: Error: - script has returned an error: 1 RW-50004: Error code received when running external process. Check log file for details. Running Database Install Driver for VIS instance [root@ebsapps lib]# cat /u01/oracle/VIS/12.1.0/appsutil/out/VIS_ebsapps/restore-rac3.log Recovery Mana...

In the last blog post we have seen how we can install the ZFS rpm packages on Oracle Linux 8 Operating System and now in this blog post, we will see how to configure and create the zpool on Oracle Linux 8 operating system.  Check the ZFS services: [root@localhost ~]# systemctl -a | grep zfs zfs-import-cache.service loaded inactive dead Import ZFS pools by cache file zfs-mount.service loaded inactive dead Mount ZFS filesystems zfs-share.service loaded inactive dead ZFS file system shares ...

This blog post will guide you on how we can pull the Docker images on Oracle Linux Server. The following link provides the available docker images: https://hub.docker.com/_/oraclelinux/ Check the available docker images: [root@localhost ~]# docker images REPOSITORY TAG IMAGE ID CREATED SIZE [root@localhost ~]# To pull the docker images server should be connected to the internet  Pulling the docker images: [root@localhost ~]# docker pull oraclelinux:7-slim 7-slim: Pulling from library/oraclelinux e83e8f2e82cc: Pull complete Digest: sha256:8a1041ef1238165425de696fae910aa36a16ba370cd1d47b04ad8dd00d3ea655 Status: Downloaded newer image for oraclelinux:7-slim docker.io/library/oraclelinux:7-slim [root@localhost ~]# [root@localhost ~]# docker pull oraclelinux:8-slim 8-slim: Pulling from library/oraclelinux 90e2fb2facff: Pull complete Digest: sha256:c911d89784e56a150d14030091b9fbf7875efb8c4ed190f39313f90691d81fbb Status: Downloaded newer image for oraclelinux:8...

In this blog post, we will see how we can install the ZFS rpm packages on Oracle Linux 8 operating system. Install pre-requiste package: [root@localhost ~]# dnf install -y yum-utils Last metadata expiration check: 1:16:13 ago on 25 May 2023 03:34:37 AM EDT. Package yum-utils-4.0.21-19.0.1.el8_8.noarch is already installed. Dependencies resolved. Nothing to do. Complete! [root@localhost ~]# Install the EPEL repository: [root@localhost ~]# dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm Last metadata expiration check: 1:17:42 ago on Wed 31 May 2023 03:34:37 AM EDT. epel-release-latest-8.noarch.rpm 33 kB/s | 25 kB 00:00 Dependencies resolved. ==========================================================================================================================================================...

This blogpost will provide you detailed information about Oracle Audit Vault and Database Firewall (Oracle AVDF) setup. Oracle AVDF is a comprehensive Database Activity Monitoring (DAM) solution that integrates with native audit data. Environment Setup: [oracrp@ebs-dev2-db01 ~]$ mkdir -pv /oradb/oracle/avcli mkdir: created directory ‘/oradb/oracle/avcli’ [oracrp@ebs-dev2-db01 ~]$ mkdir -pv /oradb/oracle/avagent mkdir: created directory ‘/oradb/oracle/avagent’ [oracrp@ebs-dev2-db01 ~]$ - Add these variables to the environment file vi DEV2CDB.env # AVS export AVCLI_HOME="/oradb/oracle/avcli" export AV_HOME="/oradb/oracle/avagent" export PATH="$PATH:$AV_HOME/bin" Download the JAR files:   AVDF installation requires one network interface card on respective hosts. IP assigned to AV server NIC will communicate with target databases and IP assigned to DF server will connect to AV Download - Agent jar file:   Login to AV console as avadmin user   - Go t...

We were working on 8 node Extended RAC setup and based on request from customer we need to scale up the existing ASM disk group and when we tried adding the disk to the disk group we encountered the following error SQL> alter diskgroup data add disk '/dev/mapper/CL1_SITEA_D007' force; alter diskgroup data add disk '/dev/mapper/CL1_SITEA_D007' force * ERROR at line 1: ORA-00600: internal error code, arguments: [kfgSiteNumPopulate02], [], [], [], [], [], [], [], [], [], [], [] Error From ASM Alert logfile: Dumping diagnostic data in directory=[cdmp_20230424121633], requested by (instance=1, osid=397487), summary=[incident=68188]. 2023-04-24T12:16:33.770798+03:00 NOTE: Attempting voting file refresh on diskgroup DATA NOTE: Refresh completed on diskgroup DATA. No voting file found. 2023-04-24T12:16:36.289397+03:00 ORA-00600: internal error code, arguments: [kfgSiteNumPopulate02], [], [], [], [], [], [], [], [], [], [], [] 2023-04-24T12:16:36.289445+03:00 ERROR: al...