Paste command syntax
paste file1 file2 > out1 Above command will paste file1 with line by line setting from file2 amd stores output on out1 file.
online_ts_bkup.sql
set serveroutput on execute dbms_output.enable(20000); declare cursor c1 is select distinct tablespace_name from dba_data_files order by tablespace_name; cursor c3 is select name from v$controlfile order by name; cursor c4 is select member from v$logfile order by member; staging_copy_area varchar2(100) := ‘10.201.43.51:/uocdb1/oradata/CIF’; begin for cur in c1 loop dbms_output.put_line (‘alter tablespace ‘ || cur.tablespace_name || ‘…
switchlogfile.sh
#!/bin/sh . /export/home/oracle/oraprocs/oracle_env_10g_CIF ORACLE_HOME=/oracle/app/oracle/product/10.1;export ORACLE_HOME ORACLE_SID=CIF;export ORACLE_SID $ORACLE_HOME/bin/sqlplus
arch_configUOCIOTTO.ora
# # File – arch_configUOCIOTTO.ora # # Modification History – # log_archive_format = arch%t_%r_%s.arc log_archive_dest = /IOTTOARCH
configUOCIOTTO.ora
# # File – configUOCIOTTO.ora # # Modification History – # control_files=(/uocdb1/oradata/UOCIOTTO/controlUOCIOTTO_01.ctl, /uocdb2/oradata/UOCIOTTO/controlUOCIOTTO_02.ctl, /uocdb3/oradata/UOCIOTTO/controlUOCIOTTO_03.ctl) background_dump_dest=/opt/app/oracle/admin/UOCIOTTO/bdump core_dump_dest=/opt/app/oracle/admin/UOCIOTTO/cdump user_dump_dest=/opt/app/oracle/admin/UOCIOTTO/udump db_block_size = 8192 db_name = UOCIOTTO
initUOCIOTTO.ora
# # File – initUOCIOTTO.ora # Modification History – # ifile =/opt/app/oracle/admin/UOCIOTTO/pfile/configUOCIOTTO.ora ifile =/opt/app/oracle/admin/UOCIOTTO/pfile/arch_configUOCIOTTO.ora cursor_sharing=SIMILAR open_cursors=3000 session_cached_cursors=10 sga_target=1610612736 #sga_max_size=3145728000 db_cache_advice=OFF db_file_multiblock_read_count=8 db_files=500 db_writer_processes=1 disk_asynch_io=TRUE fast_start_mttr_target=0 pga_aggregate_target=848297984 log_buffer=5120000 open_links=10 optimizer_mode=FIRST_ROWS optimizer_dynamic_sampling=0 processes=2000 undo_management=AUTO undo_tablespace=UNDOTBS1 remote_login_passwordfile=EXCLUSIVE compatible=10.1.0.2.0 db_domain=” job_queue_processes=10 #—————————————————————
For Search and replace unix command.
To remove any text becore patterrn “pvm” in all lines of file, you need to apply following vi editor command. %s/^.*pvm/pvm/g 🙂 “.” represend any single chanracter occurance.
Search and Replace vi editor command.
Changing Case To change all the lower case characters to UPPER case characters, starting from the current line, and going for 5 lines, type :s/^.*$/U&/5 To change from UPPER to lower, type :s/^.*$/L&/5 Deleting characters To delete the first 5 characters off of every line in the current file, type :%s/^…..//g
newupload.html
Photo to Upload: Your Email Address:
upload.html
Photo to Upload: Your Email Address: