Search This Blog

Total Pageviews

Thursday, 10 September 2026

Index Info ... 




define T='EMP'

-- Reset previous settings
CLEAR COLUMNS

SET LINESIZE 200  PAGESIZE 100

-- Format specific columns to fit output on screen
COLUMN index_owner FORMAT A15       HEADING 'Owner'
COLUMN table_name  FORMAT A20       HEADING 'Table Name'
COLUMN index_name  FORMAT A25       HEADING 'Index Name'
COLUMN idxtype     FORMAT A12       HEADING 'Index Type' TRUNC
COLUMN uniq        FORMAT A10       HEADING 'Uniqueness'
COLUMN status      FORMAT A8        HEADING 'Status'
COLUMN part        FORMAT A4        HEADING 'Part'
COLUMN temp        FORMAT A4        HEADING 'Temp'
COLUMN h           FORMAT 99        HEADING 'H'
COLUMN lfblks      FORMAT 999,999   HEADING 'Leaf Blks'
COLUMN ndk         FORMAT 999,999   HEADING 'NDK'
COLUMN num_rows    FORMAT 999,999   HEADING 'Num Rows'
COLUMN cluf        FORMAT 999,999   HEADING 'Clust Fact'
COLUMN degree      FORMAT A6        HEADING 'Degree'
COLUMN visibility  FORMAT A10       HEADING 'Visibility'
COLUMN last_analyzed FORMAT A11     HEADING 'Last Analyzed'

-- Main Query
SELECT 
    owner AS index_owner,
    table_name,
    index_name,
    index_type AS idxtype,
    uniqueness AS uniq,
    status,
    partitioned AS part,
    temporary AS temp,
    blevel AS h,
    leaf_blocks AS lfblks,
    distinct_keys AS ndk,
    num_rows,
    clustering_factor AS cluf,
    TO_CHAR(last_analyzed, 'YYYY-MM-DD') AS last_analyzed,
    degree,
    visibility
FROM all_indexes
 WHERE 1=1
-- and owner = 'YOUR_SCHEMA' 
AND table_name = '&T'
ORDER BY index_owner, table_name, index_name;





CLEAR COLUMNS

SET LINESIZE 200
SET PAGESIZE 100

-- Format index and table info
COLUMN index_owner FORMAT A15       HEADING 'Owner'
COLUMN table_name  FORMAT A20       HEADING 'Table Name'
COLUMN index_name  FORMAT A25       HEADING 'Index Name'
COLUMN idxtype     FORMAT A12       HEADING 'Index Type' TRUNC
COLUMN uniq        FORMAT A10       HEADING 'Uniqueness'
COLUMN status      FORMAT A8        HEADING 'Status'

-- Format column details (ALL_IND_COLUMNS)
COLUMN column_position FORMAT 999   HEADING 'Pos'
COLUMN column_name     FORMAT A25   HEADING 'Column Name'
COLUMN column_length   FORMAT 999   HEADING 'Len'
COLUMN descend         FORMAT A4    HEADING 'DESC'

-- Format query SELECT statement
SELECT 
    i.owner AS index_owner,
    i.table_name,
    i.index_name,
    i.index_type AS idxtype,
    i.uniqueness AS uniq,
    ic.column_position,
    ic.column_name,
    ic.column_length,
    ic.descend
FROM all_indexes i
JOIN all_ind_columns ic 
  ON i.owner = ic.index_owner
 AND i.index_name = ic.index_name
 AND i.table_owner = ic.table_owner
 AND i.table_name = ic.table_name
 WHERE 1=1
-- and i.owner = 'YOUR_SCHEMA' 
AND i.table_name = '&&T'
ORDER BY 
    i.owner, 
    i.table_name, 
    i.index_name, 
    ic.column_position;
  
  
  define 1='' --- owner

SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON

BEGIN
   DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true);
   DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'PRETTY', true);
  END;
/

--define tab='T'
SELECT DBMS_METADATA.get_ddl ('TABLE', TABLE_name, owner)
FROM   all_tables
WHERE 1=1
--and owner      = UPPER('&1')
AND    table_name = '&T'
;
SELECT DBMS_METADATA.get_ddl ('INDEX', index_name, owner)
FROM   all_indexes
WHERE 1=1
--and owner      = UPPER('&1')
AND    table_name = '&&T'
;
Posted by at No comments:

Saturday, 5 September 2026

Oracle grid installtion 




curl -o oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm

dnf -y localinstall oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm



[root@oragrid dev]# ip a
1: lo:  mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
       valid_lft forever preferred_lft forever
    inet6 ::1/128 scope host
       valid_lft forever preferred_lft forever
2: enp0s3:  mtu 1500 qdisc fq_codel state UP group default qlen 1000
    link/ether 08:00:27:8a:2c:28 brd ff:ff:ff:ff:ff:ff
    inet 192.168.1.247/24 brd 192.168.1.255 scope global dynamic noprefixroute enp0s3
       valid_lft 86023sec preferred_lft 86023sec
    inet6 2a0e:cb01:14f:3200:a00:27ff:fe8a:2c28/64 scope global dynamic noprefixroute
       valid_lft 545sec preferred_lft 544sec
    inet6 fe80::a00:27ff:fe8a:2c28/64 scope link noprefixroute
       valid_lft forever preferred_lft forever
[root@oragrid dev]#




https://anuj-singh.blogspot.com/2024/11/vm-tool-on-vm-box.html
curl -o oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm
   33  ls -ltr
   34  dnf -y localinstall oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm




cat /etc/sysctl.conf|egrep -i 'fs.file-max|kernel.sem|kernel.|net.|fs.|net.'



cat /etc/sysctl.conf|egrep -i 'fs.file-max|kernel.sem|kernel.|net.|fs.|net.'
# oracle-database-preinstall-19c setting for fs.file-max is 6815744
fs.file-max = 6815744
# oracle-database-preinstall-19c setting for kernel.sem is '250 32000 100 128'
kernel.sem = 250 32000 100 128
# oracle-database-preinstall-19c setting for kernel.shmmni is 4096
kernel.shmmni = 4096
# oracle-database-preinstall-19c setting for kernel.shmall is 1073741824 on x86_64
kernel.shmall = 1073741824
# oracle-database-preinstall-19c setting for kernel.shmmax is 4398046511104 on x86_64
kernel.shmmax = 4398046511104
# oracle-database-preinstall-19c setting for kernel.panic_on_oops is 1 per Orabug 19212317
kernel.panic_on_oops = 1
# oracle-database-preinstall-19c setting for net.core.rmem_default is 262144
net.core.rmem_default = 262144
# oracle-database-preinstall-19c setting for net.core.rmem_max is 4194304
net.core.rmem_max = 4194304
# oracle-database-preinstall-19c setting for net.core.wmem_default is 262144
net.core.wmem_default = 262144
# oracle-database-preinstall-19c setting for net.core.wmem_max is 1048576
net.core.wmem_max = 1048576
# oracle-database-preinstall-19c setting for net.ipv4.conf.all.rp_filter is 2
net.ipv4.conf.all.rp_filter = 2
# oracle-database-preinstall-19c setting for net.ipv4.conf.default.rp_filter is 2
net.ipv4.conf.default.rp_filter = 2
# oracle-database-preinstall-19c setting for fs.aio-max-nr is 1048576
fs.aio-max-nr = 1048576
# oracle-database-preinstall-19c setting for net.ipv4.ip_local_port_range is 9000 65500
net.ipv4.ip_local_port_range = 9000 65500
[root@oragrid ~]#





 cat /etc/group|egrep -i 'oinstall|dba|oper|backupdba|dgdba|kmdba|asmdba|asmoper|asmadmin|racdba'|uniq
oinstall:x:54321:oracle
dba:x:54322:oracle
oper:x:54323:oracle
backupdba:x:54324:oracle
dgdba:x:54325:oracle
kmdba:x:54326:oracle
racdba:x:54330:oracle
asmdba:x:54327:
asmoper:x:54328:
asmadmin:x:54329:

[root@oragrid ~]#





groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin
groupadd -g 54330 racdba




mkdir -p /u01/app/19.3.0/grid
chown -R grid:oinstall  /u01/app/19.3.0/grid
chmod -R 775 /u01/app/19.3.0/grid 




systemctl status  avahi-daemon
systemctl stop avahi-daemon
systemctl disable avahi-daemon




C:\VM-Box\Ora-grid>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" createhd --filename "C:\VM-Box\Ora-grid\data_01.vdi" --size 20480 --format VDI --variant Fixed
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 1b5f2ff3-be5e-44a9-bf6d-7dd0e8d5a0fb

C:\VM-Box\Ora-grid>



c:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename "C:\VM-Box\Ora-grid\data_01.vdi" --size 20480 --format VDI --variant Fixed


C:\VM-Box\Ora-grid



cd /dev
ls sd*|grep -v [12]|grep -v a


[root@oragrid ~]# ls /dev/sd*|grep -v [12]|grep -v a
/dev/sdb
[root@oragrid ~]#


C:\Users\anuj2804\Downloads\



$ sudo rpm -ivh oracleasm-support-3.1.0-10.el9.x86_64.rpm
$ sudo rpm -ivh oracleasmlib-3.1.0-6.el9.x86_64.rpm



https://edelivery.oracle.com/
Oracle ASMLib for Oracle Linux 9 3.1



https://yum.oracle.com/repo/OracleLinux/OL9/addons/x86_64/index.html
oracleasm-support-3.1.1-5.el9.x86_64.rpm




[root@oragrid ~]# rpm -ivh oracleasm-support-3.1.1-5.el9.x86_64.rpm
warning: oracleasm-support-3.1.1-5.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8d8b756f: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracleasm-support-3.1.1-5.el9    ################################# [100%]
Created symlink /etc/systemd/system/multi-user.target.wants/oracleasm.service → /usr/lib/systemd/system/oracleasm.service.

[root@oragrid ~]# rpm -ivh oracleasmlib-3.1.1-1.el9.x86_64.rpm
warning: oracleasmlib-3.1.1-1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8d8b756f: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracleasmlib-3.1.1-1.el9         ################################# [100%]
[root@oragrid ~]#




[root@oragrid ~]# /usr/sbin/oracleasm configure -i
Configuring the Oracle ASM system service.

This will configure the on-boot properties of the Oracle ASM system
service.  The following questions will determine whether the service
is started on boot and what permissions it will have.  The current
values will be shown in brackets ('[]').  Hitting  without
typing an answer will keep that current value.  Ctrl-C will abort.

Default user to own the ASM disk devices []: oracle
Default group to own the ASM disk devices []: dba
Start Oracle ASM system service on boot (y/n) [y]: y
Scan for Oracle ASM disks when starting the oracleasm service (y/n) [y]: y
Maximum number of ASM disks that can be used on system [2048]:
Enable iofilter if kernel supports it (y/n) [y]: y

WARNING: I/O filtering not supported with Linux 5.14.0-708.el9.x86_64 on x86_64

Writing Oracle ASM system service configuration: done

Configuration changes only come into effect after the Oracle ASM
system service is restarted.  Please run 'systemctl restart oracleasm'
after making changes.

WARNING: All of your Oracle and ASM instances must be stopped prior
to restarting the oracleasm service.

[root@oragrid ~]#






[root@oragrid ~]# /usr/sbin/oracleasm configure -i
Configuring the Oracle ASM system service.

This will configure the on-boot properties of the Oracle ASM system
service.  The following questions will determine whether the service
is started on boot and what permissions it will have.  The current
values will be shown in brackets ('[]').  Hitting  without
typing an answer will keep that current value.  Ctrl-C will abort.

Default user to own the ASM disk devices []: oracle
Default group to own the ASM disk devices []: dba
Start Oracle ASM system service on boot (y/n) [y]: y
Scan for Oracle ASM disks when starting the oracleasm service (y/n) [y]: y
Maximum number of ASM disks that can be used on system [2048]:
Enable iofilter if kernel supports it (y/n) [y]: y

WARNING: I/O filtering not supported with Linux 5.14.0-708.el9.x86_64 on x86_64

Writing Oracle ASM system service configuration: done

Configuration changes only come into effect after the Oracle ASM
system service is restarted.  Please run 'systemctl restart oracleasm'
after making changes.

WARNING: All of your Oracle and ASM instances must be stopped prior
to restarting the oracleasm service.




[root@oragrid ~]# /usr/sbin/oracleasm configure
ORACLEASM_UID=oracle
ORACLEASM_GID=dba
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
ORACLEASM_SCAN_DIRECTORIES=""
ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"
ORACLEASM_CONFIG_MAX_DISKS="2048"
ORACLEASM_ENABLE_IOFILTER="true"
[root@oragrid ~]#



[root@oragrid ~]# rpm -qa | grep bpf
libbpf-1.5.0-3.el9.x86_64
bpftool-7.5.0-804.el9.x86_64
[root@oragrid ~]#



 cat /sf_working/scripts/asm_mapping.sh
#!/bin/sh -e
for disk in `/etc/init.d/oracleasm listdisks`
do
oracleasm querydisk -d $disk
#ls -l /dev/*|grep -E `oracleasm querydisk -d $disk|awk '{print $NF}'|sed s'/.$//'|sed '1s/^.//'|awk -F, '{print $1 ",.*" $2}'`
# Alternate option to remove []
ls -l /dev/*|grep -E `oracleasm querydisk -d $disk|awk '{print $NF}'|sed 's/[][]//g'|awk -F, '{print $1 ",.*" $2}'`
echo
done





 blkid|grep asm


[root@oel9 ~]# systemctl restart oracleasm
[root@oel9 ~]# systemctl status oracleasm


[root@oragrid ~]# systemctl status oracleasm
● oracleasm.service - Oracle ASM Service
     Loaded: loaded (/usr/lib/systemd/system/oracleasm.service; enabled; preset>
     Active: active (exited) since Sun 2026-05-31 18:32:01 BST; 13s ago
    Process: 4119 ExecStartPre=/usr/bin/udevadm settle -t 120 (code=exited, sta>
    Process: 4120 ExecStart=/usr/sbin/oracleasm.init start (code=exited, status>
   Main PID: 4120 (code=exited, status=0/SUCCESS)
        CPU: 336ms

May 31 18:32:01 oragrid systemd[1]: Starting Oracle ASM Service...
May 31 18:32:01 oragrid oracleasm.init[4136]: Mounting oracleasm driver filesys>
May 31 18:32:01 oragrid oracleasm.init[4147]: Reloading disk partitions: done
May 31 18:32:01 oragrid oracleasm.init[4147]: Cleaning any stale ASM disks...
May 31 18:32:01 oragrid oracleasm.init[4158]: WARNING: I/O filtering not suppor>
May 31 18:32:01 oragrid oracleasm.init[4163]: Scanning system for ASM disks...
May 31 18:32:01 oragrid oracleasm.init[4183]: Disk scan successful
May 31 18:32:01 oragrid systemd[1]: Finished Oracle ASM Service.
lines 1


C:\Users\anuj2804\OneDrive - Rackspace Inc\Temp---



https://ronekins.com/2025/07/11/installation-and-configuration-of-the-new-oracle-asmlib-v3-1-on-oracle-linux-9/#asmlib-download

You will need to fix this before continuing. To do this add a new entry of kernel.io_uring_disabled = 0 to the end of /etc/sysctl.conf.

Once updated, update the kernel with sysctl -p and check setting with sysctl kernel.io_uring_disabled.

$ sudo sudo sysctl -p 
$ sysctl kernel.io_uring_disabled




 mkdir -p /u01/app/grid/19.3.0/gridhome_1
 mkdir -p /u01/app/grid/gridbase/
mkdir -p /u01/app/oracle/database/19.3.0/dbhome_1
chown -R oracle.oinstall /u01/
chown -R grid.oinstall /u01/app/grid
chmod -R 775 /u01/


mkdir -p /u01/app/19.3.0/grid
mkdir -p /u01/19.3.0/grid

[root@oragrid ~]# mkdir -p /u01/app/19.3.0/grid
[root@oragrid ~]# mkdir -p /u01/19.3.0/grid
[root@oragrid ~]# mkdir -p /u01/app/oraInventory
[root@oragrid ~]#




groupadd -g oinstall
groupadd -g dba
groupadd -g  asmadmin
groupadd -g  asmdba
groupadd -g  asmoper



[root@oragrid ~]# /usr/sbin/useradd -u 3001 -g oinstall -G asmdba,dba,asmadmin oracle
useradd: user 'oracle' already exists
[root@oragrid ~]# /usr/sbin/usermod  -g oinstall -G asmdba,dba,asmadmin oracle
[root@oragrid ~]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),3003(asmadmin),3004(asmdba)
[root@oragrid ~]# id grid
uid=3000(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),3003(asmadmin),3004(asmdba),3005(asmoper)
[root@oragrid ~]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.
[root@oragrid ~]#



mkdir -p /u01/app/grid ( ORACLE_BASE for GRID HOME )
# mkdir -p /u01/app/19.0.0/grid         ( GRID_HOME )
# chown -R grid:oinstall /u01

# mkdir -p /u01/app/oracle              ( ORACLE_BASE for ORACLE HOME ) 
# mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 ( ORACLE HOME )
# chown -R oracle:oinstall /u01/app/oracle

# chmod -R 775 /u01/

[root@testbox ~]# mkdir -p /u01/app/19.0.0/grid
[root@testbox ~]# mkdir -p /u01/app/grid
[root@testbox ~]# chown -R grid:oinstall /u01
[root@testbox ~]#
[root@testbox ~]# mkdir -p /u01/app/oracle
[root@testbox ~]# mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
[root@testbox ~]# chown -R oracle:oinstall /u01/app/oracle
[root@testbox ~]# chmod -R 775 /u01/
[root@testbox ~]#



/usr/sbin/useradd -u 3000 -g oinstall -G asmdba,dba,asmadmin,asmoper grid
passwd grid
/usr/sbin/useradd -u 3001 -g oinstall -G asmdba,dba,asmadmin oracle
/usr/sbin/usermod  -g oinstall -G asmdba,dba,asmadmin oracle
id oracle
id grid
passwd oracle
ls -ltr /u01/19.3.0/grid
history
rm -rf /u01
mkdir -p /u01/app/grid
mkdir -p /u01/app/19.0.0/grid
 chown -R grid:oinstall /u01
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
chown -R grid:oinstall /u01
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/
ls -ld /u01/app/19.0.0/grid
ls -ld /u01/app/grid
ls -ld /u01/app/oracle
ls -ld /u01/app/oracle/product/19.0.0/dbhome_1



[root@oragrid ~]# ls -ltr /dev/sdb*
brw-rw----. 1 root disk 8, 16 Jun  1 19:59 /dev/sdb
brw-rw----. 1 root disk 8, 17 Jun  1 19:59 /dev/sdb1
[root@oragrid ~]#



https://edelivery.oracle.com/

https://yum.oracle.com/repo/OracleLinux/OL8/addons/x86_64/index.html   oracleasm-support-3.1.1-4.el8.x86_64.rpm



 dnf install -y https://yum.oracle.com/repo/OracleLinux/OL8/developer/UEKR7/x86_64/getPackage/libbpf-0.6.0-6.el8.x86_64.rpm
Last metadata expiration check: 0:59:20 ago on Mon 01 Jun 2026 19:15:46 BST.
libbpf-0.6.0-6.el8.x86_64.rpm                                                                                71 kB/s | 162 kB     00:02
Dependencies resolved.
============================================================================================================================================
 Package                       Architecture                  Version                              Repository                           Size
============================================================================================================================================
Upgrading:
 libbpf                        x86_64                        2:0.6.0-6.el8                        @commandline                        162 k

Transaction Summary
============================================================================================================================================
Upgrade  1 Package

Total size: 162 k
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                    1/1
  Upgrading        : libbpf-2:0.6.0-6.el8.x86_64                                                                                        1/2
  Cleanup          : libbpf-0.4.0-1.el8.x86_64                                                                                          2/2
  Running scriptlet: libbpf-0.4.0-1.el8.x86_64                                                                                          2/2
  Verifying        : libbpf-2:0.6.0-6.el8.x86_64                                                                                        1/2
  Verifying        : libbpf-0.4.0-1.el8.x86_64                                                                                          2/2

Upgraded:
  libbpf-2:0.6.0-6.el8.x86_64

Complete!
[root@oragrid ~]#





[root@oragrid ~]# dnf -y localinstall oracleasmlib-3.1.1-1.el8.x86_64.rpm oracleasm-support-3.1.1-4.el8.x86_64.rpm
Last metadata expiration check: 0:59:43 ago on Mon 01 Jun 2026 19:15:46 BST.
Dependencies resolved.
============================================================================================================================================
 Package                               Architecture               Version                            Repository                        Size
============================================================================================================================================
Installing:
 oracleasm-support                     x86_64                     3.1.1-4.el8                        @commandline                      87 k
 oracleasmlib                          x86_64                     3.1.1-1.el8                        @commandline                      52 k

Transaction Summary
============================================================================================================================================
Install  2 Packages

Total size: 138 k
Installed size: 415 k
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                    1/1
  Installing       : oracleasm-support-3.1.1-4.el8.x86_64                                                                               1/2
  Running scriptlet: oracleasm-support-3.1.1-4.el8.x86_64                                                                               1/2
Created symlink /etc/systemd/system/multi-user.target.wants/oracleasm.service → /usr/lib/systemd/system/oracleasm.service.

  Installing       : oracleasmlib-3.1.1-1.el8.x86_64                                                                                    2/2
  Running scriptlet: oracleasmlib-3.1.1-1.el8.x86_64                                                                                    2/2
  Verifying        : oracleasmlib-3.1.1-1.el8.x86_64                                                                                    1/2
  Verifying        : oracleasm-support-3.1.1-4.el8.x86_64                                                                               2/2

Installed:
  oracleasm-support-3.1.1-4.el8.x86_64                                    oracleasmlib-3.1.1-1.el8.x86_64

Complete!
[root@oragrid ~]#



[root@oragrid ~]# systemctl start oracleasm
[root@oragrid ~]# systemctl status oracleasm
● oracleasm.service - Oracle ASM Service
   Loaded: loaded (/usr/lib/systemd/system/oracleasm.service; enabled; vendor preset: disabled)
   Active: active (exited) since Mon 2026-06-01 20:25:01 BST; 8s ago
  Process: 11147 ExecStart=/usr/sbin/oracleasm.init start (code=exited, status=0/SUCCESS)
  Process: 11145 ExecStartPre=/usr/bin/udevadm settle -t 120 (code=exited, status=0/SUCCESS)
 Main PID: 11147 (code=exited, status=0/SUCCESS)

Jun 01 20:25:01 oragrid systemd[1]: Starting Oracle ASM Service...
Jun 01 20:25:01 oragrid oracleasm.init[11147]: Mounting oracleasm driver filesystem: Not applicable with Linux 4.18.0-348.7.1.el8_5.x86_64
Jun 01 20:25:01 oragrid oracleasm.init[11147]: Reloading disk partitions: done
Jun 01 20:25:01 oragrid oracleasm.init[11147]: Cleaning any stale ASM disks...
Jun 01 20:25:01 oragrid oracleasm.init[11147]: Scanning system for ASM disks...
Jun 01 20:25:01 oragrid oracleasm.init[11147]: Disk scan successful
Jun 01 20:25:01 oragrid systemd[1]: Started Oracle ASM Service.
[root@oragrid ~]#


https://yum.oracle.com/repo/OracleLinux/OL8/5/baseos/base/x86_64/index.html

[root@oragrid ~]# yum localinstall ./kmod-redhat-oracleasm-2.0.8-12.0.1.el8.x86_64.rpm
Last metadata expiration check: 0:08:11 ago on Mon 01 Jun 2026 20:28:43 BST.
Dependencies resolved.
============================================================================================================================================
 Package                                 Architecture             Version                              Repository                      Size
============================================================================================================================================
Installing:
 kmod-redhat-oracleasm                   x86_64                   8:2.0.8-12.0.1.el8                   @commandline                    44 k

Transaction Summary
============================================================================================================================================
Install  1 Package

Total size: 44 k
Installed size: 138 k
Is this ok [y/N]: y
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                    1/1
  Installing       : kmod-redhat-oracleasm-8:2.0.8-12.0.1.el8.x86_64                                                                    1/1
  Running scriptlet: kmod-redhat-oracleasm-8:2.0.8-12.0.1.el8.x86_64                                                                    1/1


rpm -qa | grep oracleasm
oracleasm-support-3.1.1-4.el8.x86_64
kmod-redhat-oracleasm-2.0.8-12.0.1.el8.x86_64
oracleasmlib-3.1.1-1.el8.x86_64
[root@oragrid ~]#
Posted by at No comments:

Tuesday, 1 September 2026

oracle 26ai dbca.rsp file 




 cat dbca.rsp
##############################################################################
##                                                                          ##
##                            DBCA response file                            ##
##                            ------------------                            ##
## Copyright(c) Oracle Corporation 1998,2026. All rights reserved.         ##
##                                                                          ##
## Specify values for the variables listed below to customize               ##
## your installation.                                                       ##
##                                                                          ##
## Each variable is associated with a comment. The comment                  ##
## can help to populate the variables with the appropriate                  ##
## values.                                                                  ##
##                                                                          ##
## IMPORTANT NOTE: This file contains plain text passwords and              ##
## should be secured to have read permission only by oracle user            ##
## or db administrator who owns this installation.                          ##
##############################################################################
#-------------------------------------------------------------------------------
# Do not change the following system generated value.
#-------------------------------------------------------------------------------
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v23.0.0

#-----------------------------------------------------------------------------
# Name          : gdbName
# Datatype      : String
# Description   : Global database name of the database
# Valid values  : . - when database domain isn't NULL
#                              - when database domain is NULL
# Default value : None
# Mandatory     : Yes
#-----------------------------------------------------------------------------
gdbName=orcl.localdomain

#-----------------------------------------------------------------------------
# Name          : sid
# Datatype      : String
# Description   : System identifier (SID) of the database
# Valid values  : Check Oracle12c Administrator's Guide
# Default value :  specified in GDBNAME
# Mandatory     : No
#-----------------------------------------------------------------------------
sid=orcl

#-----------------------------------------------------------------------------
# Name          : databaseConfigType
# Datatype      : String
# Description   : database conf type as Single Instance, Real Application Cluster, Real Application Cluster One Nodes database or Standard Edition High Availability
# Valid values  : SI\RAC\RACONENODE\SEHA
# Default value : SI
# Mandatory     : No
#-----------------------------------------------------------------------------
databaseConfigType=SI

#-----------------------------------------------------------------------------
# Name          : RACOneNodeServiceName
# Datatype      : String
# Description   : Service is required by application to connect to RAC One
#                 Node Database
# Valid values  : Service Name
# Default value : None
# Mandatory     : No [required in case DATABASECONFTYPE is set to RACONENODE ]
#-----------------------------------------------------------------------------
RACOneNodeServiceName=

#-----------------------------------------------------------------------------
# Name          : sehaServiceName
# Datatype      : String
# Description   : Service is required by application to connect to SEHA Database
# Valid values  : SEHA Service Name
# Default value : None
# Mandatory     : No [required in case DATABASECONFTYPE is set to SEHA ]
#-----------------------------------------------------------------------------
sehaServiceName=

#-----------------------------------------------------------------------------
# Name          : policyManaged
# Datatype      : Boolean
# Description   : Set to true if Database is policy managed and
#                 set to false if  Database is admin managed
# Valid values  : TRUE\FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
policyManaged=false

#-----------------------------------------------------------------------------
# Name          : managementPolicy
# Datatype      : String
# Description   : Set to AUTOMATIC or RANK based on management policy.
# Valid values  : AUTOMATIC\RANK
# Default value : AUTOMATIC
# Mandatory     : No
#-----------------------------------------------------------------------------
managementPolicy=AUTOMATIC

#-----------------------------------------------------------------------------
# Name          : createServerPool
# Datatype      : Boolean
# Description   : Set to true if new server pool need to be created for database
#                 if this option is specified then the newly created database
#                 will use this newly created serverpool.
#                 Multiple serverpoolname can not be specified for database
# Valid values  : TRUE\FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
createServerPool=false

#-----------------------------------------------------------------------------
# Name          : serverPoolName
# Datatype      : String
# Description   : Only one serverpool name need to be specified
#                  if Create Server Pool option is specified.
#                  Comma-separated list of Serverpool names if db need to use
#                  multiple Server pool
# Valid values  : ServerPool name

# Default value : None
# Mandatory     : No [required in case of RAC service centric database]
#-----------------------------------------------------------------------------
serverPoolName=

#-----------------------------------------------------------------------------
# Name          : cardinality
# Datatype      : Number
# Description   : Specify Cardinality for create server pool operation

# Valid values  : any positive Integer value
# Default value : Number of qualified nodes on cluster
# Mandatory     : No [Required when a new serverpool need to be created]
#-----------------------------------------------------------------------------
cardinality=

#-----------------------------------------------------------------------------
# Name          : force
# Datatype      : Boolean
# Description   : Set to true if new server pool need to be created by force
#                 if this option is specified then the newly created serverpool
#                 will be assigned server even if no free servers are available.
#                 This may affect already running database.
#                 This flag can be specified for Admin managed as well as policy managed db.
# Valid values  : TRUE\FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
force=false

#-----------------------------------------------------------------------------
# Name          : pqPoolName
# Datatype      : String
# Description   : Only one serverpool name needs to be specified
#                  if create server pool option is specified.
#                  Comma-separated list of serverpool names if use
#                  server pool. This is required to
#                  create Parallel Query (PQ) database. Applicable to Big Cluster
# Valid values  :  Parallel Query (PQ) pool name
# Default value : None
# Mandatory     : No [required in case of RAC service centric database]
#-----------------------------------------------------------------------------
pqPoolName=

#-----------------------------------------------------------------------------
# Name          : pqCardinality
# Datatype      : Number
# Description   : Specify Cardinality for create server pool operation.
#                 Applicable to Big Cluster
# Valid values  : any positive Integer value
# Default value : Number of qualified nodes on cluster
# Mandatory     : No [Required when a new serverpool need to be created]
#-----------------------------------------------------------------------------
pqCardinality=

#-----------------------------------------------------------------------------
# Name          : createAsContainerDatabase
# Datatype      : boolean
# Description   : flag to create database as container database
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : false
# Mandatory     : No
#-----------------------------------------------------------------------------
createAsContainerDatabase=true

#-----------------------------------------------------------------------------
# Name          : numberOfPDBs
# Datatype      : Number
# Description   : Specify the number of pdb to be created
# Valid values  : 0 to 252
# Default value : 0
# Mandatory     : No
#-----------------------------------------------------------------------------
numberOfPDBs=1

#-----------------------------------------------------------------------------
# Name          : pdbName
# Datatype      : String
# Description   : Specify the pdbname/pdbanme prefix if one or more pdb need to be created
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
pdbName=vihaan2

#-----------------------------------------------------------------------------
# Name          : useLocalUndoForPDBs
# Datatype      : boolean
# Description   : Flag to create local undo tablespace for all PDB's.
# Valid values  : TRUE\FALSE
# Default value : TRUE
# Mandatory     : No
#-----------------------------------------------------------------------------
useLocalUndoForPDBs=true

#-----------------------------------------------------------------------------
# Name          : pdbAdminPassword
# Datatype      : String
# Description   : PDB Administrator user password
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------

pdbAdminPassword=

#-----------------------------------------------------------------------------
# Name          : nodelist
# Datatype      : String
# Description   : Comma-separated list of cluster nodes
# Valid values  : Cluster node names
# Default value : None
# Mandatory     : No (Yes for RAC database-centric database )
#-----------------------------------------------------------------------------
nodelist=

#-----------------------------------------------------------------------------
# Name          : sehaNodeList
# Datatype      : String
# Description   : Comma-separated list of cluster nodes
# Valid values  : Cluster node names
# Default value : None
# Mandatory     : No (Yes for SEHA database)
#-----------------------------------------------------------------------------
sehaNodeList=

#-----------------------------------------------------------------------------
# Name          : templateName
# Datatype      : String
# Description   : Name of the template
# Valid values  : Template file name
# Default value : None
# Mandatory     : Yes
#-----------------------------------------------------------------------------
templateName=/u01/app/oracle/product/26.3.0/db/assistants/dbca/templates/General_Purpose.dbc

#-----------------------------------------------------------------------------
# Name          : sysPassword
# Datatype      : String
# Description   : Password for SYS user
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : Yes
#-----------------------------------------------------------------------------
sysPassword=

#-----------------------------------------------------------------------------
# Name          : systemPassword
# Datatype      : String
# Description   : Password for SYSTEM user
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : Yes
#-----------------------------------------------------------------------------
systemPassword=

#-----------------------------------------------------------------------------
# Name          : serviceUserPassword
# Datatype      : String
# Description   : Password for Windows Service user
# Default value : None
# Mandatory     : If Oracle home is installed with windows service user
#-----------------------------------------------------------------------------
serviceUserPassword=

#-----------------------------------------------------------------------------
# Name          : emConfiguration
# Datatype      : String
# Description   : Enterprise Manager Configuration Type
# Valid values  : CENTRAL|NONE
# Default value : NONE
# Mandatory     : No
#-----------------------------------------------------------------------------
emConfiguration=

#-----------------------------------------------------------------------------
# Name          : runCVUChecks
# Datatype      : Boolean
# Description   : Specify whether to run Cluster Verification Utility checks
#                 periodically in Cluster environment
# Valid values  : TRUE\FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
runCVUChecks=FALSE

#-----------------------------------------------------------------------------
# Name          : dbsnmpPassword
# Datatype      : String
# Description   : Password for DBSNMP user
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : Yes, if emConfiguration is specified or
#                 the value of runCVUChecks is TRUE
#-----------------------------------------------------------------------------
dbsnmpPassword=

#-----------------------------------------------------------------------------
# Name          : omsHost
# Datatype      : String
# Description   : EM management server host name
# Default value : None
# Mandatory     : Yes, if CENTRAL is specified for emConfiguration
#-----------------------------------------------------------------------------
omsHost=

#-----------------------------------------------------------------------------
# Name          : omsPort
# Datatype      : Number
# Description   : EM management server port number
# Default value : None
# Mandatory     : Yes, if CENTRAL is specified for emConfiguration
#-----------------------------------------------------------------------------
omsPort=0

#-----------------------------------------------------------------------------
# Name          : emUser
# Datatype      : String
# Description   : EM Admin username to add or modify targets
# Default value : None
# Mandatory     : Yes, if CENTRAL is specified for emConfiguration
#-----------------------------------------------------------------------------
emUser=

#-----------------------------------------------------------------------------
# Name          : emPassword
# Datatype      : String
# Description   : EM Admin user password
# Default value : None
# Mandatory     : Yes, if CENTRAL is specified for emConfiguration
#-----------------------------------------------------------------------------
emPassword=

#-----------------------------------------------------------------------------
# Name          : dvConfiguration
# Datatype      : Boolean
# Description   : Specify "True" to configure and enable Oracle Database vault
# Valid values  : True/False
# Default value : False
# Mandatory     : No
#-----------------------------------------------------------------------------
dvConfiguration=false

#-----------------------------------------------------------------------------
# Name          : dvUserName
# Datatype      : String
# Description   : DataVault Owner
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : Yes, if DataVault option is chosen
#-----------------------------------------------------------------------------
dvUserName=

#-----------------------------------------------------------------------------
# Name          : dvUserPassword
# Datatype      : String
# Description   : Password for DataVault Owner
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : Yes, if DataVault option is chosen
#-----------------------------------------------------------------------------
dvUserPassword=

#-----------------------------------------------------------------------------
# Name          : dvAccountManagerName
# Datatype      : String
# Description   : DataVault Account Manager
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
dvAccountManagerName=

#-----------------------------------------------------------------------------
# Name          : dvAccountManagerPassword
# Datatype      : String
# Description   : Password for  DataVault Account Manager
# Valid values  : Check Oracle12c Administrator's Guide
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
dvAccountManagerPassword=

#-----------------------------------------------------------------------------
# Name          : olsConfiguration
# Datatype      : Boolean
# Description   : Specify "True" to configure and enable Oracle Label Security
# Valid values  : True/False
# Default value : False
# Mandatory     : No
#-----------------------------------------------------------------------------
olsConfiguration=false

#-----------------------------------------------------------------------------
# Name          : datafileJarLocation
# Datatype      : String
# Description   : Location of the data file jar
# Valid values  : Directory containing compressed datafile jar
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
datafileJarLocation={ORACLE_HOME}/assistants/dbca/templates/

#-----------------------------------------------------------------------------
# Name          : datafileDestination
# Datatype      : String
# Description   : Location of the data file's
# Valid values  : Directory for all the database files
# Default value : $ORACLE_BASE/oradata
# Mandatory     : No
#-----------------------------------------------------------------------------
datafileDestination=+DATA/{DB_UNIQUE_NAME}/

#-----------------------------------------------------------------------------
# Name          : recoveryAreaDestination
# Datatype      : String
# Description   : Location of the data file's
# Valid values  : Recovery Area location
# Default value : $ORACLE_BASE/flash_recovery_area
# Mandatory     : No
#-----------------------------------------------------------------------------
recoveryAreaDestination=/u01/app/oracle/fast

#-----------------------------------------------------------------------------
# Name          : recoveryAreaSize
# Datatype      : String
# Description   : Recovery area size
# Mandatory     : No
#-----------------------------------------------------------------------------
recoveryAreaSize=14922MB

#-----------------------------------------------------------------------------
# Name          : configureWithOID
# Datatype      : Boolean
# Description   : To configure with OID or not
# Valid values  : TRUE / FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
configureWithOID=

#-----------------------------------------------------------------------------
# Name          : pdbOptionMap
# Datatype      : String
# Description   : Values for DB Options indicating whether they should be included in PDB
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
pdbOptions=JSERVER:true,SPATIAL:true,OMS:true,IMEDIA:false,SAMPLE_SCHEMA:false,ORACLE_TEXT:true,CWMLITE:true,DV:true

#-----------------------------------------------------------------------------
# Name          : dbOptionMap
# Datatype      : String
# Description   : Values DB Options indicating whether they are enabled
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
dbOptions=JSERVER:true,SPATIAL:true,OMS:true,IMEDIA:false,SAMPLE_SCHEMA:false,ORACLE_TEXT:true,CWMLITE:true,DV:true

#-----------------------------------------------------------------------------
# Name          : storageType
# Datatype      : String
# Description   : Specifies the storage on which the database is to be created
# Valid values  : FS (CFS for RAC), ASM
# Default value : FS
# Mandatory     : No
#-----------------------------------------------------------------------------
storageType=ASM

#-----------------------------------------------------------------------------
# Name          : diskGroupName
# Datatype      : String
# Description   : Specifies the disk group name for the storage
# Default value : DATA
# Mandatory     : No
#-----------------------------------------------------------------------------
diskGroupName=+DATA/{DB_UNIQUE_NAME}/

#-----------------------------------------------------------------------------
# Name          : asmsnmpPassword
# Datatype      : String
# Description   : Password for ASM Monitoring
# Default value : None
# Mandatory     : No
#-----------------------------------------------------------------------------
asmsnmpPassword=

#-----------------------------------------------------------------------------
# Name          : recoveryGroupName
# Datatype      : String
# Description   : Specifies the disk group name for the recovery area
# Default value : RECOVERY
# Mandatory     : No
#-----------------------------------------------------------------------------
recoveryGroupName=/u01/app/oracle/fast

#-----------------------------------------------------------------------------
# Name          : characterSet
# Datatype      : String
# Description   : Character set of the database
# Valid values  : Check Oracle12c National Language Support Guide
# Default value : "US7ASCII"
# Mandatory     : NO
#-----------------------------------------------------------------------------
characterSet=AL32UTF8

#-----------------------------------------------------------------------------
# Name          : nationalCharacterSet
# Datatype      : String
# Description   : National Character set of the database
# Valid values  : "UTF8" or "AL16UTF16". For details, check Oracle12c National Language Support Guide
# Default value : "AL16UTF16"
# Mandatory     : No
#-----------------------------------------------------------------------------
nationalCharacterSet=AL16UTF16

#-----------------------------------------------------------------------------
# Name          : registerWithDirService
# Datatype      : Boolean
# Description   : Specifies whether to register with Directory Service.
# Valid values  : TRUE \ FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
registerWithDirService=false


#-----------------------------------------------------------------------------
# Name          : dirServiceUserName
# Datatype      : String
# Description   : Specifies the name of the directory service user
# Mandatory     : YES, if the value of registerWithDirService is TRUE
#-----------------------------------------------------------------------------
dirServiceUserName=

#-----------------------------------------------------------------------------
# Name          : dirServicePassword
# Datatype      : String
# Description   : The password of the directory service user.
#                 You can also specify the password at the command prompt instead of here.
# Mandatory     : YES, if the value of registerWithDirService is TRUE
#-----------------------------------------------------------------------------
dirServicePassword=

#-----------------------------------------------------------------------------
# Name          : walletPassword
# Datatype      : String
# Description   : The password for wallet to created or modified.
#                 You can also specify the password at the command prompt instead of here.
# Mandatory     : YES, if the value of registerWithDirService is TRUE
#-----------------------------------------------------------------------------
walletPassword=

#-----------------------------------------------------------------------------
# Name          : listeners
# Datatype      : String
# Description   : Specifies list of listeners to register the database with.
#                 By default the database is configured for all the listeners specified in the
#                 $ORACLE_HOME/network/admin/listener.ora
# Valid values  : The list should be comma separated like "listener1,listener2".
# Mandatory     : NO
#-----------------------------------------------------------------------------
listeners=LISTENER

#-----------------------------------------------------------------------------
# Name          : skipListenerRegistration
# Datatype      : Boolean
# Description   : FALSE if no listener chosen for registration, else true.
# Valid values  : TRUE/FALSE
# Mandatory     : NO
#-----------------------------------------------------------------------------
skipListenerRegistration=false

#-----------------------------------------------------------------------------
# Name          : variablesFile
# Datatype      : String
# Description   : Location of the file containing variable value pair
# Valid values  : A valid file-system file. The variable value pair format in this file
#                 is =. Each pair should be in a new line.
# Default value : None
# Mandatory     : NO
#-----------------------------------------------------------------------------
variablesFile=

#-----------------------------------------------------------------------------
# Name          : variables
# Datatype      : String
# Description   : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates
# Default value : None
# Mandatory     : NO
#-----------------------------------------------------------------------------
variables=ORACLE_BASE_HOME=/u01/app/oracle/product/26.3.0/db,DB_UNIQUE_NAME=orcl,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=orcl,ORACLE_HOME=/u01/app/oracle/product/26.3.0/db,SID=orcl

#-----------------------------------------------------------------------------
# Name          : initParams
# Datatype      : String
# Description   : comma separated list of name=value pairs. Overrides initialization parameters defined in templates
# Default value : None
# Mandatory     : NO
#-----------------------------------------------------------------------------
initParams=undo_tablespace=UNDOTBS1,enable_pluggable_database=true,sga_target=3438MB,db_block_size=8192BYTES,nls_language=ENGLISH,dispatchers=(PROTOCOL=TCP) (SERVICE=orclXDB),diagnostic_dest={ORACLE_BASE},remote_login_passwordfile=EXCLUSIVE,db_create_file_dest=+DATA/{DB_UNIQUE_NAME}/,processes=720,pga_aggregate_target=1146MB,nls_territory=UNITED KINGDOM,local_listener=LISTENER_ORCL,open_cursors=300,db_domain=localdomain,compatible=23.6.0,db_name=orcl

#-----------------------------------------------------------------------------
# Name          : enableArchive
# Datatype      : Boolean
# Description   : Specifies whether to enable archive log.
# Valid values  : TRUE \ FALSE
# Default value : FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
enableArchive=false

#-----------------------------------------------------------------------------
# Name          : useOMF
# Datatype      : Boolean
# Description   : Specifies whether to use OMF or not.
# Valid values  : TRUE \ FALSE
# Mandatory     : No
#-----------------------------------------------------------------------------
useOMF=true

#-----------------------------------------------------------------------------
# Name          : memoryPercentage
# Datatype      : String
# Description   : percentage of physical memory for Oracle
# Default value : None
# Mandatory     : NO
#-----------------------------------------------------------------------------
memoryPercentage=40

#-----------------------------------------------------------------------------
# Name          : databaseType
# Datatype      : String
# Description   : used for memory distribution when memoryPercentage specified
# Valid values  : MULTIPURPOSE|DATA_WAREHOUSING|OLTP
# Default value : MULTIPURPOSE
# Mandatory     : NO
#-----------------------------------------------------------------------------
databaseType=MULTIPURPOSE

#-----------------------------------------------------------------------------
# Name          : automaticMemoryManagement
# Datatype      : Boolean
# Description   : flag to indicate Automatic Memory Management is used
# Valid values  : TRUE/FALSE
# Default value : TRUE
# Mandatory     : NO
#-----------------------------------------------------------------------------
automaticMemoryManagement=false

#-----------------------------------------------------------------------------
# Name          : totalMemory
# Datatype      : String
# Description   : total memory in MB to allocate to Oracle
# Valid values  :
# Default value :
# Mandatory     : NO
#-----------------------------------------------------------------------------
totalMemory=0[oracle@ora26 ~]$
Posted by at No comments:
Subscribe to: Posts (Atom)

Oracle DBA

My photo
Essex, United Kingdom

anuj blog Archive