Since the documentation to install Oracle Database on the Solaris SPARC 64bit is so lame, I wrote the short step-by-step instruction on how to install the database, using response file.
I assume, that the network is configured and all appropriate packages are installed, so let’s start with configuring project and kernel parameter for user oracle:
1 | # groupadd dba |
2 | # groupadd oinstall |
3 | # useradd -m -g oinstall -G dba oracle |
4 | # projadd user.oracle |
We will use values for the appropriate parameters from documentation:
http://docs.oracle.com/database/121/SSDQI/toc.htm#BABDAGHH
1 | # projmod -s -K "project.max-sem-ids=(privileged,100,deny)" user.oracle |
2 | # projmod -s -K "process.max-sem-nsems=(privileged,256,deny)" user.oracle |
3 | # projmod -s -K "project.max-shm-memory=(privileged,10g,deny)" user.oracle |
4 | # projmod -s -K "project.max-shm-ids=(privileged,100,deny)" user.oracle |
5 | # projmod -s -K "process.max-file-descriptor=(privileged,65536,deny)" user.oracle |
6 | # projects -l user.oracle |
7 | user.oracle |
8 | projid : 100 |
9 | comment: "" |
10 | users : (none) |
11 | groups : (none) |
12 | attribs: process.max-file-descriptor=(privileged,65536,deny) |
13 | process.max-sem-nsems=(privileged,256,deny) |
14 | project.max-sem-ids=(privileged,100,deny) |
15 | project.max-shm-ids=(privileged,100,deny) |
16 | project.max-shm-memory=(privileged,10737418240,deny) |
17 | # ipadm set-prop -p smallest_anon_port=9000 tcp |
18 | # ipadm set-prop -p largest_anon_port=65500 tcp |
19 | # ipadm set-prop -p smallest_anon_port=9000 udp |
20 | # ipadm set-prop -p largest_anon_port=65500 udp |
21 | # ipadm show-prop tcp |
22 | PROTO PROPERTY PERM CURRENT PERSISTENT DEFAULT POSSIBLE |
23 | tcp cong_default rw newreno -- newreno newreno,cubic, |
24 | highspeed,vegas |
25 | tcp cong_enabled rw newreno,cubic, newreno,cubic, newreno newreno,cubic, |
26 | highspeed, highspeed, highspeed,vegas |
27 | vegas vegas |
28 | tcp ecn rw passive -- passive never,passive, |
29 | active |
30 | tcp extra_priv_ports rw 2049,4045 -- 2049,4045 1-65535 |
31 | tcp largest_anon_port rw 65500 65500 65535 9000-65535 |
32 | tcp max_buf rw 1048576 -- 1048576 128000-1073741824 |
33 | tcp recv_buf rw 128000 -- 128000 2048-1048576 |
34 | tcp sack rw active -- active never,passive, |
35 | active |
36 | tcp send_buf rw 49152 -- 49152 4096-1048576 |
37 | tcp smallest_anon_port rw 9000 9000 32768 1024-65500 |
38 | tcp smallest_nonpriv_port rw 1024 -- 1024 1024-32768 |
39 | # ipadm show-prop udp |
40 | PROTO PROPERTY PERM CURRENT PERSISTENT DEFAULT POSSIBLE |
41 | udp extra_priv_ports rw 2049,4045 -- 2049,4045 1-65535 |
42 | udp largest_anon_port rw 65500 65500 65535 9000-65535 |
43 | udp max_buf rw 2097152 -- 2097152 65536-1073741824 |
44 | udp recv_buf rw 57344 -- 57344 128-2097152 |
45 | udp send_buf rw 57344 -- 57344 1024-2097152 |
46 | udp smallest_anon_port rw 9000 9000 32768 1024-65500 |
47 | udp smallest_nonpriv_port rw 1024 -- 1024 1024-32768 |
To meet all the requirements we will set the amount of SWAP to same value as RAM:
1 | # prtconf | grep Memory |
2 | Memory size: 16384 Megabytes |
3 | # zfs set volsize=16G rpool/swap |
4 | # zfs list | grep swap |
5 | rpool/swap 16.5G 43.7G 16.0G - |
We will install software only and use the dbca to create a database.
For installing software only version you have to alter only those lines in the response file:
1 | oracle.install.option=INSTALL_DB_SWONLY |
2 |
3 | ORACLE_HOSTNAME=oradb |
4 |
5 | UNIX_GROUP_NAME=oinstall |
6 |
7 | INVENTORY_LOCATION=/u01/app/oraInventory |
8 |
9 | ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1 |
10 |
11 | ORACLE_BASE=/u01/app/oracle |
12 |
13 | oracle.install.db.InstallEdition=SE |
14 |
15 | oracle.install.db.DBA_GROUP=dba |
16 |
17 | DECLINE_SECURITY_UPDATES=true |
18 |
19 | oracle.installer.autoupdates.option=SKIP_UPDATES |
The installation command looks like this:
1 | $ ./runInstaller -silent -showProgress -responseFile /export/home/oracle/database/db_install.rsp |
2 | oracle@oradb:~/database$ ./runInstaller -silent -showProgress -responseFile /export/home/oracle/database/db_install.rsp |
3 | Starting Oracle Universal Installer... |
4 |
5 | Checking Temp space: must be greater than 180 MB. Actual 20498 MB Passed |
6 | Checking swap space: must be greater than 150 MB. Actual 21656 MB Passed |
7 | Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-03-12_09-35-18PM. Please wait ... |
8 | $ ps aux |[WARNING] [INS-13014] Target environment do not meet some optional requirements. |
9 | CAUSE: Some of the optional prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/installActions2015-03-12_09-35-18PM.log |
10 | ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/installActions2015-03-12_09-35-18PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually. |
11 | You can find the log of this install session at: |
12 | /u01/app/oraInventory/logs/installActions2015-03-12_09-35-18PM.log |
13 |
14 | Prepare in progress. |
15 | .................................................. 9% Done. |
16 |
17 | Prepare successful. |
18 |
19 | Copy files in progress. |
20 | .................................................. 15% Done. |
21 | .................................................. 21% Done. |
22 | .................................................. 27% Done. |
23 | .................................................. 32% Done. |
24 | .................................................. 37% Done. |
25 | .................................................. 42% Done. |
26 | .................................................. 47% Done. |
27 | .................................................. 53% Done. |
28 | .................................................. 58% Done. |
29 | .................................................. 63% Done. |
30 | .................................................. 68% Done. |
31 | .................................................. 73% Done. |
32 | .................................................. 78% Done. |
33 | .................................................. 83% Done. |
34 | .............................. |
35 | Copy files successful. |
36 |
37 | Link binaries in progress. |
38 | .......... |
39 | Link binaries successful. |
40 |
41 | Setup files in progress. |
42 | .................................................. 88% Done. |
43 | .................................................. 94% Done. |
44 |
45 | Setup files successful. |
46 | The installation of Oracle Database 11g was successful. |
47 | Please check '/u01/app/oraInventory/logs/silentInstall2015-03-12_09-35-18PM.log' for more details. |
48 |
49 | Execute Root Scripts in progress. |
50 |
51 | As a root user, execute the following script(s): |
52 | 1. /u01/app/oracle/product/11.2.0.4/dbhome_1/root.sh |
53 |
54 |
55 | .................................................. 100% Done. |
56 |
57 | Execute Root Scripts successful. |
58 | Successfully Setup Software. |
Now let’s create the database with dbca:
1 | dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName orcl -sid orcl -sysPassword Dupa123 -systemPassword Dupa123 -emConfiguration LOCAL -dbsnmpPassword Dupa123 -sysmanPassword Dupa123 -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet EE8MSWIN1250 -nationalCharacterSet AL16UTF16 -automaticMemoryManagement false -totalMemory 4096 -databaseType MULTIPURPOSE |
2 | sh: line 1: showrev: not found |
3 | sh: line 1: showrev: not found |
4 | Copying database files |
5 | 1% complete |
6 | 3% complete |
7 | 11% complete |
8 | 18% complete |
9 | 26% complete |
10 | 37% complete |
11 | Creating and starting Oracle instance |
12 | 40% complete |
13 | 45% complete |
14 | 50% complete |
15 | 55% complete |
16 | 56% complete |
17 | 60% complete |
18 | 62% complete |
19 | Completing Database Creation |
20 | 66% complete |
21 | 70% complete |
22 | 73% complete |
23 | 85% complete |
24 | 96% complete |
25 | 100% complete |
26 | Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details. |