Sadan's Oracle dba Blog

RAC installation on OEL 7.9  Dissable the firewall:   systemctl stop firewalld systemctl disable firewalld systemctl status firewalld cat /etc/selinux/config sed -i --follow-symlinks 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config cat /etc/selinux/config Add the below entries into the /etc/hosts file  vi /etc/hosts Public Ip 192.168.56.120  19crac01.oracle.com  19crac01 192.168.56.121  19crac02.oracle.com  19crac02 10.10.10.101   19crac0-priv.oracle.com 19crac01-priv 10.10.10.102   19crac02-priv.oracle.com 19crac02-priv 192.168.56.123  19crac01-vip.oracle.com 19crac01-vip 192.168.56.124  19crac02-vip.oracle.com 19crac02-vip Add the scan ip entries into the dns vi /etc/racdns 192.168.56.127  prod-scan.oracle.com rac-scan 192.168.56.128  prod-scan.oracle.com rac-scan 192.168.56.129  prod-scan.oracle.com rac-scan vi /etc/dnsmasq.conf addn-hosts= /etc/racdns :wq vi /etc/resolv.conf nameserver 127.0....

  1 ST STEP ============ Window server build ======= INstall the VM and assign the storage to local drive . 2 gb RAM 25 GB DISK SPACE. One is Domain server 80 GB OF STORAGE AND IP 10.10.10.1 TCS.COM domain. One is db server for PROD 25 GB OF STORAGE AND IP 10.10.10.2 One is db server for TEST 25 GB OF STORAGE AND IP 10.10.10.3 One is db server for DEv 25 GB OF STORAGE AND IP 10.10.10.4 2 ND STEP ======= Creating Domain name server as Active Directory service =========== click on server manager ->add roles and features->next->next->active directory domain servic->add features ->next->next->next->Install.. Click on Flag symbol->promote this servers as a Domain ->Add new forest->Root domain name->TCS.COM->next->password ->confirm password ->next->next->next>next->Install===Domain server Domain server completed . 3 RD STEP ========Network configuration ...

  set lines 200 pages 200; col END_TIME for a20; col ELAPSED_TIME for a25; SELECT T.SESSION_KEY, T.INPUT_TYPE, T.STATUS, T.SUM_BACKUP_PIECES_IN_GB, T.START_TIME, T.END_TIME, T.SECONDS ELAPSED_TIME FROM ( SELECT SESSION_KEY, INPUT_TYPE, STATUS, OUTPUT_BYTES/1024/1024/1024 SUM_BACKUP_PIECES_IN_GB, TO_CHAR (START_TIME, 'dd/mm/yyyy hh24:mi') START_TIME, TO_CHAR (END_TIME, 'dd/mm/yyyy hh24:mi') END_TIME, TIME_TAKEN_DISPLAY SECONDS FROM V$RMAN_BACKUP_JOB_DETAILS WHERE INPUT_TYPE='ARCHIVELOG' ORDER BY SESSION_KEY DESC) T WHERE ROWNUM <= 1; set lines 200 pages 200; col END_TIME for a20; col ELAPSED_TIME for a25; SELECT T.SESSION_KEY, T.INPUT_TYPE, T.STATUS, T.SUM_BACKUP_PIECES_IN_GB, T.START_TIME, T.END_TIME, T.SECONDS ELAPSED_TIME ...

ssh in001i97@10.217.45.86 welcomejune@2022 ssh ibm_admin@172.22.8.53 ibm_admin ssh 10.242.98.25 ibm_admin MX10OR90BSAB/ 10.242.98.25 SID: BTPROPQ1 Port: 1529 ===================Source Side =================== @db_status.sql select dbid from v$database; col file_name format a90 select file_name from dba_data_files order by file_name; col member for a90 select member from v$logfile; show parameter controlfile show parameter spfile; SQL> create pfile='/home/oracle/initCALCOPQ1.ora' from spfile; col "Database Size" format a20 col "Free space" format a20 select round(sum(used.bytes) / 1024 / 1024 /1024) || ' GB' "Database Size" , round(free.p / 1024 / 1024 /1024) || ' GB' "Free space" from (select bytes from v$datafile union all select bytes from v$tempfile union all select bytes from v$log) used , (select sum(bytes) as p from dba_free_space) free group by free.p / connect ...

MANUAL DATABASE CREATION – 11g version Lets say we will create a database named ACTIONAL 1. Create the PATHS for database files to be stored. Control Files Archive Location Database Files Redolog Files Location 2.Now create the init.ora file( in $ORACLE_HOME/dbs location) *.bitmap_merge_area_size=10485760 *.compatible='11.2.0.0.0' *.control_files='/u31_Actional/actional/oradata/control01.ctl','/u31_Actional/actional/oradata/control02.ctl','/u31_Actional/actional/oradata/control03.ctl' *.control_management_pack_access='NONE' *.cursor_sharing='SIMILAR' *.db_block_size=8192 *.db_cache_advice='ON' *.db_domain='' *.db_file_multiblock_read_count=128 spfile.db_files=500 *.db_files=500 *.db_name='actional' =======> Database Name *.diagnostic_dest='/u01' *.dml_locks=5000 *.fast_start_mttr_target=0 *.job_queue_processes=4 *.log_archive_dest_1='LOCATION=/u31_Actional/archive' #### Archivelog ...

. bdrsat_test.env IN node2 : ssh oracle@ -bash-4.1$ . oraenv ORACLE_SID = [BDRSAT1] ? BDRSAT2 ORACLE_HOME = [/home/oracle] ? /oracle/dbbase/product/11.2.0.4/dbhome SELECT INST_ID,SID,SERIAL#,OSUSER,username, machine, status,to_char(LOGON_TIME,'DD-MON-YYYY HH24:MI:SS'),PROGRAM FROM GV$SESSION where username='DS_EMIWEBRS' and osuser='tj2ee02' order by 7; SELECT INST_ID,SID,SERIAL#,OSUSER,username, machine, status,to_char(LOGON_TIME,'DD-MON-YYYY HH24:MI:SS'),PROGRAM FROM GV$SESSION where username='DS_EMIWEBRS'; SELECT OWNER, TRIGGER_NAME, STATUS FROM DBA_TRIGGERS WHERE TRIGGER_NAME LIKE 'SET_TRACE_ON_LOGON%'; SQL> SELECT OWNER, TRIGGER_NAME, STATUS FROM DBA_TRIGGERS WHERE TRIGGER_NAME LIKE 'SET_TRACE_ON_LOGON%'; OWNER TRIGGER_NAME STATUS ------------------------------ ------------------------------ -------- SYS SET_TRACE_ON_LOGON_JDELCAST DISABLED SYS SET_TRACE_ON_LOGON_JDURAN DIS...

  Export schema DATCREDITOCO select owner,segment_name,sum(bytes/1024/1024) from dba_segments where segment_name='DATCREDITOCO'; select owner,segment_name,sum(bytes/1024/1024) from dba_segments where owner='DATCREDITOCO'; expdp directory=EXPIMP dumpfile=SR3367495_DATCREDITOCO.dmp logfile=SR3367495_DATCREDITOCO.log schemas=DATCREDITOCO expdp schemas=CONVERSION directory=EXP_HDD dumpfile=CONVERSION_data.dmp logfile=CONVERSION.log content=METADATA_ONLY impdp remap_schema=CONVERSION:QA_CONVERSION directory=EXP_HDD dumpfile=CONVERSION_data.dmp logfile=QA_CONVERSION.log content=METADATA_ONLY select owner,count(*) from dba_objects where owner in ('CONVERSION','QA_CONVERSION'); expdp schemas=CONVERSION directory=EXP_HDD logfile=CONVERSION.log ESTIMATE_ONLY=y content=METADATA_ONLY create user QA_CONVERSION identified by welcome default tablespace DATA TEMPORARY TABLESPACE "TEMP2"; grant create session,connect to QA_CONVERSION; DEFAU...