-bash-3.2$ su -
Password:
Oracle Corporation SunOS 5.10 Generic Patch January 2005
#
#
#
# RAM_MB=`prtconf |grep Memory|awk '{print $3 }'`
# echo $RAM_MB
2048
# SHMMAX=`expr $RAM_MB \* 1024 \* 1024 \* 70 / 100`
# echo $SHMMAX
1503238553
# projadd -U oracle user.oracle
# projmod -s -K "project.max-sem-ids=(priv,128,deny)" user.oracle
# projmod -s -K "project.max-shm-ids=(priv,128,deny)" user.oracle
# projmod -s -K "process.max-sem-nsems=(priv,512,deny)" user.oracle
# projmod -s -K "project.max-shm-memory=(priv,$SHMMAX,deny)" user.oracle
# projmod -s -K "process.max-file-descriptor=(priv,65536,deny)" user.oracle
# echo "set max_nprocs = 30000" >> /etc/system
# echo "set maxuprc = 16384" >> /etc/system
# su - oracle
Oracle Corporation SunOS 5.10 Generic Patch January 2005
-bash-3.2$ id -p
uid=100(oracle) gid=100(oinstall) projid=100(user.oracle)
-bash-3.2$ more /etc/project
system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
user.oracle:100::oracle::process.max-file-descriptor=(priv,65536,deny);process.max-sem-nsems=(priv,512,deny);project.max-sem-ids=(priv,128,deny);project.max-shm-ids=(priv,128,deny
);project.max-shm-memory=(priv,1503238553,deny)
Password:
Oracle Corporation SunOS 5.10 Generic Patch January 2005
#
#
#
# RAM_MB=`prtconf |grep Memory|awk '{print $3 }'`
# echo $RAM_MB
2048
# SHMMAX=`expr $RAM_MB \* 1024 \* 1024 \* 70 / 100`
# echo $SHMMAX
1503238553
# projadd -U oracle user.oracle
# projmod -s -K "project.max-sem-ids=(priv,128,deny)" user.oracle
# projmod -s -K "project.max-shm-ids=(priv,128,deny)" user.oracle
# projmod -s -K "process.max-sem-nsems=(priv,512,deny)" user.oracle
# projmod -s -K "project.max-shm-memory=(priv,$SHMMAX,deny)" user.oracle
# projmod -s -K "process.max-file-descriptor=(priv,65536,deny)" user.oracle
# echo "set max_nprocs = 30000" >> /etc/system
# echo "set maxuprc = 16384" >> /etc/system
# su - oracle
Oracle Corporation SunOS 5.10 Generic Patch January 2005
-bash-3.2$ id -p
uid=100(oracle) gid=100(oinstall) projid=100(user.oracle)
-bash-3.2$ more /etc/project
system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
user.oracle:100::oracle::process.max-file-descriptor=(priv,65536,deny);process.max-sem-nsems=(priv,512,deny);project.max-sem-ids=(priv,128,deny);project.max-shm-ids=(priv,128,deny
);project.max-shm-memory=(priv,1503238553,deny)
-bash-3.2$ vi .profile
".profile" 15 lines, 458 characters
# This is the default standard profile provided to a user.
# They are expected to edit it to meet their own needs.
MAIL=/usr/mail/${LOGNAME:?}
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/export/home/oracle/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=dev; export ORACLE_SID
DISPLAY=localhost:0.0; export DISPLAY
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/export/home/oracle/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=dev; export ORACLE_SID
DISPLAY=localhost:0.0; export DISPLAY
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
PATH=$ORACLE_HOME/bin:/usr/bin:/usr/ucb:/etc:.
export PATH
~
~
~
~
~
~
~
~
~
".profile" 15 lines, 540 characters
-bash-3.2$ pwd
/export/home/oracle/u02/oradata
-bash-3.2$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname DEV -sid DEV -SystemPassword manager0 -SysPassword manager0 -emConfiguration NONE -datafileDestination /export/home/oracle/u02/oradata -storageType FS -characterSet AL32UTF8 -redoLogFileSize 10 -automaticMemoryManagement False -memoryPercentage 30
Copying database files
1% complete
3% complete
37% complete
Creating and starting Oracle instance
40% complete
export PATH
~
~
~
~
~
~
~
~
~
".profile" 15 lines, 540 characters
-bash-3.2$ pwd
/export/home/oracle/u02/oradata
-bash-3.2$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname DEV -sid DEV -SystemPassword manager0 -SysPassword manager0 -emConfiguration NONE -datafileDestination /export/home/oracle/u02/oradata -storageType FS -characterSet AL32UTF8 -redoLogFileSize 10 -automaticMemoryManagement False -memoryPercentage 30
Copying database files
1% complete
3% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/export/home/oracle/u01/app/oracle/cfgtoollogs/dbca/DEV/DEV0.log" for further details.
'Oracle > admin' 카테고리의 다른 글
ORACLE RAC ON/RAC OFF (0) | 2016.08.30 |
---|---|
Oracle10g crs 관련 커맨드 (0) | 2016.08.03 |
Oracle 권고 parameters (0) | 2016.07.18 |
Rule Base Optimizer 우선수위 (0) | 2016.07.18 |
MCCS 오라클 설치 (0) | 2016.07.15 |