Oracle Database Scripts

Monday, April 21, 2025

export oracle environment shell script

What you can achieve ?

1. sqlplus / as sysdba

2. rman target /

3. expdp ...

4. impdp ...

5. srvctl

at April 21, 2025 No comments:

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Newer Posts Older Posts Home

Subscribe to: Posts (Atom)

opatchauto

# Log in as root su - root # Execute opatchauto against the unzipped patch directory /u01/app/19.0.0/ grid /OPatch/opatchauto apply /tmp/pat...

How to Perform Result-Cache-flush and UTLRP (Recompile objects)

Executing Result Cache flush and UTLRP Result Cache flush: generally result cache flush done on the database to flush the buffer to rem...
rm command importance

2. To delete all files with the exception of filename1 and filename2: $ rm -v !("filename1"|"filename2") *************...

Search This Blog

Home

About Me

Kayyum shaikh: Hi Everyone, I am Kayyum from Sakri Maharashtra. I am currently working as Software Engineer in MNC.

View my complete profile

Blog Archive

September 2026 (1)
June 2026 (1)
April 2026 (9)
September 2025 (1)
August 2025 (4)
July 2025 (2)
May 2025 (1)
April 2025 (1)
March 2025 (5)
February 2025 (1)
June 2024 (1)
May 2024 (5)
March 2024 (8)
February 2024 (12)
January 2024 (8)
December 2023 (1)
November 2023 (2)
October 2023 (5)
September 2023 (9)
August 2023 (24)
July 2023 (24)
June 2023 (6)
May 2023 (26)
July 2022 (7)

Labels

/etc/files (1)
~/.bashrc Script Importance (1)
access external files tables in oracle db (1)
ADBA VALIDATION STEPS FOR CHANGE REQUEST (1)
Add And Drop Columns On Tables In Oracle DB (1)
alter system alter database alter session In oracle database (1)
Apache tomcat httpd Server Setup On Linux (1)
ARCHIVELOG COMPLETE SQL QUERIES FOR MONITORING (1)
archivelogs location in oracle (1)
ASM DISKGROUP IN ORACLE SQL QUERIES (1)
automation of listener database and rman In oracle database (1)
best SQL practice In Oracle Database (1)
BLOCKING SESSIONS AND HOW TO KILL THEM (1)
Cardinality & selectivity (1)
check Oracle Database Slow SQL Response (1)
commit in oracle db (1)
COMPLETE TABLESPACE MONITORING AND ADDING (1)
CONNECT VM TO WINDOWS 11 (1)
create tablespace in oracle database (1)
DATA PUMP SQL QUERIES FOR EXPORT AND IMPORT (1)
database link in oracle db (1)
DATAFILES (1)
DBMS GATHER STATS SQL MONITORING QUERIES AND TABLESPACE USED BY INDIVIDUAL USER CURRENT HOLDING SPACE ON TABLESPACE SQL QUERIES (1)
DBMS PACKAGES IN ORACLE (1)
DDL AND DML QUERIES (1)
DDL DML TCL and LOTS MORE (1)
Different Ways To Connect To Database Using Sqlplus (1)
Directories In Oracle (1)
ENABLE ARCHIVE LOG MODE IN ORACLE DATABASE (1)
ENABLE FLASHBACK MODE IN ORACLE DATABASE (1)
execute multiple commands remotely using SSH (1)
EXPDP & IMPDP Automation Shell Script ? (1)
EXPDP AND IMPDP DETAILED EXAMPLES ORACLE DB (1)
FAST RECOVERY AREA USAGE SQL QUERIES FOR MONITORING (1)
File Automation Script (1)
File System Alerts Short Cuts Commands (1)
FLASHBACK_TRANSACTION_QUERY displays information about all flashback transaction queries in the database. (1)
Fresher Experience as a Oracle Apps DBA (1)
Gather statistics for tables indexes and schemas (1)
GOLDEN GATE 19C installation on Linux (1)
grant revoke delete truncate update drop statements in oracle db (1)
grep commands patterns and metacharacter classes In Linux escape "\" character importance (1)
GRID & RAC & LINUX TRICKS & TIPS & COMMANDS (1)
GRID RAC STANDALONE GRID OR ORACLE DATABASE SINGLE INSTANCE INSTALLATION (1)
How to find same columns in multiple tables/views (1)
HOW TO MONITOR AND FIND ACTIVE SESSION AND BLOCKING SESSION ON ORACLE DB (1)
How to send mail on linux (1)
How to use commands In Linux Using /usr/sbin (1)
if test options and its usage in linux (1)
Indexes And Constraints On Tables In Oracle DB (1)
INTERACTIVE HTML PAGE FOR DBA WORK (1)
ipaddress complete details (1)
Linux commands (1)
Listener error :- listener know no service (1)
LISTENER IN ORACLE DB (1)
LOCKED OBJECTS IN ORACLE DB (1)
lsof linux command (1)
Maths On Linux Terminal (1)
NLS (National Language Support) (1)
OEM (1)
opatch opatchauto and autoupgrade.jar In Oracle Database (1)
oracle environment variables (1)
Oracle Errors (1)
ORACLE PATCH RELATED SQL QUERIES (1)
Oracle Standby DB Parameters (1)
orapwd (1)
Patching Oracle Database (1)
pluggable databases (PDBS) In ORACLE (1)
procedure (1)
RAC DB (1)
RAC SRVCTL AND CRSCTL COMMAND (1)
Rebuild/Move Tables And Rebuild Indexes In Oracle DB (1)
relations between process (1)
RESETLOGS AND NORESETLOGS IN ORACLE DATABASE (1)
Resize Mount Point In Linux (1)
Resize Redo Logs In Oracle DB (1)
RESIZING DATAFILES (1)
Resolve In-Doubt-Transaction (IDT) in Oracle Database (1)
Result Cache And Recompile Objects (UTLRP.SQL) (1)
rm -rf !(folder) in linux (1)
RMAN BACKUP (1)
RMAN JOB STATUS RELATED SQL QUERIES (1)
rollback (1)
SAMPLE SHELL SCRIPTS FOR FILE SYSTEM ALERT ON ORACLE DB (1)
savepoint (1)
Scheduled Jobs In oracle database (1)
SCP COMMAND (1)
Script To Export Oracle Env Variables Automation (1)
SED COMMAND ON LINUX (1)
sessions and transactions (1)
SHOPT COMMAND MAGIC (1)
SQL QUERIES (1)
SQL QUERY REPORT IN MAIL (1)
SQL SESSIONS MONITORING QUERIES (1)
SQLPLUS COMMAND LINE some set commands (1)
sqltune (1)
ssh-keygen (1)
START AND STOP ORACLE DB ON SINGLE INSTANCE STANDALONE AND RAC DB (1)
start and stop standby database oracle database (1)
STARTING STOPPING SEQUENCE OF GOLDEN GATE IN ORACLE DB (1)
startup modes in oracle database (1)
synonyms and views (1)
TABLE CONSTRAINTS STATUS IN ORACLE DATABASE (1)
TABLESPACE (1)
TABLESPACE DATAFILES SIZES IN KB MB GB TB PB EB ZB YB (1)
TABLESPACE USAGE AND ADD-RESIZE DATAFILE IN ORACLE DB (1)
Trace Files In Oracle DB (1)
Unlock stats on tables indexes partition materialized_views and schemas In Oracle DB (1)
unzip zip and tar files Linux (1)
User group commands details (1)
USER MANAGEMENT IN ORACLE DB (1)
USER PROFILE MANIPULATION ORACLE (1)
VIEW BACKUP LOCATION FROM LINUX TERMINAL OR ORACLE DB USING COMMANDS (1)
vmware workstation creation of shared disks for ORACLE 19C GRID INFRASTRUCTURE (1)
Why we perform "alter system switch logfile/alter system archive log current (RAC) and alter system checkpoint " (1)

Report Abuse

Search This Blog

Translate

Followers

Simple theme. Theme images by enot-poloskun. Powered by Blogger.