Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Changing default shell Linux/Unix
  • Day to day MYSQL DBA operations (Compared with Oracle DBA) MYSQL
  • For Search and replace unix command. Linux/Unix
  • create a folder in multiple places Linux/Unix
  • Implementing Listener Security Oracle
  • Find Command Linux/Unix
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • Paste command syntax Linux/Unix
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • Oracle 11g Training on 29JAN1010 Oracle
  • Set Role explaination. Oracle
  • Finding Oracle Patches with opatch Oracle
  • move_arch_files.ksh Linux/Unix
  • fkwoindex.sql /* Find FK without Index */ Oracle
  • switchover for primary database Oracle

Author: Admin

arch_configUOCIOTTO.ora

Posted on 29-Jul-2005 By Admin No Comments on arch_configUOCIOTTO.ora

# # File – arch_configUOCIOTTO.ora # # Modification History – # log_archive_format = arch%t_%r_%s.arc log_archive_dest = /IOTTOARCH

Oracle, SQL scripts

configUOCIOTTO.ora

Posted on 29-Jul-2005 By Admin No Comments on 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

Oracle, SQL scripts

initUOCIOTTO.ora

Posted on 29-Jul-2005 By Admin No Comments on 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 #—————————————————————

Oracle, SQL scripts

For Search and replace unix command.

Posted on 29-Jul-2005 By Admin No Comments on 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.

Linux/Unix, shell

Search and Replace vi editor command.

Posted on 29-Jul-2005 By Admin No Comments on 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

Linux/Unix, shell

newupload.html

Posted on 29-Jul-2005 By Admin No Comments on newupload.html

Photo to Upload: Your Email Address:

PHP/MYSQL/Wordpress

upload.html

Posted on 29-Jul-2005 By Admin No Comments on upload.html

Photo to Upload: Your Email Address:

PHP/MYSQL/Wordpress

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

PHP/MYSQL/Wordpress

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

Linux/Unix, shell

Jai Shree Ram

Posted on 29-Jul-2005 By Admin No Comments on Jai Shree Ram

God Bless All………..

Linux/Unix, shell

Posts pagination

Previous 1 … 56 57 58 Next

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (350)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sql23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • 556976.1 Oracle Clusterware: Components installed Oracle
  • secure crt settings Linux/Unix
  • Order by with ROWNUM Oracle
  • SQL Server: How to see current transactions or requests SQL Server
  • oracle_env_10g_CADEV Linux/Unix
  • Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
  • Flowers Resize datafiles Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme