How to check oracle job details ?

select job, SCHEMA_USER,THIS_DATE,BROKEN,WHAT from dba_jobs;

select * from dba_running_jobs;

How to check oracle database bit version?

select length(addr)*4 '-bits' word_length from v$process where ROWNUM =1;

how to fetch data from SQL server to Oracle server?

There are two method we can use to fetch data from SQL server to oracle server

1.install Odbc driver on oracle server and communicate to sql server an fetch the server and this will eat more CPU.
2.This method will be good method and easy also.
but this required gatewy server between oracle and sql server

steps
1.put gateway server entry on oracle tnsnames.ora
2.put another entry on gateway server about oracle server,os that both can talk to each other
3.add entry on listener on gateway server
4.add entry on driver on gateway server
c:\oracle\11g\dg4msql\admin\init<dbname>.ora
5.create user on sql server windows auth
6.create DB link on oracle server using sql server user and start fetch the data

How to connect to data gaurd broker?

DGMGRL> connect
Username: sys
Password:
Connected.
DGMGRL> show configuration;
Configuration - ABCCONF
  Protection Mode: MaxPerformance
  Databases:
    ABC     - Primary database
    ABC_DR- Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

How to identify what was the Primary host and standby Host on NPS?

Identifying the Active and Standby Nodes

[root@HA1]# crm_resource -r nps -W

crm_resource[5377]: 2009/01/31_10:13:12 info: Invoked: crm_resource -r nps -W

resource nps is running on: HA1

How to check the netezza appliance HA cluster setup status?

Display cluster status
 clustat -i 5
 crm_mon -i5

How to check event in NPS?

nzevent show -template

how to check the corrupted block in oracle?

use the below query to find out block corruption in oracle database
if the block is index try to rebuild or drop/recreate it
if the block is table block reload data using expdp/impdp or db link


select segment_name,segment_type,owner
from sys.dba_extents
where file_id=180
and (133571) between block_id and block_id + blocks -1;

output of root.sh in oracle?

# sh /oracle/oraInventory/orainstRoot.sh

Changing permissions of /oracle/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /oracle/oraInventory to oinstall.

The execution of the script is complete.

# /oracle/product/11gR2_3/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /oracle/product/11gR2_3

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Creating /usr/local/bin directory...

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

how to check the java version installed on server?

)/home/oracle>java -version
java version "1.4.2"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2)
Classic VM (build 1.4.2, J2RE 1.4.2 IBM AIX build ca142-20090307 (SR13) (JIT enabled: jitc))