Installation of Oracle AI Database Enterprise Edition

Phase 1: VirtualBox 7.2.20 Machine Setup

1. Download Oracle VirtualBox-7.2.20-175154-Win and Linux ISO image. 

2. Install Oracle VirtualBox-7.2.20

2. Open Virtual Box -> Machine -> New 

VM Name: OradbVM001

ISO Image: select downloaded image

Select: Memory Size, No. of CPUs, Disk Size 

VM Setting -> Network -> Adapter1 (Bridge) -> Adapter2 (NAT) 


Phase 2: Installing Oracle Linux 10 U2 (Guest OS)

Start the VM -> Choose Install Oracle Linux 10 -> Installation Destination (Storage Partitioning)

Choose Custom/Advanced LVM partitioning.

/boot: 1 GB, ext4

swap: 8 GB 

/ root partition: 40 GB, xfs

/u01: 100GB, xfs

Create your root password -> create a basic user account -> Begin Installation -> Complete


Phase 3: Preparing the Operating System

1. Update Host Table (/etc/hosts) with hostname 

2. Execute Pre-Installation Routine

dnf update -y

dnf install -y oracle-ai-database-preinstall-26ai

3. Set Oracle password 

passwd oracle 

4. Create ORACLE_HOME directory 

mkdir -p /u01/app/oracle/product/26ai/dbhome_1 

chown -R oracle:oinstall /u01 

chmod -R 775 /u01

5. Add port 1521 in firewall 

firewall-cmd --permanent --add-port=1521/tcp 

firewall-cmd --reload


Phase 4: Installing the Database Software & Instance Creation

1. Unzip oracle home file on ORACLE_HOME directory as "oracle" user

unzip LINUX.X64_2326100_db_home.zip -d /u01/app/oracle/product/26ai/dbhome_1

2. Install the software 

Setup software only -> Single instance database -> Oracle base (/u01/app/oracle) -> Inventory directory (/u01/app/oraInventory) -> oraInventory Group name (oinstall) -> select group -> install -> run orainstRoot.sh and root.sh as root user 

3. Install database 

cd $ORACLE_HOME/bin 

./dbca -> create a database -> global db name (myproddb) -> pdb name (orapdb1) -> create database 

##Set below parameter in oracle .bashrc profile 

export ORACLE_HOME=/opt/oracle/product/26c/dbhome_1 export ORACLE_SID=ORCLCDB export PATH=$ORACLE_HOME/bin:$PATH


sqlplus / as sysdba

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 ORAPDB1                        READ WRITE NO

SQL> alter session set container=orapdb1;

Session altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         3 ORAPDB1                        READ WRITE NO

Comments

Post a Comment

Popular posts from this blog

 Exadata  Oracle Exadata Smart Flash Cache * Exadata cell -> Flash LUN -> Cell Disk -> Flash Cache/Flash Log  * CELL_FLASH_CACHE - – DEFAULT (LRU), KEEP, NONE * ALTER TABLE <TABLE_NAME> STORAGE(FLASH_CACHE [NONE|DEFAULT|KEEP]) * ALTER INDEX <INDEX NAME> STORAGE(FLASH_CACHE [NONE|DEFAULT|KEEP]) Smart Flash Cache Mode: 1. Write Through Flash Cache Mode (Default):  Write on Disk -> Copy to Flash Cache  * excellent for absorbing repeated random reads  * commonly found in OLTP applications. * dcli -g cell_servers -l celladmin cellcli -e "list cell attributes flashcachemode" * Steps to enable Write-Through Mode CellCLI> ALTER FLASHCACHE ALL FLUSH CellCLI> DROP FLASHCACHE CellCLI> ALTER CELL SHUTDOWN SERVICES CELLSRV CellCLI> ALTER CELL flashCacheMode=WriteThrough CellCLI> ALTER CELL STARTUP SERVICES CELLSRV CellCLI> CREATE FLASHCACHE ALL 2. Write Back Flash Cache Mode:  Write on Flash -> Copy to Disk  * best ...
Read more

Database Network : Configuration Parameters

LSNRCTL> command [listener_name] lsnrctl @file_name  #to execute in batch mode. REM or # to identify comments in the batch script Listener.ora file parameters: ·          PASSWORDS_listener_name  #an unencrypted password ·          LSNRCTL> change_password #to establish an encrypted password ·          LSNRCTL> SAVE_CONFIG  #Any changes are stored in listener.ora ·          LSNRCTL> SET PASSWORD  #If a password is set, then issue SET PASSWORD command before changing the password. Use the command SET PASSWORD prior to privileged Listener Control utility commands ·          Reload : the database services, instances, service handlers, and listening endpoints that were dynamically registered with the listener will be unregistered and subseque...
Read more

Undo Segments : Drop Problematic Undo Segments

ERROR about to recover undo segment 98 status:6 inst:0 mark undo segment 98 as available status:6 ret:1  about to recover undo segment 46 status:6 inst:0 mark undo segment 46 as available status:6 ret:1   SQL> select * from V$FAST_START_TRANSACTIONS; USN SLT SEQ STATE UNDOBLOCKSDONE UNDOBLOCKSTOTAL PID CPUTIME PARENTUSN PARENTSLT PARENTSEQ XID PXID RCVSERVERS CON_ID ---------- ---------- ---------- ---------------- -------------- --------------- ---------- ---------- ---------- ---------- 46 46 2313064 RECOVERING 505 24992423 77 5586 0 0 0 10001000684B2300 0000000000000000 1 0 98 25 1352150 RECOVERING 0 226231 78 5586 0 0 0 30001900D6A11400 0000000000000000 1 0   SQL> SELECT segment_name, tablespace_name  FROM dba_rollback_segs  WHERE segment_id IN (98, 46); SEGMENT_NAME               TABLESPACE_NAME ------------------------------ ----------------------------...
Read more