Oracle10gforsolaris preparation and deletion of instances

First, create groupaddoinstallgroupadddbauseradd-goinstall-Gdba-susrbincsh-dexporthomeora.

First, create the user groupadd oinstall groupadd dba useradd-g oinstall-G dba-s/usr/bin/csh-d/export/home/ora.

First, create a user.

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-G dba-s/usr/bin/csh-d/export/home/Oracle-m oracle

Second, create an access point

Df-k

Mkdir-p/opt/app/oracle/10.2.0

Mkdir-p/opt/app/oracle/doc

Chown-R oracle: oinstall/opt/app/oracle

Ls-l/opt/app/oracle

Third, configure the user's Environment Variables

Cp. cshrc. bak

Vi. cshrc

Umask 022

Setenv ORACLE_BASE/opt/app/oracle/

Setenv ORACLE_HOME/opt/app/oracle/10.2.0

Setenv ORACLE_DOC/opt/app/oracle/doc

Setenv ORACLE_SID Instance name

Setenv NLS_LANG "simplified chinese_china.ZHS16GBK"

Setenv NLS_DATE_FORMAT "YYYY-MM-DD HH24: Mi: SS"

Setenv LANG zh

Set path = (/bin/usr/ucb/etc $ ORACLE_HOME/bin .)

If ($? Prompt) then

Set history = 32

Endif

========================================================== ==================================

========================================================== ==================================

Source. cshrc

Env

Fourth, modify system kernel parameters

Modify system quota:

# Id-p oracle

Uid = 605 (oracle) gid = 601 (dba) projid = 3 (default)

# Projadd-U oracle-p 1233-c "oracle parameters setting" user. oracle

# Projmod-a-K "project. max-shm-memory = (priv, 12000000000, deny)" user. oracle

# Projmod-a-K "project. max-sem-ids = (priv, 256, deny)" user. oracle

# Projmod-a-K "process. max-sem-nsems = (priv, 1024, deny)" user. oracle

# Projmod-a-K "project. max-shm-ids = (priv, 256, deny)" user. oracle

Modify the vi/etc/system mode. Add the following lines at the end of the file:

Set noexec_user_stack = 1

C. restart the system to make the parameters take effect:

# Sync; init 6

More/etc/project

Prctl $ verify

Fifth, modify/etc/system

Cp/etc/system. orig

Vi/etc/system

Set noexec_user_stack = 1

Setenv DISPLAY 10.23.248.17: 0.0

Dbca

After the configuration is complete, restart the machine and run sysdef and prctl-I project user. oracle to verify that the parameters have taken effect.

How to delete an oracle instance

Rm-rf/opt/app/oracle/10.2.0/export toollogs/dbca/Instance name

Rm-rf/opt/app/oracle/admin/Instance name

Rm-rf/oradata1/Instance name

Rm-rf/var/opt/oracle (where the instance ID is stored)

,