Common Oracle Clusterware crsctl commands

Oracle Clusterware crsctl commands:

# Check cluster status

crsctl check crs

crsctl check cluster

# Cluster resources

crsctl status resource -t

crsctl status resource

crsctl stat res -t

# Cluster nodes

crsctl query css votedisk

crsctl query css misscount

olsnodes -n

olsnodes -s

# Start/Stop Clusterware on local node

crsctl start crs

crsctl stop crs

# Start/Stop Clusterware on a remote node

crsctl start cluster -n racnode1

crsctl stop cluster -n racnode1

# Start/Stop Clusterware on all nodes

crsctl start cluster -all

crsctl stop cluster -all

# Check CRS stack

crsctl check cssd

crsctl check evmd

crsctl check crsd

# ASM and listeners (resource status)

crsctl status resource ora.asm -t

crsctl status resource ora.LISTENER.lsnr

# View Clusterware version

crsctl query crs activeversion

crsctl query crs softwareversion

# Enable/Disable CRS autostart

crsctl enable crs

crsctl disable crs

----------RAC node failover

# Gracefully stop Clusterware on node1

crsctl stop cluster -n racnode1

# Verify node status

crsctl check cluster -all

# Start node1 Clusterware

crsctl start cluster -n racnode1

# Verify all resources

crsctl stat res -t

Common Oracle RAC srvctl commands

Common Oracle RAC srvctl commands:

# Database

srvctl status database -d RACDB

srvctl start database -d RACDB

srvctl stop database -d RACDB -o immediate

srvctl config database -d RACDB

# Instance

srvctl status instance -d RACDB -i RACDB1

srvctl start instance -d RACDB -i RACDB1

srvctl stop instance -d RACDB -i RACDB1 -o immediate

# Services

srvctl status service -d RACDB

srvctl start service -d RACDB -s APP_SVC

srvctl stop service -d RACDB -s APP_SVC

srvctl relocate service -d RACDB -s APP_SVC -oldinst RACDB1 -newinst RACDB2

# Listener

srvctl status listener

srvctl start listener

srvctl stop listener

srvctl config listener

# SCAN

srvctl status scan

srvctl status scan_listener

srvctl config scan

srvctl start scan_listener

srvctl stop scan_listener

# ASM

srvctl status asm

srvctl start asm

srvctl stop asm

# Node applications

srvctl status nodeapps

srvctl start nodeapps

srvctl stop nodeapps

------------For your RAC node maintenance

# Stop only node1 database instance

srvctl stop instance -d RACDB -i RACDB1 -o immediate

# Start it again

srvctl start instance -d RACDB -i RACDB1

# Verify status

srvctl status database -d RACDB

View running queries in postgresql

View running queries in postgreSQL：

SELECT * FROM pg_stat_activity;

Golden gate commands

Golden gate commands for ggsci:

$ ./ggsci

GGSCI>

info all - Displays status of all Extract, Replicat, and Manager processes.

Start / Stop Processes

• start extract <extract_name> --- Start Extract process

• stop extract <extract_name> --- Stop Extract process

• start replicat <replicat_name> --- Start Replicat process

• stop replicat <replicat_name> --- Stop Replicat process

check info about individual.

• info extract <extract_name>, detail -- Detailed info about Extract

• info replicat <replicat_name>, detail -- Detailed info about Replicat

• info mgr - Displays Manager process status

Check Lag

• lag extract <extract_name> -- Shows Extract lag

• lag replicat <replicat_name> -- Shows Replicat lag

View Statistics

• stats extract <extract_name> -- Displays Extract statistics

• stats replicat <replicat_name> -- Displays Replicat statistics\

Troubleshooting

• view report <extract_name> --- View Extract report

• view report <replicat_name> --- View Replicat report

• send extract <extract_name>, status --- Real-time Extract status

• send replicat <replicat_name>, status --- Real-time Replicat status

• kill extract <extract_name> --- Forcefully terminate Extract (use with caution)

• kill replicat <replicat_name> --- Forcefully terminate Replicat (use with caution)

How to check database and database owner information on psql

How to check database and database owner information on psql:

You can check with \list command

example:

testsub=> \list

List of databases

----------------+-----------+----------+-----------------+-----------------+--------------------------------

How to check connected user on psql

How to check connected user on psql :

\conninfo

example:

testsub=> \conninfo

You are connected to database "testsub" as user "sub" on host "localhost" (address "127.0.0.1") at port "5432".

Extracting DDL of Objects in PostgreSQL(get table ddl in PostgreSQL)

===================================================

2 Ways to get DDL of objects in PostgreSQL

1. The utility pg_dump is used to dump the DDL.

2. Can get the DDL just by running \d.

1. The utility pg_dump is used to dump the DDL.

Table ddl for testtable from TESTDB

$ pg_dump -d TESTDB -s -t testtable

Table ddl for testtable from TESTDB written in to file ddl.sql

$ pg_dump -d TESTDB -s -T testtable -f ddl.sql

Table ddls for all ables from from TESTDB

$ pg_dump -d TESTDB -s

2. Can get the DDL just by running \d.

TESTDB=# \d+ testtable