Solaris Oracle kurulumu Hazırlıkları

network ip sabitleme;
/etc/hostname
/etc/hosts
/etc/nodename
----------------------
Creating Required Operating System Groups and Users

/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/groupadd oper
id nobody
id -a oracle
useradd -g oinstall -G dba,oper -m -d /export/home/oracle -s /bin/bash oracle
# id -p
uid=0(root) gid=0(root) projid=1(user.root)
# prctl -n project.max-sem-ids -i project user.root
#prctl -n project.max-shm-memory -i project 1
#prctl -n project.max-shm-memory -v 6gb -r -i project 1
#projadd -p 101 -c 'ORA DBA' -U oracle -G dba -K 'project.max-shm-memory=(privileged,6G,deny)' ORA
/etc/user_attr
oracle::::project=ORA
id -p
uid=100(oracle) gid=100(oinstall) projid=101(ORA)
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=100
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=256
--swap alanı ekleme
swap -l
zfs create -V 1G -b 4k rpool/swap2
zfs volsize=1G rpool/swap2
swap -a /dev/zvol/dsk/rpool/swap2
http://docs.sun.com/app/docs/doc/817-5093/gizfl?a=view

TDP for Oracle for Solaris RMAN backup

root>pkgadd -d TIVsmCapi.pkg
root>./TDPoraclex86.bin
set LD_LIBRARY_PATH=$ORACLE_HOME/lib
shutdown db
$ ln -s /usr/lib/amd64/libobk.so $ORACLE_HOME/lib/libobk.so
$ ln -s /opt/tivoli/tsm/client/oracle/bin64/libobk.so $ORACLE_HOME/lib/libobk.so
veya
ln -s /opt/tivoli/tsm/client/oracle/bin/libobk.so $ORACLE_HOME/lib/libobk.so
start db
/usr/bin/dsm.opt
SERVERNAME TBM
traceflag config
tracefile /export/home/oracle/log/tsm_trace.out /opt/tivoli/tsm/client/oracle/bin64
/usr/bin/dsm.sys
SErvername TBM
COMMMethod TCPip
TCPPort 1500
TCPServeraddress ipaddress
NODENAME TBM
PASSWORDACCESS prompt
COMPRESSION yes
root ile
Export DSMO_NODE=TBM
Export DSMI_CONFIG=/usr/bin/dsm.opt
Export DSMI_LOG=/opt/tivoli/tsm/client/oracle/bin
DSMI_DIR
/opt/tivoli/tsm/client/oracle/bin/tdp.opt
DSMI_ORC_CONFIG /usr/bin/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/bin64
TDPO_FS orc8_db
TDPO_NODE TBMI
TDPO_OWNER root
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64
resolv.conf
nsswitch.conf
/opt/tivoli/tsm/client/oracle/bin/tdpoconf password veya showenv
backup;
shutdown immediate;
startup mount;
--------------------------
hata verirse log dosyasına yazma izni verilmesi yeterli!
--------------------------
run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)';
backup
format 'df_%t_%s_%p'
(database);
}

run
{
allocate channel 'c1' device type sbt_tape
PARMS='SBT_LIBRARY=/opt/tivoli/tsm/client/oracle/bin/libobk.so';
}

TDP for Oracle for Windows RMAN backup

1. Register a node on the TSM server.
register node nodename password domain=domainname
parola-123
2. Stop all Oracle services.
OK
3. Install TDP for Oracle for Windows.
E diskine kuruldu
4. Configure the client options file (dsm.opt).
commmethod tcpip
tcpport 1500
TCPServeraddress ip
Nodename TBMI
passwordaccess generate
5. Generate the encrypted password using aobpswd.exe.
E:\Program Files\Tivoli\TSM\AgentOBA\tdpoconf password - 123
E:\Program Files\Tivoli\TSM\AgentOBA\tdpoconf show
6. Test a TDP for Oracle for Windows RMAN backup.
set ORACLE_HOME
rman nocatalog
connect target user/pass@
shutdown immediate
startup mount
ora12514
lissner
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(GLOBAL_DBNAME = orcl)
)

run {
allocate channel t1 type 'sbt_tape' parms
'ENV=(DSMO_DEBUG=49)';
backup (database);}
rman>list backup;
tsm>q occupancy
tsm>select * from backups where node_name='nodename'
rman>allocate channel for delete type 'sbt_tape';
rman>list backup;
rman>change backuppiece '03lh1hgg_1_1' delete; -tsm LL_NAME:03lh1hgg_1_1
rman>change backuppiece '06lh1meb_1_1' delete;
ANS4994S DP Oracle Win32 ANU0599 TDP for Oracle: (848): => () ANS1126E (RC27) The
file space cannot be deleted because this node does not have
permission to delete archived or backed up data.
tsm>update node backdel=y

7. Install the TSM backup-archive client (optional).

job listesi

EXEC dbms_job.broken(jobno, FALSE);
select job,broken from user_jobs;
select text from user_source
where type = 'PROCEDURE'
and name = procedure_name;
SELECT text FROM all_source WHERE name like '%CTRL%';

SQL> CREATE OR REPLACE PROCEDURE CTRL IS
2 begin
3 dbms_utility.exec_ddl_statement('alter database backup controlfile to trace as ''/oracle/yedek/ctrlbackup.trc'' reuse');
4 end CTRL;
5 /

Procedure created.

SQL> execute CTRL;
SQL> SET ARRAYSIZE 1
SQL> SET MAXDATA 60000
SHOW ERRORS PROCEDURE
DROP PROCEDURE

sqlplus ile bağlanma methodları

sqlplus system/pass@tnsnames_sid

sqlplus system/pass@//host:port/SID

sqlplus system/pass@'(description=(address=(protocol=tcp)(host=host_name)(port=port_))
(connect_data=(server=dedicated)(service_name=SID)))'