Adithya's Oracle DBA Blog

Unix Profile script (.profile)



Unix Profile script (.profile)


stty erase ^?

EDITOR=vi ;export EDITOR
ORACLE_BASE=/oracle ;export ORACLE_BASE
ORACLE_HOME=/oracle/9.2.0 ;export ORACLE_HOME
TNS_ADMIN=$ORACLE_HOME/network/admin ;export TNS_ADMIN
ORACLE_SID=FXPGSM1 ;export ORACLE_SID
SQLPATH=/home/oracle/OSS ;export SQLPATH
LD_LIBRARY_PATH=/oracle/9.2.0/lib:/usr/lib:/home/etuadm/lib; export LD_LIBRARY_PATH
PATH=$PATH:$ORACLE_HOME/bin:/usr/sbin:/home/oracle ;export PATH

alias bdump='cd /oracle/admin'
alias rm='/usr/bin/rm -i'

PS1="
\${PWD}
`whoami`@`hostname`_\${ORACLE_SID} $ ";        export PS1
PATH=$PATH:/home/oracle;export PATH

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-9445596685438603"
     crossorigin="anonymous"></script>
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Home
Subscribe to: Posts (Atom)

Pages

  • Home
  • Oracle DB Session Killing scripts
  • Oracle DB Histograms.
  • Creating guarantee restore point for oracle databs...
  • FLUSH_DATABASE_MONITORING_INFO Procedure
  • Oracle DB Reduce Datafile size to minimum space
  • Compile Oracle DB schema
  • Oracle grid / cluster status script
  • Connect Oracle Database SQLPLUS without TNS
  • SQL Profile
  • Oracle Database Column level data encryption using dbms_crypto
  • Standby or dataguard sync checking
  • How do send e-mails through Oracle DBMS_SCHEDULER
  • Oracle Database Java or Jvm installation
  • Query to Find Oracle DB CHARACTERSET
  • Shell Script: RMAN_BACKUP.sh
  • ASM Commands
  • SQL History Plan change
  • SQL Baseline Creation
  • Unix soft link creation
  • Sequence increment script
  • Renaming Oracle Database User
  • How to Trace Oracle session and Hang Analysis
  • SQL Plan Management and SQL plan baselines
  • Important Oracle Documents Ids
  • Finding Oracle Database SQL Plan
  • Simulating ORA-errors
  • Tuning Oracle SQL query using SQL Tuning Advisor using command line
  • Oracle SQL Auto tuning advisor task
  • How to see source code of a oracle object (get met...
  • Changing Owner of Oracle Database Software
  • Query to find fragmentation in oracle tables
  • How to change location of oraInventory
  • Setting SQL prompt in Oracle
  • Migration form 32 bit to 64 bit
  • importance of executing orainstRoot.sh and root.sh...
  • Managing Patches
  • RMAN-06004: ORACLE error from recovery catalog dat...
  • Storage Migrating from File system to ASM using ba...
  • How to recover and open the database if the archive log required for recovery is missing
  • Find out the subshell of a unix process
  • How to "kill Semaphore of Oracle Instance" / "Remove Shared memory of Oracle Instnace"
  • Tuning ‘log file sync’ Event Waits
  • BEA-337 [WebLogicServer] errors detected in EM12c
  • Rolling forward a standby database using RMAN incremental backup
  • Resolving Data file missing issues in DR using RMAN Backup
  • Getting Encrypted Password in Oracle 11g
  • Getting DDL Statements from datapump dump file
  • Avail script (avail)
  • Goto script (goto)
  • Unix Profile script (.profile)
  • Migrating from File system to ASM/other new filesystem using rman backup as copy.
  • Shell Script: Trace FIle Management
  • Installing Oracle Enterprise Manager Grid Control 11g
  • Oracle DB Reaming undo / roll back after killing ...
  • Oracle Data Guard - Snapshot Standby
  • 12cR1 Upgrade : Pre-Upgrade reports the message 'Inactive DBIDs found in AWR'
  • How to Copy the SQL base plan from one database to another
  • Copy SQL Plan form one Database another Database (Using sqlt)
  • Oracle Database top sql report - last 1 Day
  • Customization of Enterprise Manager Login Page 13c...
  • Oracle Database Archivelog Generation
  • Blocking Sessions Queries
  • Table modifications from last analyzed
  • Step By Step Switchover Testing
  • ORA-12899: value too large for column
  • sqlplus: error while loading shared libraries libclntsh.so.11.1 cannot restore segment prot after reloc: Permission denied
  • Azure Videos
  • Alert Log Monitoring Script
  • How to Configure TDE in Oracle 19c
  • SQL Server Documents

Search This Blog

Oracle DBA

Adithya
Herndon, Virginia, United States
DBA Consultant
View my complete profile

Blog Archive

  • ▼  2024 (1)
    • ▼  August (1)
      • DG Broker Configuration
Watermark theme. Powered by Blogger.