Tweet
Upload failed with ret=-10 / Agent is Running but Not Ready
Background : I have installed OMS/OMR and OMA successfully. In theory I should see OMA client successfully configured at OMS grid console but
Install and Admin OMS (Oracle Management Service) Grid Console
Download OMS software from here
Installing & Configuring Oracle grid Agent (UNIX Standalone/Clustered Install)
- Download Software and upload zip at server. You will need 10.2.0.1 else 10.2.0.2 base release before you upgrade to 10.2.03/10.2.0.4
- You will also need an X windows environment like cygwin installed on your desktop for remote install. You can also carry a silent install with no X windows interface.
- Let’s setup cygwin on client window machine
Upload failed with ret=-10 / Agent is Running but Not Ready : Clustered node install
Problem Statement I am configuring Oracle Agent for a grid console. My system is HP TRUE64 and /opt/oracle/Agent10g is a clustered file system like QFS/GFS/OCFS. A clustered file system is shared between 2 nodes, in my case $ORACLE_HOME is shared between cluster1 and cluster2.
Replication views taking longer to return results/ Truncate views
We had to relocate one of the replication node to another location. During move, other master nodes had a huge queue build up i.e more than 1.2 million waiting transactions recorded at deftran on 5 other nodes. When the server was finally back, transaction queues were replicated to original server but we hit performance problem.
Network Statistics (netstat)
netstat displays the contents of various network-related data structures in depending on the options selected.
Clone Agent Configuration
-
If you have a working EM grid console configuration, you can TAR a client configuration and clone it at other nodes.
Metric Collection Error
I installed 10g grid console agent using notes
Virtual Memory Statistics ( vmstat )
vmstat - vmstat reports virtual memory statistics of process, virtual memory, disk, trap, and CPU activity.
Oracle Installer Failed : TMP space problem
./runInstaller
Starting Oracle Universal Installer…
Checking installer requirements…
Checking operating system version: must be B.11.11 or B.11.23. Actual B.11.11
Passed
Input Output statistics ( iostat )
iostat reports terminal and disk I/O activity and CPU utilization. The first line of output is for the time period since boot & each subsequent line is for the prior interval . Kernel maintains a number of counters to keep track of the values.
Useful Oracle DBA Linux Commands
Find files older than 5 days: find . -mtime +5 -print | xargs ls -l | more
Remove files older than 5 days : find . -mtime +5 -print | xargs rm
ADD/REMOVE/REPLACE/MOVE Oracle Cluster Registry (OCR) and Voting Disk
Note: You must be logged in as the root user, because root owns the OCR files. Make sure there is a recent copy of the OCR file before making any changes: ocrconfig showbackup
RAC Build on Solaris: Fifth Phase
Step by Step instructions on how to remove temp nodes from RAC cluster. Step by step instruction on how to verify removal of temp nodes.
RAC Build on Solaris : Fourth Phase
Step by Step instructions on how to fail RAC databases over from temp nodes to prod nodes. Includes step by step instructions on how to verify the failover from temp nodes to prod nodes. Step by Step instructions on how to test RAC database connectivity after failover.
RAC Build on Solaris : Third Phase
Oracle 10g R2 RAC Installation for PROD Nodes:
Step by Step instructions for installing Oracle 10g R2 RAC installation. The procedures will provide STEP By STEP guide you for installing two nodes (prodracsrv1and prodracsrv2) and adding to the existing RAC cluster(Configuring Failover).
RAC Build on Solaris : Second Phase
Oracle 10g R2 RAC Installation for Temp Nodes:
Step by Step instructions for installing Oracle 10g R2 RAC installation. The procedures will provide STEP by STEP guide you for installing two nodes (tempracsrv3 and tempracsrv4). Installation on this phase includes documentation on how to verify the installation and configuration is installed correctly. Step by Step instructions on creating RAC database, importing schemas from oracle 9i database into new databases, and testing database and node connectivity for this phase of the step by step instructions.
RAC Build on Solaris : First Phase
Objective : The two Solaris 10 prod nodes have Oracle 9i databases and I want to export database to Oracle 10g X 4 node Solaris 10 RAC.
RAC Build on Solaris, Step-By-Step
The scope of this STEP By STEP documentation will include the following workflow:
*First Phase*
The two prod nodes have Oracle 9i databases and we want to export the database to oracle 10g RAC. Step by Step export instructions for creating a backup copy of databases. Step By Step instruction on how to install new OS version of Sun Solaris 10 to replace Sun Solaris 9.
Compare 9i Statspack & 10g AWR Views
| Statspack | AWR | |||
| STATS$DATABASE_INSTANCE | Tables store historical data or snapshots | |||
| STATS$IDLE_EVENT | ||||
| STATS$LEVEL_DESCRIPTION | ||||
| STATS$ROLLSTAT | ||||
| STATS$SESSION_EVENT | ||||
| STATS$SNAPSHOT | ||||
| STATS$SQL_PLAN_USAGE | ||||
| STATS$SQL_SUMMARY | WRH$_ACTIVE_SESSION_HISTORY | WRI$_ADV_ACTIONS | ||
| STATS$STATSPACK_PARAMETER | WRH$_ACTIVE_SESSION_HISTORY_BL | WRI$_ADV_ASA_RECO_DATA | ||
| STATS$BG_EVENT_SUMMARY | WRH$_BG_EVENT_SUMMARY | WRI$_ADV_DEFINITIONS | ||
| WRH$_BUFFERED_QUEUES | WRI$_ADV_DEF_PARAMETERS | |||
| WRH$_BUFFERED_SUBSCRIBERS | WRI$_ADV_DIRECTIVES | |||
| STATS$BUFFER_POOL_STATISTICS | WRH$_BUFFER_POOL_STATISTICS | WRI$_ADV_FINDINGS | ||
| WRH$_COMP_IOSTAT | WRI$_ADV_JOURNAL | |||
| WRH$_CR_BLOCK_SERVER | WRI$_ADV_MESSAGE_GROUPS | |||
| WRH$_CURRENT_BLOCK_SERVER | WRI$_ADV_OBJECTS | |||
| WRH$_DATAFILE | WRI$_ADV_PARAMETERS | |||
| STATS$DB_CACHE_ADVICE | WRH$_DB_CACHE_ADVICE | WRI$_ADV_RATIONALE | ||
| WRH$_DB_CACHE_ADVICE_BL | WRI$_ADV_RECOMMENDATIONS | |||
| STATS$DLM_MISC | WRH$_DLM_MISC | WRI$_ADV_REC_ACTIONS | ||
| WRH$_DLM_MISC_BL | WRI$_ADV_SQLA_FAKE_REG | |||
| STATS$ENQUEUE_STAT | WRH$_ENQUEUE_STAT | WRI$_ADV_SQLA_MAP | ||
| WRH$_EVENT_NAME | WRI$_ADV_SQLA_STMTS | |||
| WRH$_FILEMETRIC_HISTORY | WRI$_ADV_SQLA_TMP | |||
| STATS$FILESTATXS | WRH$_FILESTATXS | WRI$_ADV_SQLT_BINDS | ||
| WRH$_FILESTATXS_BL | WRI$_ADV_SQLT_PLANS | |||
| STATS$INSTANCE_RECOVERY | WRH$_INSTANCE_RECOVERY | WRI$_ADV_SQLT_RTN_PLAN | ||
| WRH$_INST_CACHE_TRANSFER | WRI$_ADV_SQLT_STATISTICS | |||
| WRH$_INST_CACHE_TRANSFER_BL | WRI$_ADV_SQLW_COLVOL | |||
| WRH$_JAVA_POOL_ADVICE | WRI$_ADV_SQLW_STMTS | |||
| STATS$LATCH | WRH$_LATCH | WRI$_ADV_SQLW_SUM | ||
| WRH$_LATCH_BL | WRI$_ADV_SQLW_TABLES | |||
| STATS$LATCH_CHILDREN | WRH$_LATCH_CHILDREN | WRI$_ADV_SQLW_TABVOL | ||
| WRH$_LATCH_CHILDREN_BL | WRI$_ADV_TASKS | |||
| STATS$LATCH_MISSES_SUMMARY | WRH$_LATCH_MISSES_SUMMARY | WRI$_ADV_USAGE | ||
| WRH$_LATCH_MISSES_SUMMARY_BL | WRI$_AGGREGATION_ENABLED | |||
| WRH$_LATCH_NAME | WRI$_ALERT_HISTORY | |||
| STATS$LATCH_PARENT | WRH$_LATCH_PARENT | WRI$_ALERT_OUTSTANDING | ||
| WRH$_LATCH_PARENT_BL | WRI$_ALERT_THRESHOLD | |||
| STATS$LIBRARYCACHE | WRH$_LIBRARYCACHE | WRI$_ALERT_THRESHOLD_LOG | ||
| WRH$_LOG | WRI$_DBU_CPU_USAGE | |||
| WRH$_METRIC_NAME | WRI$_DBU_CPU_USAGE_SAMPLE | |||
| WRH$_MTTR_TARGET_ADVICE | WRI$_DBU_FEATURE_METADATA | |||
| WRH$_OPTIMIZER_ENV | WRI$_DBU_FEATURE_USAGE | |||
| WRH$_OSSTAT | WRI$_DBU_HIGH_WATER_MARK | |||
| WRH$_OSSTAT_BL | WRI$_DBU_HWM_METADATA | |||
| WRH$_OSSTAT_NAME | WRI$_DBU_USAGE_SAMPLE | |||
| STATS$PARAMETER | WRH$_PARAMETER | WRI$_OPTSTAT_AUX_HISTORY | ||
| WRH$_PARAMETER_BL | WRI$_OPTSTAT_HISTGRM_HISTORY | |||
| WRH$_PARAMETER_NAME | WRI$_OPTSTAT_HISTHEAD_HISTORY | |||
| STATS$PGASTAT | WRH$_PGASTAT | WRI$_OPTSTAT_IND_HISTORY | ||
| STATS$PGA_TARGET_ADVICE | WRH$_PGA_TARGET_ADVICE | WRI$_OPTSTAT_OPR | ||
| WRH$_PROCESS_MEMORY_SUMMARY | WRI$_OPTSTAT_TAB_HISTORY | |||
| STATS$RESOURCE_LIMIT | WRH$_RESOURCE_LIMIT | WRI$_SCH_CONTROL | ||
| STATS$ROWCACHE_SUMMARY | WRH$_ROWCACHE_SUMMARY | WRI$_SCH_VOTES | ||
| WRH$_ROWCACHE_SUMMARY_BL | WRI$_SEGADV_CNTRLTAB | |||
| WRH$_RULE_SET | WRI$_SEGADV_OBJLIST | |||
| WRH$_SEG_STAT | WRI$_SQLSET_BINDS | |||
| WRH$_SEG_STAT_BL | WRI$_SQLSET_DEFINITIONS | |||
| STATS$SEG_STAT_OBJ | WRH$_SEG_STAT_OBJ | WRI$_SQLSET_MASK | ||
| WRH$_SERVICE_NAME | WRI$_SQLSET_PLANS | |||
| WRH$_SERVICE_STAT | WRI$_SQLSET_PLANS_TOCAP | |||
| WRH$_SERVICE_STAT_BL | WRI$_SQLSET_PLAN_LINES | |||
| WRH$_SERVICE_WAIT_CLASS | WRI$_SQLSET_REFERENCES | |||
| WRH$_SERVICE_WAIT_CLASS_BL | WRI$_SQLSET_STATEMENTS | |||
| WRH$_SESSMETRIC_HISTORY | WRI$_SQLSET_STATISTICS | |||
| STATS$SESSTAT | WRH$_SESS_TIME_STATS | WRI$_SQLSET_WORKSPACE | ||
| STATS$SGA | WRH$_SGA | WRI$_TRACING_ENABLED | ||
| STATS$SEG_STAT , STATS$SGASTAT | WRH$_SGASTAT | |||
| WRH$_SGASTAT_BL | ||||
| WRH$_SGA_TARGET_ADVICE | ||||
| STATS$SHARED_POOL_ADVICE | WRH$_SHARED_POOL_ADVICE | |||
| STATS$SQL_STATISTICS | WRH$_SQLSTAT | |||
| WRH$_SQLSTAT_BL | ||||
| STATS$SQLTEXT | WRH$_SQLTEXT | |||
| WRH$_SQL_BIND_METADATA | ||||
| STATS$SQL_PLAN | WRH$_SQL_PLAN | |||
| WRH$_SQL_SUMMARY | ||||
| STATS$SQL_WORKAREA_HISTOGRAM | WRH$_SQL_WORKAREA_HISTOGRAM | |||
| WRH$_STAT_NAME | ||||
| WRH$_STREAMS_APPLY_SUM | ||||
| WRH$_STREAMS_CAPTURE | ||||
| WRH$_STREAMS_POOL_ADVICE | ||||
| WRH$_SYSMETRIC_HISTORY | ||||
| WRH$_SYSMETRIC_SUMMARY | ||||
| STATS$SYSSTAT | WRH$_SYSSTAT | |||
| WRH$_SYSSTAT_BL | ||||
| STATS$SYSTEM_EVENT | WRH$_SYSTEM_EVENT | |||
| WRH$_SYSTEM_EVENT_BL | ||||
| WRH$_SYS_TIME_MODEL | ||||
| WRH$_SYS_TIME_MODEL_BL | ||||
| WRH$_TABLESPACE_SPACE_USAGE | ||||
| WRH$_TABLESPACE_STAT | ||||
| WRH$_TABLESPACE_STAT_BL | ||||
| WRH$_TEMPFILE | ||||
| STATS$TEMPSTATXS | WRH$_TEMPSTATXS | |||
| WRH$_THREAD | ||||
| STATS$UNDOSTAT | WRH$_UNDOSTAT | |||
| WRH$_WAITCLASSMETRIC_HISTORY | ||||
| STATS$WAITSTAT | WRH$_WAITSTAT | |||
| WRH$_WAITSTAT_BL | ||||
How to Recover Standby from Primary Database
– Server A – Is a Live Server
– Server B – Is a Physical Standby Server
Both were configured for a data guard
How to setup RMAN catalog for Backups
- Select database for catalogue
- Create catalogue owner RMANC, default tablespace TOOLS
- Grant RECOVERY_CATALOG_OWNER role to RMANC
- Run the RMAN executable, being the same version as the catalogue database codeset and connect to the catalogue as the RMANC user
- Issue the CREATE CATALOG command
Display partition information for a specified index
Displays partition information for the specified index, or all indexes. Read more…
Undo Retention , Undo Optimization
undo_retention parameter will not guarantee a RETENTION unless you define a RETENTION GUARANTEE CLAUSE on tablespace level Read more…
Do I need to reorganise my table?
It’s a tricky question. I have explained here by using a 33GB SAP BW driving table called VBAP which needed a major work. At end I had to rebuild this table using Quest Shareplex.
