30 Mart 2010 Salı

oracle ornek komutlar- unix için kurulum

select * from dba_registry_history
---------------------------------
select * from dba_audit_trail a
where
a.username='SYS' and
a.logoff_time> sysdate - 100
----------------------------
groupadd -g 102 dba
useradd -d /export/home/oruser -m -s /bin/bash -g dba -u 101 orauser
passwd orauser
usermod -u 101 orauser

ls -alF /export/home/orauser
chown -R orafmi /export/home/orauser
ORACLE_HOME ve ORACLE_SID set
mkdir oracle
ls -alF /oracle
chown -R orauser /oracle
vi /etc/system
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=100
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=256

http://download.oracle.com/docs/cd/B19306_01/install.102/b15697/pre_install.htm#BABIBGFA

id -p
prctl -n project.max-shm-memory -i project 101

-prctl -n project.max-shm-memory -r -v 24gb -i project 100

projadd -p 101 -c 'ORA_DBA' -U orauser -G dba -K 'project.max-shm-memory=(privileged,6G,deny)' ORA

etc/user_attr
orasti::::project:ORA

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:454420165038
-------------------------------------
http://www.oracle-base.com/articles/10g/OracleDB10gR2InstallationOnSolaris10.php
usermod -K project=OABS oracle
user_attr