Oracle

  1. Home
  2. Oracle
    3. (
  3. Page 7
    4. )
by Team Ajara

script for oracle ASM header backup

script for oracle ASM header backup script name: disk_asmheader_backup.sh #!/bin/sh PATH=$PATH:/usr/local/bin;export PATHTIMESTAMP=`date +%Y%m%d` host=`hostname` export ORACLE_SID=`ps -ef | grep pmon | grep +ASM | grep -v “grep pmon” | cut
by Team Ajara

Undo management in Oracle database

Undo management in Oracle database   Suggestions on Undo management 1. Check for the ACTIVE,UNEXPIRED and EXPIRED blocks(segments). Don’t add space to the UNDO when u receive the alert immediately.
by Team Ajara

srvctl config on Oracle database appliance

What is different with “srvctl config” command on ODA machines than the normal servers?   srvctl config on ODA machines   # srvctl config database -d TEST Database unique name:
by Team Ajara

Oracle DB refresh using transportable tablespaces

Using Oracle Transportable Tablespaces to refresh Schemas/Tablespaces in Oracle Databases. Overview of  this activity: System tablespace size increased more than 60GB. Not able to shrink the size of the system
by Team Ajara

How to get the row count for all tables in a schema?

  How to get the row count in each table of a schema?   Query SQL> select table_name, to_number( extractvalue( xmltype( dbms_xmlgen.getxml(‘select count(*) c from ‘||table_name)) ,’/ROWSET/ROW/C’)) count from all_tables where
by Team Ajara

Unable to connect SQLState=08004 [Oracle][ODBC][Ora]

Connecting an Oracle Database Using an ODBC Connection Connectivity issue Overview during ODBC setup Apps team installed Oracle instant client 11.1 (32-bit) on apps server. while testing the connection (while
by Team Ajara

How to register database using odacli on ODA ?

Registering oracle database using odacli register-database on ODA machine. Prerequisites for registering database in ODA. Instance name ,database name should be in uppercase. wallet_root = ‘/opt/oracle/des/commonstore/wallets/tde/ORCLDW/tde sqlnet.ora should contain entries
by Team Ajara

ODA System backup and restore using ODABR command

ODABR a System Backup and Restore Utility.   ODA system backup contains below things. Root file system Boot partition (/boot) opt file system: OAK/DCS,TFA, OWG, ASR (/opt) u01 file system: