Tag Archives: Kernel Parameters

Adding 3GB to Boot.ini Windows 2008

Problem:

In Windows Server 2003, to increase the memory allocated the applications, we usually modify the boot.ini and add /3GB. However, there is not boot.ini in Windows 2008. How can more memory be allocated to user’s applications?

Solution:

Use the BCDEDIT command.

Read more »

ORA-00600, ORA-27301 When Creating 9i Database

Problem:

When creating a new Oracle 9i database using dbca (Database Configuration Assistant), the following error appears when the database is being created (at the ‘Creating and starting Oracle instance (46 %)’ step).

ORA-00600: internal error code, arguments: [OSDEP_INTERNAL], [], [], [], [], [], [], []
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-27146: post/wait initialization failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpsemsper

Solution:

Change the semaphore settings.

Read more »

Installing Oracle Database 10g Release 2 (10.2) for Linux x86

Installing Oracle Database 10g Release 2 (10.2) for Linux x86

1. Download the 10201_database_linux32.zip file from the Oracle web site

22d23ab01a8013500313ff92f65d0fe5  10201_database_linux32.zip  668734007KB

2. Unzip the zip file in an appropriate directory.

3. Open the welcome.html file from the database directory.

4. Click the Documentation tab, then click on the Quick Installation Guide HTML link. Follow the steps to begin installation

———-

1. Log on as root user and execute the commands:

# xhost +

# grep MemTotal /proc/meminfo

# grep SwapTotal /proc/meminfo

# free

# df -k /tmp

# df -k

# grep “model name” /proc/cpuinfo

2. Ensure that the following packages (or later versions) are installed for Red Hat Enterprise Linux 4.0:

* make-3.79.1 [make-3.80-6.EL4 found]
* gcc-3.2.3-34 [gcc-3.4.6-3.1 found]
* glibc-2.3.2-95.20 [glibc-2.3.4-2.25 found]
* compat-db-4.0.14-5 [compat-db-4.1.25-9 found]
* compat-gcc-7.3-2.96.128 [not found]
* compat-gcc-c++-7.3-2.96.128 [not found]
* compat-libstdc++-7.3-2.96.128 [not found]
* compat-libstdc++-devel-7.3-2.96.128 [not found]
* openmotif21-2.1.30-8 [not found]
* setarch-1.3-1 [setarch-1.6-1 found]

To update these packages, navigate to Add or Remove Packages and check Legacy Software Development. Then click Update.

3. Issue more commands:

cat /etc/issue

uname -r

4. Set up Oracle user and groups

# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba

# id oracle

# /usr/sbin/useradd -g oinstall -G dba oracle
or
# /usr/sbin/usermod -g oinstall -G dba oracle

# id nobody

5. Update kernel parameters. Edit /etc/sysctl.conf and add the following parameters:

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
rmem_default = 262144
rmem_max = 262144
wmem_default = 262144
wmem_max = 262144

6. Prerequisite Check Errors

Error Encountered:
—————–
Checking operating system package requirements …
Checking for make-3.79; found make-1:3.80-6.EL4.    Passed
Checking for binutils-2.14; found binutils-2.15.92.0.2-21.    Passed
Checking for gcc-3.2; found gcc-3.4.6-3.1.    Passed
Checking for libaio-0.3.96; found Not found.    Failed <<<<
Check complete. The overall result of this check is: Failed <<<<
Problem: Some packages required for the Oracle Database 10g to function properly are missing (see above).

Solution:
——–
Install libaio-0.3.105-2.i386.rpm from CD 3

Error Encountered:
—————–
Checking kernel parameters
Checking for semmsl=250; found semmsl=250.    Passed
Checking for semmns=32000; found semmns=32000.    Passed
Checking for semopm=100; found semopm=100.    Passed
Checking for semmni=128; found semmni=128.    Passed
Checking for shmmax=536870912; found shmmax=2147483648.    Passed
Checking for shmmni=4096; found shmmni=4096.    Passed
Checking for shmall=2097152; found shmall=2097152.    Passed
Checking for file-max=65536; found file-max=65536.    Passed
Checking for VERSION=2.6.9; found VERSION=2.6.9-42.0.0.0.1.EL.    Passed
Checking for ip_local_port_range=1024 – 65000; found ip_local_port_range=1024 – 65000.    Passed
Checking for rmem_default=262144; found rmem_default=110592.    Failed <<<<
Checking for rmem_max=262144; found rmem_max=131071.    Failed <<<<
Checking for wmem_default=262144; found wmem_default=110592.    Failed <<<<
Checking for wmem_max=262144; found wmem_max=131071.    Failed <<<<
Check complete. The overall result of this check is: Failed <<<<
Problem: The kernel parameters do not meet the minimum requirements (see above).
Recommendation: Perform operating system specific instructions to update the kernel parameters.

Solution:
——–
/etc/sysctl.conf should read (last four parameters different):

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

Error Encountered:
—————–
Checking available swap space requirements …
Expected result: 2274MB
Actual Result: 1983MB
Check complete. The overall result of this check is: Failed <<<<
Problem: The system does not have the required swap space.
Recommendation: Make more swap space available to perform the install.

Solution:
——–
Create a new swap partition.

fdisk /dev/hdb

Delete old partition, create a new /dev/hdb1 and /dev/hdb2, with /dev/hdb2 at least 2275MB
Edit /etc/fstab and add new swap device
mount -a
swapon -a

Set environment variables for ORACLE_BASE, ORACLE_HOME and SID before starting dbca

SID should be in lowercase e.g. orcl

Set Global Database Identifier same as SID i.e. orcl

After installing, run lab_02_05.sh script to create listener. Or create it manually.
Configure a TNS Listener using netca

Configure orcl entry in tnsnames.ora using netca >

Start dbconsole using emctl start dbconsole: gave error about

Timezone mismatch: The agentTZRegion value (GMT) in
/u1/app/oracle/product/10.2.0/db_1/enterprise.support.com_orcl/sysman/config/emd.properties
does not match the current environment TZ setting().
The dbconsole cannot run with this mismatch.

If GMT is the correct timezone, set your timezone environment variable to GMT and repeat the ’emctl start dbconsole’ operation.

If GMT is not the correct timezone, make sure that the timezone in your environment is correct, and then run the following command in your local Oracle Home: ’emctl resetTZ agent’

The output of this command will include detailed instructions to follow, to correct the mismatch.

[oracle@enterprise admin]$ emctl resetTZ agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Updating /u1/app/oracle/product/10.2.0/db_1/enterprise.support.com_orcl/sysman/config/emd.properties…
Time zone set to America/Anguilla.

To complete this process, you must either:

connect to the database served by this DBConsole as user ‘sysman’, and execute:

SQL> exec mgmt_target.set_agent_tzrgn(‘enterprise.support.com:3938′,’America/Anguilla’)

— or —

connect to the database served by this DBConsole as user ‘sys’, and execute:

SQL> alter session set current_schema = SYSMAN;
SQL> exec mgmt_target.set_agent_tzrgn(‘enterprise.support.com:3938′,’America/Anguilla’)

sqlplus sys/oracle
alter session set current_schema = SYSMAN;

exec mgmt_target.set_agent_tzrgn(‘enterprise.support.com:3938′,’America/Anguilla’);

Error Encountered:
—————–
Unable to connect using service (orcl) as in sqlplus system/oracle@orcl

Solution:
——–
Added the following lines to the listener.ora file:

(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u1/app/oracle/product/10.2.0/db_1/)
(SID_NAME = orcl)
)

The listener.ora file now reads:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u1/app/oracle/product/10.2.0/db_1/)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u1/app/oracle/product/10.2.0/db_1/)
(SID_NAME = orcl)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = enterprise.support.com)(PORT = 1521))
)
)