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

Oracle conrole file yaratma

iki şekilde control file yaratılır.
trace ile yaratma üzerine duracağız;
alter database backup controlfile to trace; dememiz yeterli.
oluşturduğumuz control file scriptini oluşturabilememiz için datafileların mevcut olması gerekir. özellikle sistem datafile nin header kısmına bakacaktır...

plan table

SQL> explain plan for select count(*) from tablo;
SQL> @?/rdbms/admin/utlxpls.sql

On version up to and including 9i, use the utlxplan.sql script to createthe plan table as instructed below.
SQL> @?/rdbms/admin/utlxplan
On 10g and above there is a new script - catplan.sql - to create the plan
table that creates a public plan table as a global temporary table
accessible from any schema.
SQL> @?/rdbms/admin/catplan
Note that the plan table format can change between versions so ensure
that it is created using the utlxplan script from the current version.

sapnotes:#1303908

instance bilgileri sql komutları

SELECT NAME, description FROM v$bgprocess ORDER BY NAME, description

select * from v$version
where banner like 'Oracle%';


select * from v$database

select * from v$license;

select * from v$version;

rman tsm backup

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/sid/102_64/dbs/snapcf_BPD.f'; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oracle/sid/yedek/ora_df_%t_%s_%p';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/sid/yedek/%F';
CONFIGURE BACKUP OPTIMIZATION ON;



CONFIGURE DEFAULT DEVICE TYPE TO TSM;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'TSM' TO 'AUTOBACKUP_%F';
CONFIGURE DEVICE TYPE TSM PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE TSM TO 1;
CONFIGURE CHANNEL DEVICE TYPE 'TSM' PARMS 'ENV=(tdpo_optfile=/usr/tivoli/tsm/tdp_r3/ora64/dsm.sys)' FORMAT 'BACKUP_%D%M%Y_%d_%I_%U';
CONFIGURE CHANNEL DEVICE TYPE 'BOYDAKTSM' PARMS 'ENV=(tdpo_optfile=TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' FORMAT 'BACKUP_%D%M%Y_%d_%I_%U';


XINT_PROFILE=//init.utl,PROLE_PORT=portnumber

CONFIGURE CHANNEL DEVICE TYPE 'TSM' MAXPIECESIZE 100 M;
CONFIGURE CHANNEL DEVICE TYPE 'TSM' clear;

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(tdpo_optfile=/tsm/conf/client/tdpo.opt.tst)' FORMAT 'BACKUP_%D%M%Y_%d_%I_%U';



SHOW CHANNEL FOR DEVICE TYPE TSM;

http://forums.oracle.com/forums/thread.jspa?threadID=697031

v$backup_device


CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NSR_SERVER=tape_svr, NSR_CLIENT=oracleclnt, NSR_GROUP=oracle_tapes)' FORMAT "BACKUP_%U";

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/api/bin/dsm.sys.smp)';

solaris oracle kurulumu

phgadd -d . SUNWbtool
http://ivan.kartik.sk/oracle/install_ora10gR2_solaris.html
http://blogs.sun.com/mandalika/entry/oracle_on_solaris_10_fixing
useradd -R printadm -m -d /export/deneme -s /usr/bin/bash deneme
http://www.kobhi.com/solaris/user_management/solaris_user_modify.htm
http://belgeler.org/lis/archive-tlkg-lis-7.2.html
http://www.ugurileri.com/2009/05/solaris-10da-network2u-restart-etmek.html
http://forums.oracle.com/forums/thread.jspa?threadID=382389
http://www.lazydba.com/oracle/0__53774.html

ifconfig -a pcn0

netstat -rn
route add default 10.200.0.111
etc/defaultrouter 10.200.0.111

/etc/nsswitch.conf host files dns
/etc/resolv.conf - nameserver -ip-

oracle enterprise manager

emca -config dbcontrol db -repos create -- manager console oluşturulur

emca -deconfig dbcontrol db -repos drop -- console silinir.


1) Set the environment variable ORACLE_SID to SID
2) /oracle/SID/102_64/bin/emctl stop dbconsole
3) /oracle/SID/102_64/bin/emctl config emkey -repos -sysman_pwd pass < Password for SYSMAN user >
4) /oracle/SID/102_64/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user >
5) /oracle/SID/102_64/bin/emctl start dbconsole