Saturday, 14 April 2012

How to create oracle password file

create password file

SYS Password Management with RAC and Data Guard (Doc ID 1267828.1)

create Oracle password file

su - oracle

-bash-3.2$ id
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin)

-bash-3.2$ $ORACLE_HOME/bin/orapwd file=/u01/oracle/product/11.2.0/db_1/dbs/orapwvihaan password=vihaan entries=5

[oracle@wcp12cr2 dbs]$ $ORACLE_HOME/bin/orapwd help=y
Usage: orapwd file=<fname> entries=<users> force=<y/n> asm=<y/n>
       dbuniquename=<dbname> format=<legacy/12> sysbackup=<y/n> sysdg=<y/n>
       syskm=<y/n> delete=<y/n> input_file=<input-fname>

Usage: orapwd describe file=<fname>

  where
    file - name of password file (required),
    password - password for SYS will be prompted
               if not specified at command line.
               Ignored, if input_file is specified,
    entries - maximum number of distinct DBA (optional),
    force - whether to overwrite existing file (optional),
    asm - indicates that the password to be stored in
          Automatic Storage Management (ASM) disk group
          is an ASM password. (optional).
    dbuniquename - unique database name used to identify database
                   password files residing in ASM diskgroup only.
                   Ignored when asm option is specified (optional),
    format - use format=12 for new 12c features like SYSBACKUP, SYSDG and
             SYSKM support, longer identifiers, etc.
             If not specified, format=12 is default (optional),
    delete - drops a password file. Must specify 'asm',
             'dbuniquename' or 'file'. If 'file' is specified,
             the file must be located on an ASM diskgroup (optional),
    sysbackup - create SYSBACKUP entry (optional and requires the
                12 format). Ignored, if input_file is specified,
    sysdg - create SYSDG entry (optional and requires the 12 format),
            Ignored, if input_file is specified,
    syskm - create SYSKM entry (optional and requires the 12 format),
            Ignored, if input_file is specified,
    input_file - name of input password file, from where old user
                 entries will be migrated (optional),
    describe - describes the properties of specified password file
               (required).


  There must be no spaces around the equal-to (=) character.

[FORMAT = {12.2|12}]    old format

On filesystem SID

$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle format=12




$ORACLE_HOME/bin/orapwd describe file=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/orapwrac1
Password file Description : format=12.2

another example

[oracle@wcp12cr2 ~]$ $ORACLE_HOME/bin/orapwd describe file=/oracle/db/ohome/dbs/orapworcl
Password file Description : format=12 ignorecase=N


Now test the connection ....

-bash-3.2$ sqlplus 'sys/vihaan@prim as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 14 11:27:45 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

prim =

prim =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.129)(PORT = 1521))
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SID = vihaan)
 )
 )

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

SYS Password Management with RAC and Data Guard (Doc ID 1267828.1)

===

Then ORA-1031 error will be reported in primary alert log:

Wed Nov 17 15:33:48 2010
Error 1031 received logging on to the standby
Errors in file /u01/diag/rdbms/tl/<PRIM_INST_NAME1>/trace/<PRIM_INST_NAME1>_arc3_24629.trc:
ORA-01031: insufficient privileges
FAL[server, ARC3]: FAL archive failed, see trace file.
Errors in file /u01/diag/rdbms/tl/<PRIM_INST_NAME1>/trace/<PRIM_INST_NAME1>_arc3_24629.trc:


Solution:
1. For password stored on the file system:
a. Simply copy (scp) the orapw<SID> file from any of the primary instance to all standby instances:

$ scp $ORACLE_HOME/dbs/<PRIM_PWD_INST_NAME1> oracle@<STBY_HOSTNAME1>:<$ORACLE_HOME>/dbs/
$ scp $ORACLE_HOME/dbs/<PRIM_PWD_INST_NAME1> oracle@<STBY_HOSTNAME2>:<$ORACLE_HOME>/dbs/

b. Rename the password file on all standby nodes to match the standby SID.

on <STBY_HOSTNAME1>:
mv $ORACLE_HOME/dbs/<PRIM_PWD_INST_NAME1> $ORACLE_HOME/dbs/<STBY_PWD_INST_NAME1>

on <STBY_HOSTNAME2>:
mv $ORACLE_HOME/dbs/<PRIM_PWD_INST_NAME1> $ORACLE_HOME/dbs/<STBY_PWD_INST_NAME2>
2. For password stored on the ASM diskgroup:
a. On primary, run srvctl config database -d <db_unique_name> to locate the password file
$ srvctl config database -d <DB_NAME>

Password file: +<DG_NAME>/<DB_NAME>/PASSWORD/<PWD_DB_NAME>.400.940505217
b. using asmcmd to copy the file to file system
asmcmd> pwcopy +<DG_NAME>/<DB_NAME>/PASSWORD/<PWD_DB_NAME>.400.940505217 /tmp
c. scp the password file to standby hosts
$ scp /tmp/<PWD_DB_NAME>.400.940505217 oracle@<standbyhost>:/tmp
d. restore the password file to ASM diskgroup on standby
asmcmd> pwcopy /tmp/<PWD_DB_NAME>.400.940505217 +<DG_NAME>/<DB_NAME>DG/PASSWORD/<PWD_DB_NAME>DG
 e. modify the password location for standby
$ srvctl modify database -d <db_unique_name> -pwfile +<DG_NAME>/<DB_NAME>DG/PASSWORD/<PWD_DB_NAME>DG
 
3. It is not required to shutdown/restart any of the primary or standby instances.

4. Log shipping will resume automatically after this.
If not, alter parameter log_archive_dest_state_<n> to defer, then enable.

SQL> alter system set log_archive_dest_state_2=defer scope=both sid='*';

SQL> alter system set log_archive_dest_state_2=enable scope=both sid='*';



Grid ASM 
ASMCMD [+DATA/IBRAC/PWDFILE] > pwcreate --dbuniquename ibrac +DATA/IBRAC/PWDFILE/pwdibrac Very_Complex!1ASMCMD 
ASMCMD-9465: WARNING: passing password on command line is deprecated


ASMCMD [+DATA/IBRAC/PWDFILE] > ls -s
Block_Size  Blocks  Bytes  Space  Name
       512      12   6144      0  pwdibrac => +DATA/IBRAC/PASSWORD/pwdibrac.3840.1145270461
ASMCMD [+DATA/IBRAC/PWDFILE] >




??
ASMCMD [+DATA/IBRAC/PWDFILE] > pwget --dbuniquename ibrac
PRCD-1229 : An attempt to access configuration of database ibrac was rejected because its version 12.2.0.1.0 differs from the program version 19.0.0.0.0. Instead run the program from /u01/app/oracle/product/12.2.0/dbhome_1.
A

+DATA/IBRAC/PASSWORD/pwdibrac.3840.1145270461


from database 
srvctl modify database -d ibrac -pwfile +DATA/IBRAC/PASSWORD/pwdibrac.3840.1145270461

srvctl config database -d ibrac|grep -i password
Password file: +DATA/IBRAC/PASSWORD/pwdibrac.3840.1145270461


now you can change any password !!!

SQL> alter user sys identified by sys ;    :)

User altered.



sqlplus sys/sys@'ibrac2' as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sat Aug 19 10:49:34 2023

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Last Successful login time: Sat Aug 19 2023 10:49:29 -04:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production


another example 

for password file 


[oracle@oragrid ~]$ srvctl config database -d v19mpc -v
Database unique name: v19mpc
Database name: v19mpc
Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/V19MPC/PARAMETERFILE/spfile.273.1236175303
Password file:   <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<  no file 
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services:
OSDBA group:
OSOPER group:
Database instance: v19mpc





[oracle@oragrid ~]$ cd $ORACLE_HOME
[oracle@oragrid dbhome_1]$ cd dbs
[oracle@oragrid dbs]$ ls -ltr
total 16
-rw-r--r--. 1 oracle oinstall 3079 May 14  2015 init.ora
-rw-r-----. 1 oracle asmadmin   24 Jun 17 13:07 lkV19MPC
-rw-r-----. 1 oracle oinstall 2048 Jun 17 13:10 orapwv19mpc
-rw-rw----. 1 oracle asmadmin 1544 Jun 25 09:14 hc_v19mpc.dat
[oracle@oragrid dbs]$ pwd

/u01/app/oracle/product/19.0.0/dbhome_1/dbs
[oracle@oragrid dbs]$ id
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),3003(asmadmin),3004(asmdba),54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023


as a grid user !!!

[oracle@oragrid dbs]$ logout
[root@oragrid ~]# su - grid
[grid@oragrid ~]$ asmcmd -p



[grid@oragrid ~]$ cat /etc/oratab
#Backup file is  /u01/app/grid/crsdata/oragrid/output/oratab.bak.oragrid.grid line added by Agent
#



# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.

# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third field indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
#+ASM:/u01/app/19.0.0/grid:N            # line added by Agent
+ASM:/u01/app/19.31.0/grid:N            # line added by Agent
v19mpc:/u01/app/oracle/product/19.0.0/dbhome_1:N                # line added by Agent

[grid@oragrid ~]$ . oraenv
ORACLE_SID = [grid] ? +ASM
The Oracle base has been set to /u01/app/grid

[grid@oragrid ~]$ asmcmd -p
ASMCMD [+] > pwd
+
ASMCMD [+] > pwcopy --dbuniquename v19mpc '/u01/app/oracle/product/19.0.0/dbhome_1/dbs/orapwv19mpc' '+DATA'
copying /u01/app/oracle/product/19.0.0/dbhome_1/dbs/orapwv19mpc -> +DATA/orapwv19mpc
ASMCMD [+] >



ASMCMD [+] > pwcopy --dbuniquename v19mpc '/u01/app/oracle/product/19.0.0/dbhome_1/dbs/orapwv19mpc' '+DATA'
copying /u01/app/oracle/product/19.0.0/dbhome_1/dbs/orapwv19mpc -> +DATA/orapwv19mpc

ASMCMD [+] >  pwget --dbuniquename v19mpc
+DATA/orapwv19mpc

ASMCMD [+] >




srvctl modify database -d v19mpc -pwfile +DATA/orapwv19mpc


 su - oracle
 orcl  /oracle/db/ohome




[oracle@oragrid ~]$ setsid
 1-       +ASM
 2-     v19mpc

Select the Oracle SID with given number [1]:
2
Your profile configured for v19mpc with information below:

The Oracle base remains unchanged with value /u01/app/oracle






[oracle@oragrid ~]$ srvctl modify database -d v19mpc -pwfile +DATA/orapwv19mpc
[oracle@oragrid ~]$ srvctl config database -d v19mpc -v
Database unique name: v19mpc
Database name: v19mpc
Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/V19MPC/PARAMETERFILE/spfile.273.1236175303
Password file: +DATA/orapwv19mpc
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services:
OSDBA group:
OSOPER group:
Database instance: v19mpc
[oracle@oragrid ~]$






orapwd describe file=${ORACLE_HOME}/dbs/orapw${ORACLE_SID}

Password file Description : format=12.2
Data Guard Physical Standby Changing the SYS password when a broker configuration exists (Doc ID 1199943.1)

Sunday, 1 April 2012

Oracle Temp space information

Oracle Space usage
Oracle Temp

https://anuj-singh.blogspot.com/2012/09/oracle-temp-tablespace-usage-info.html

SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used, D.mb_total - SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_free
FROM v$sort_segment A, ( SELECT B.name, C.block_size, SUM (C.bytes) / 1024 / 1024 mb_total
FROM v$tablespace B, v$tempfile C
WHERE B.ts#= C.ts#
GROUP BY B.name, C.block_size ) D
WHERE A.tablespace_name = D.name
GROUP by A.tablespace_name, D.mb_total;

TABLESPACE MB_TOTAL MB_USED MB_FREE
------------------------------- ---------- ---------- ----------
TEMP 29 0 29

SELECT S.sid || ',' || S.serial# sid_serial, S.username,
T.blocks * TBS.block_size / 1024 / 1024 mb_used, T.tablespace,
T.sqladdr address, Q.hash_value, Q.sql_text
FROM v$sort_usage T, v$session S, v$sqlarea Q, dba_tablespaces TBS
WHERE T.session_addr = S.saddr
AND T.sqladdr = Q.address (+)
AND T.tablespace = TBS.tablespace_name
ORDER BY S.sid;

SELECT S.sid || ',' || S.serial# sid_serial, S.username, S.osuser, P.spid, S.module,
S.program, SUM (T.blocks) * TBS.block_size / 1024 / 1024 mb_used, T.tablespace,
COUNT(*) sort_ops
FROM v$sort_usage T, v$session S, dba_tablespaces TBS, v$process P
WHERE T.session_addr = S.saddr
AND S.paddr = P.addr
AND T.tablespace = TBS.tablespace_name
GROUP BY S.sid, S.serial#, S.username, S.osuser, P.spid, S.module,
S.program, TBS.block_size, T.tablespace
ORDER BY sid_serial;

break on report
compute sum of mb on report
compute sum of pct on report

col sid format a10 heading "Session ID"
col username format a10 heading "User Name"
col sql_text format a8 heading "SQL"
col tablespace format a10 heading "Temporary|TS Name"
col mb format 999,999,990 heading "Mbytes|Used"
col pct format 990.00 heading "% Avail|TS Spc"

select s.sid || ',' || s.serial# sid,
s.username,
u.tablespace,
substr(a.sql_text, 1, (instr(a.sql_text, ' ')-1)) sql_text,
u.blocks/128 mb,
((u.blocks/128)/(sum(f.blocks)/128))*100 pct
from v$sort_usage u,
v$session s,
v$sqlarea a,
dba_data_files f
where s.saddr = u.session_addr
and a.address (+) = s.sql_address
and a.hash_value (+) = s.sql_hash_value
and f.tablespace_name = u.tablespace
group by
s.sid || ',' || s.serial#,
s.username,
substr(a.sql_text, 1, (instr(a.sql_text, ' ')-1)),
u.tablespace,
u.blocks/128

spool sort_use
/

select u.username, s.sql_fulltext, u.segtype, u.extents, u.blocks
from v$tempseg_usage u, v$sql s
where s.sql_id = u.sql_id;

SELECT s.username, u."USER", u.tablespace,u.contents,u.extents, u.blocks,a.sql_text,u.sqladdr,u.sqlhash
FROM v$session s,v$sort_usage u,v$sql a
WHERE s.SADDR = u.SESSION_ADDR
and a.hash_value = u.sqlhash and u.contents = 'TEMPORARY'

Tuesday, 27 March 2012

Oracle Tablespace Monitoring Script

Oracle Tablespace Monitoring

from this Blog

http://blog.csdn.net/flighting/article/details/1119253


Oracle Tablespace Monitoring Script
Oracle Tablespace Monitoring

from this Blog
http://blog.csdn.net/flighting/article/details/1119253



-- List tablespaces
- space allocated
- space used
- %free (without maxbytes)
- Autoextend Y|N|Y/N
- Sum of maxbytes
- increment (in Mb) 10/100 or 0/10/.... if more than 2 datafiles with different increment size
- Largest free extent
- Space management (DICT MAN -> Dictionnary Manual| ASSM | LMTS)
- Number of files
- T: tempfile | D: datafile
- %Used (using maxbytes in calcul) 

 

set linesize   145
set pagesize    60
set trimout     on
set trimspool   on
Set Feedback   off
set timing     off
set verify     off


prompt

prompt -- ----------------------------------------------------------------------- ---

prompt --   Tablespaces                                                           ---

prompt -- ----------------------------------------------------------------------- ---

prompt


Set Heading  Off
Set Termout  Off

create or replace function show_autoext_tbs(P_Tablespace_Name In Varchar2) return varchar2
Is
  --
  Cursor CX Is
Select distinct Substr(autoextensible,1,1)
      from dba_data_files
      where tablespace_name=P_Tablespace_Name
      Union
Select distinct Substr(autoextensible,1,1)
      from dba_temp_files
      where tablespace_name=P_Tablespace_Name
;
  --
  W_Texte     Varchar2(20);
  W_Temp Varchar2(20);
  --
Begin
  --
  W_Texte := Null;
  --
  Open CX;
  Loop
    Fetch CX Into W_Temp;
    Exit When CX%notfound;
    W_Texte := W_Texte|| ' ' || W_Temp;
  End Loop;
  Close CX;
  --
  W_Texte := Replace(Substr(W_Texte, 2, 4), ' ', '/');
  --
  Return W_Texte;
  --
End;
/

-- show error



Column Var_DB_BLOCK_SIZE new_value Var_DB_BLOCK_SIZE noprint

Select value Var_DB_BLOCK_SIZE
  from  v$parameter
where   Upper(name) = Upper ('db_block_size')
;

Set Termout  On
Set Heading  On


create or replace function show_increment_tbs(P_Tablespace_Name In Varchar2, P_Db_Block_Size In Number) return varchar2
Is
  --
  Cursor CX Is
Select distinct To_Char(round(((Increment_By * P_Db_Block_Size)/1024/1024),1) )
      from dba_data_files
      where tablespace_name=P_Tablespace_Name
      Union
Select distinct To_Char(Round(((Increment_By * P_Db_Block_Size)/1024/1024),1) )
      from dba_temp_files
      where tablespace_name=P_Tablespace_Name
;
  --
  W_Texte     Varchar2(20);
  W_Temp Varchar2(20);
  --
Begin
  --
  W_Texte := Null;
  --
  Open CX;
  Loop
    Fetch CX Into W_Temp;
    Exit When CX%notfound;
    W_Texte := W_Texte|| ' ' || W_Temp;
  End Loop;
  Close CX;
  --
  W_Texte := W_Texte||' ';
  W_Texte := Replace(W_Texte,' ', '/');
  W_Texte := Substr(W_Texte,2, Instr(W_Texte, '/', -1, 1)-2);
  If Instr(W_Texte, '/', 1,2) != 0 then
    W_Texte := Substr(W_Texte, 1, Instr(W_Texte, '/', 1,2))||'...';
  End If;
  --
  Return W_Texte;
  --
End;
/

Set Termout  On
Set Heading  On
clear breaks
break on contents -
skip 1
compute Sum of alloc used maxbytes nfree nbfrag on contents
column tblsp         format a22 wrap         heading  "Tablespace|Name"
column Alloc         format 99999999         heading  "Alloc|(Mb)"
column file_name     format a45 wrap         heading  "DataFile Name"
column rfno          format 999              heading  "R.|Fno"
-- column inc        format 9999999          heading  "Incr|(Mb)"
column inc           format a15              heading  "Incr|(Mb)"
column maxbytes      format 9999999          heading  "Sum Max|(Gb)"
column user_bytes    format 999999           heading  "Userbytes|(Mb)"
column free          format 999999           heading  "Free|(Mb)"
column nfree         format 99999            heading  "Max|Free|(Mb)"
column used          format 99999999         heading  "Used|(Mb)"
column pused         format 990.9            heading  "%Used"
column maxpused      format 990.9            heading  "Max|%Used"
column contents      format a5               heading  "Cont."
column fragmax       format 99999            heading  "Larg.|Free|Ext|(Mb)"
column nbfrag        format 99999            heading  "Nb|frag"
column nbfile        format 99               heading  "Nb|F."
column autoext       format a3 wrap          heading  "Auto|Ext."
column ftype         format a2 wrap          heading  "F.|T."
column ext_manage    format a5 wrap          heading  "Ext.|M."
column seg_sp_mg     format a2 wrap          heading  "S.|M."
column seg_space_mg  format a7 wrap          heading  "Space|Mg."
set linesize 145
Select 
       dt.contents contents  
      , dt.Tablespace_Name tblsp
      , df.alloc alloc
      , df.alloc - nvl(fs.free,0) used
      , ((df.alloc - nvl(fs.free,0))* 100)/df.alloc pused
      , dt.autoext       autoext
      , df.summaxbytes/1024 maxbytes
      , dt.Inc inc
--    , nvl(fs.free,0) free
--    , fs.nbfrag
      , Nvl(fs.fragmax,0) fragmax
--    , dt.ext_manage 
--    , dt.seg_sp_mg seg_sp_mg
      , Decode(dt.ext_manage||' '||dt.seg_sp_mg,'LOC MA', ' LMTS', 'LOC AU', '  ASSM',dt.ext_manage||' '||dt.seg_sp_mg) seg_space_mg
      , df.nbf nbfile
      , df.ftype ftype
--    , decode((df.summaxbytes),0,(df.alloc),(df.summaxbytes))-(df.alloc - nvl(fs.free,0)) nfree
      , 100 - ((decode((df.summaxbytes),0,(df.alloc),(df.summaxbytes))-(df.alloc - nvl(fs.free,0))) * 100 / decode((df.summaxbytes),0,(df.alloc),(df.summaxbytes)))  maxpused
  from 
       ( select 
                Substr(contents,1,4)     contents
              , tablespace_name
              , Substr(extent_management,1,3)   ext_manage
              , Substr(segment_space_management,1,2) seg_sp_mg
              , show_autoext_tbs(tablespace_name) autoext
   , show_increment_tbs (tablespace_name, &Var_DB_BLOCK_SIZE) inc
           from dba_tablespaces
       ) dt
    ,  ( select 
                Sum(Bytes/1024/1024) alloc
              , Max(MaxBytes/1024/1024) maxbytes
              , Sum(MaxBytes/1024/1024) summaxbytes
              , count(*) nbf
              , tablespace_name
              , 'D' ftype
           from Dba_Data_Files
          Group
             By tablespace_name
         Union
         select 
                Sum(Bytes/1024/1024) alloc
              , Max(MaxBytes/1024/1024) maxbytes
              , Sum(MaxBytes/1024/1024) summaxbytes
              , count(*) nbf
              , tablespace_name
              , 'T' ftype
           from Dba_Temp_Files
          Group
             By tablespace_name
       ) df
    ,  (select
                Nvl(Sum(nvl(bytes/1024/1024,0)),0) free
              , Nvl(max (bytes)/1048576,0)   fragmax
              , tablespace_name
              , count(*)                        nbfrag
          from (Select distinct tablespace_name, bytes from dba_free_space)
         Group   By tablespace_name
         order by max (bytes)/1048576 desc 
       ) fs
 Where df.tablespace_name  =  fs.tablespace_name (+)
  and  df.tablespace_name  = dt.tablespace_name
 Group
    By  dt.contents
     , dt.Tablespace_Name 
     , df.alloc
     , df.maxbytes
     , df.summaxbytes
     , df.nbf
     , dt.Inc
--   , nvl(fs.free,0)
     , df.alloc - nvl(fs.free,0)
--   , fs.nbfrag
     , fs.fragmax
     , dt.autoext
     , dt.ext_manage
     , df.ftype 
     , dt.seg_sp_mg   
 Order
    By contents
     , maxpused desc
     , dt.inc
;
Prompt
Set Heading  Off 
Set Termout  Off
Drop function show_autoext_tbs;
Drop function show_increment_tbs;
Set Heading  On 
Set Termout  On


                                                                                     Larg.
                                                                                       Free
      Tablespace                 Alloc      Used        Aut  Sum Max Incr               Ext Space    Nb F.    Max
Cont. Name                        (Mb)      (Mb)  %Used Ext     (Gb) (Mb)              (Mb) Mg.      F. T.  %Used
----- ---------------------- --------- --------- ------ --- -------- --------------- ------ ------- --- -- ------
PERM  SYSTEM                       690       684   99.2 Y         32 10                   5   LMTS    1 D     2.1
      SYSAUX                       550       513   93.4 Y         32 10                  32   ASSM    1 D     1.6
      EXAMPLE                      100        79   78.8 Y         32 .6                  19   ASSM    1 D     0.2
      USERS                          5         4   81.3 Y         32 1.3                  1   ASSM    1 D     0.0
*****                        --------- ---------            --------
sum                               1345      1280                 128

TEMP  TEMP                          29        29  100.0 Y         32 .6                   0  LMTS     1 T     0.1

                                                                                      Larg.
                                                                                       Free
      Tablespace                 Alloc      Used        Aut  Sum Max Incr               Ext Space    Nb F.    Max
Cont. Name                        (Mb)      (Mb)  %Used Ext     (Gb) (Mb)              (Mb) Mg.      F. T.  %Used
----- ---------------------- --------- --------- ------ --- -------- --------------- ------ ------- --- -- ------
*****                        --------- ---------            --------
sum                                 29        29                  32

UNDO  UNDOTBS1                      95        40   41.8 Y         32 5                   40  LMTS     1 D     0.1
*****                        --------- ---------            --------
sum                                 95        40                  32


6 rows selected.

Sunday, 25 March 2012

srvctl command reference

srvctl command reference ...

Setting Environment Variables Through Srvctl (Doc ID 733567.1)

srvctl config database list of database

$ srvctl -h
srvctl [-V]
srvctl add database -d <db_unique_name> -o <oracle_home> [-m <domain_name>] [-p <spfile>] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s <start_options>] [-t <stop_options>] [-n <db_name>] [-y {AUTOMATIC | MANUAL}] [-g "<serverpool_list>"] [-x <node_name>] [-a "<diskgroup_list>"]
srvctl config database [-d <db_unique_name> [-a] ]
srvctl start database -d <db_unique_name> [-o <start_options>]
srvctl stop database -d <db_unique_name> [-o <stop_options>] [-f]
srvctl status database -d <db_unique_name> [-f] [-v]
srvctl enable database -d <db_unique_name> [-n <node_name>]
srvctl disable database -d <db_unique_name> [-n <node_name>]
srvctl modify database -d <db_unique_name> [-n <db_name>] [-o <oracle_home>] [-u <oracle_user>] [-m <domain>] [-p <spfile>] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s <start_options>] [-t <stop_options>] [-y {AUTOMATIC | MANUAL}] [-g "<serverpool_list>" [-x <node_name>]] [-a "<diskgroup_list>"|-z]
srvctl remove database -d <db_unique_name> [-f] [-y]
srvctl getenv database -d <db_unique_name> [-t "<name_list>"]
srvctl setenv database -d <db_unique_name> {-t <name>=<val>[,<name>=<val>,...] | -T <name>=<val>}
srvctl unsetenv database -d <db_unique_name> -t "<name_list>"

srvctl add instance -d <db_unique_name> -i <inst_name> -n <node_name> [-f]
srvctl start instance -d <db_unique_name> {-n <node_name> [-i <inst_name>] | -i <inst_name_list>} [-o <start_options>]
srvctl stop instance -d <db_unique_name> {-n <node_name> | -i <inst_name_list>}  [-o <stop_options>] [-f]
srvctl status instance -d <db_unique_name> {-n <node_name> | -i <inst_name_list>} [-f] [-v]
srvctl enable instance -d <db_unique_name> -i "<inst_name_list>"
srvctl disable instance -d <db_unique_name> -i "<inst_name_list>"
srvctl modify instance -d <db_unique_name> -i <inst_name> { -n <node_name> | -z }
srvctl remove instance -d <db_unique_name> [-i <inst_name>] [-f] [-y]

srvctl add service -d <db_unique_name> -s <service_name> {-r "<preferred_list>" [-a "<available_list>"] [-P {BASIC | NONE | PRECONNECT}] | -g <server_pool> [-c {UNIFORM | SINGLETON}] } [-k   <net_num>] [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}] [-q {TRUE|FALSE}] [-x {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z <failover_retries>] [-w <failover_delay>]
srvctl add service -d <db_unique_name> -s <service_name> -u {-r "<new_pref_inst>" | -a "<new_avail_inst>"}
srvctl config service -d <db_unique_name> [-s <service_name>] [-a]
srvctl enable service -d <db_unique_name> -s "<service_name_list>" [-i <inst_name> | -n <node_name>]
srvctl disable service -d <db_unique_name> -s "<service_name_list>" [-i <inst_name> | -n <node_name>]
srvctl status service -d <db_unique_name> [-s "<service_name_list>"] [-f] [-v]
srvctl modify service -d <db_unique_name> -s <service_name> -i <old_inst_name> -t <new_inst_name> [-f]
srvctl modify service -d <db_unique_name> -s <service_name> -i <avail_inst_name> -r [-f]
srvctl modify service -d <db_unique_name> -s <service_name> -n -i "<preferred_list>" [-a "<available_list>"] [-f]
srvctl modify service -d <db_unique_name> -s <service_name> [-c {UNIFORM | SINGLETON}] [-P {BASIC|PRECONNECT|NONE}] [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}][-q {true|false}] [-x {true|false}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z <integer>] [-w <integer>]
srvctl relocate service -d <db_unique_name> -s <service_name> {-i <old_inst_name> -t <new_inst_name> | -c <current_node> -n <target_node>} [-f]
       Specify instances for an administrator-managed database, or nodes for a policy managed database
srvctl remove service -d <db_unique_name> -s <service_name> [-i <inst_name>] [-f]
srvctl start service -d <db_unique_name> [-s "<service_name_list>" [-n <node_name> | -i <inst_name>] ] [-o <start_options>]
srvctl stop service -d <db_unique_name> [-s "<service_name_list>" [-n <node_name> | -i <inst_name>] ] [-f]

srvctl add nodeapps { { -n <node_name> -A <name|ip>/<netmask>/[if1[|if2...]] } | { -S <subnet>/<netmask>/[if1[|if2...]] } } [-p <portnum>] [-m <multicast-ip-address>] [-e <eons-listen-port>] [-l <ons-local-port>]  [-r <ons-remote-port>] [-t <host>[:<port>][,<host>[:<port>]...]] [-v]
srvctl config nodeapps [-a] [-g] [-s] [-e]
srvctl modify nodeapps {[-n <node_name> -A <new_vip_address>/<netmask>[/if1[|if2|...]]] | [-S <subnet>/<netmask>[/if1[|if2|...]]]} [-m <multicast-ip-address>] [-p <multicast-portnum>] [-e <eons-listen-port>] [ -l <ons-local-port> ] [-r <ons-remote-port> ] [-t <host>[:<port>][,<host>[:<port>]...]] [-v]
srvctl start nodeapps [-n <node_name>] [-v]
srvctl stop nodeapps [-n <node_name>] [-f] [-r] [-v]
srvctl status nodeapps
srvctl enable nodeapps [-v]
srvctl disable nodeapps [-v]
srvctl remove nodeapps [-f] [-y] [-v]
srvctl getenv nodeapps [-a] [-g] [-s] [-e] [-t "<name_list>"]
srvctl setenv nodeapps {-t "<name>=<val>[,<name>=<val>,...]" | -T "<name>=<val>"}
srvctl unsetenv nodeapps -t "<name_list>" [-v]

srvctl add vip -n <node_name> -k <network_number> -A <name|ip>/<netmask>/[if1[|if2...]] [-v]
srvctl config vip { -n <node_name> | -i <vip_name> }
srvctl disable vip -i <vip_name> [-v]
srvctl enable vip -i <vip_name> [-v]
srvctl remove vip -i "<vip_name_list>" [-f] [-y] [-v]
srvctl getenv vip -i <vip_name> [-t "<name_list>"]
srvctl start vip { -n <node_name> | -i <vip_name> } [-v]
srvctl stop vip { -n <node_name>  | -i <vip_name> } [-f] [-r] [-v]
srvctl status vip { -n <node_name> | -i <vip_name> }
srvctl setenv vip -i <vip_name> {-t "<name>=<val>[,<name>=<val>,...]" | -T "<name>=<val>"}
srvctl unsetenv vip -i <vip_name> -t "<name_list>" [-v]

srvctl add asm [-l <lsnr_name>]
srvctl start asm [-n <node_name>] [-o <start_options>]
srvctl stop asm [-n <node_name>] [-o <stop_options>] [-f]
srvctl config asm [-a]
srvctl status asm [-n <node_name>] [-a]
srvctl enable asm [-n <node_name>]
srvctl disable asm [-n <node_name>]
srvctl modify asm [-l <lsnr_name>]
srvctl remove asm [-f]
srvctl getenv asm [-t <name>[, ...]]
srvctl setenv asm -t "<name>=<val> [,...]" | -T "<name>=<value>"
srvctl unsetenv asm -t "<name>[, ...]"

srvctl start diskgroup -g <dg_name> [-n "<node_list>"]
srvctl stop diskgroup -g <dg_name> [-n "<node_list>"] [-f]
srvctl status diskgroup -g <dg_name> [-n "<node_list>"] [-a]
srvctl enable diskgroup -g <dg_name> [-n "<node_list>"]
srvctl disable diskgroup -g <dg_name> [-n "<node_list>"]
srvctl remove diskgroup -g <dg_name> [-f]

srvctl add listener [-l <lsnr_name>] [-s] [-p "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"] [-o <oracle_home>] [-k <net_num>]
srvctl config listener [-l <lsnr_name>] [-a]
srvctl start listener [-l <lsnr_name>] [-n <node_name>]
srvctl stop listener [-l <lsnr_name>] [-n <node_name>] [-f]
srvctl status listener [-l <lsnr_name>] [-n <node_name>]
srvctl enable listener [-l <lsnr_name>] [-n <node_name>]
srvctl disable listener [-l <lsnr_name>] [-n <node_name>]
srvctl modify listener [-l <lsnr_name>] [-o <oracle_home>] [-p "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]"] [-u <oracle_user>] [-k <net_num>]
srvctl remove listener [-l <lsnr_name> | -a] [-f]
srvctl getenv listener [-l <lsnr_name>] [-t <name>[, ...]]
srvctl setenv listener [-l <lsnr_name>] -t "<name>=<val> [,...]" | -T "<name>=<value>"
srvctl unsetenv listener [-l <lsnr_name>] -t "<name>[, ...]"

srvctl add scan -n <scan_name> [-k <network_number> [-S <subnet>/<netmask>[/if1[|if2|...]]]]
srvctl config scan [-i <ordinal_number>]
srvctl start scan [-i <ordinal_number>] [-n <node_name>]
srvctl stop scan [-i <ordinal_number>] [-f]
srvctl relocate scan -i <ordinal_number> [-n <node_name>]
srvctl status scan [-i <ordinal_number>]
srvctl enable scan [-i <ordinal_number>]
srvctl disable scan [-i <ordinal_number>]
srvctl modify scan -n <scan_name>
srvctl remove scan [-f] [-y]
srvctl add scan_listener [-l <lsnr_name_prefix>] [-s] [-p [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]]
srvctl config scan_listener [-i <ordinal_number>]
srvctl start scan_listener [-n <node_name>] [-i <ordinal_number>]
srvctl stop scan_listener [-i <ordinal_number>] [-f]
srvctl relocate scan_listener -i <ordinal_number> [-n <node_name>]
srvctl status scan_listener [-i <ordinal_number>]
srvctl enable scan_listener [-i <ordinal_number>]
srvctl disable scan_listener [-i <ordinal_number>]
srvctl modify scan_listener {-u|-p [TCP:]<port>[/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]}
srvctl remove scan_listener [-f] [-y]

srvctl add srvpool -g <pool_name> [-l <min>] [-u <max>] [-i <importance>] [-n "<server_list>"]
srvctl config srvpool [-g <pool_name>]
srvctl status srvpool [-g <pool_name>] [-a]
srvctl status server -n "<server_list>" [-a]
srvctl relocate server -n "<server_list>" -g <pool_name> [-f]
srvctl modify srvpool -g <pool_name> [-l <min>] [-u <max>] [-i <importance>] [-n "<server_list>"]
srvctl remove srvpool -g <pool_name>

srvctl add oc4j [-v]
srvctl config oc4j
srvctl start oc4j [-v]
srvctl stop oc4j [-f] [-v]
srvctl relocate oc4j [-n <node_name>] [-v]
srvctl status oc4j [-n <node_name>]
srvctl enable oc4j [-n <node_name>] [-v]
srvctl disable oc4j [-n <node_name>] [-v]
srvctl modify oc4j -p <oc4j_rmi_port> [-v]
srvctl remove oc4j [-f] [-v]

srvctl start home -o <oracle_home> -s <state_file> -n <node_name>
srvctl stop home -o <oracle_home> -s <state_file> -n <node_name> [-t <stop_options>] [-f]
srvctl status home -o <oracle_home> -s <state_file> -n <node_name>

srvctl add filesystem -d <volume_device> -v <volume_name> -g <dg_name> [-m <mountpoint_path>] [-u <user>]
srvctl config filesystem -d <volume_device>
srvctl start filesystem -d <volume_device> [-n <node_name>]
srvctl stop filesystem -d <volume_device> [-n <node_name>] [-f]
srvctl status filesystem -d <volume_device>
srvctl enable filesystem -d <volume_device>
srvctl disable filesystem -d <volume_device>
srvctl modify filesystem -d <volume_device> -u <user>
srvctl remove filesystem -d <volume_device> [-f]

srvctl start gns [-v] [-l <log_level>] [-n <node_name>]
srvctl stop gns [-v] [-n <node_name>] [-f]
srvctl config gns [-v] [-a] [-d] [-k] [-m] [-n <node_name>] [-p] [-s] [-V]
srvctl status gns -n <node_name>
srvctl enable gns [-v] [-n <node_name>]
srvctl disable gns [-v] [-n <node_name>]
srvctl relocate gns [-v] [-n <node_name>] [-f]
srvctl add gns [-v] -d <domain> -i <vip_name|ip> [-k <network_number> [-S <subnet>/<netmask>[/<interface>]]]
srvctl modify gns [-v] [-f] [-l <log_level>] [-d <domain>] [-i <ip_address>] [-N <name> -A <address>] [-D <name> -A <address>] [-c <name> -a <alias>] [-u <alias>] [-r <address>] [-V <name>] [-F <forwarded_domains>] [-R <refused_domains>] [-X <excluded_interfaces>]
Usage: srvctl remove gns [-f] [-d <domain_name>]

Crsctl Syntax (for further explanation of these commands see the Oracle Documentation)

$ ./crsctl -h
Usage: crsctl add       - add a resource, type or other entity
       crsctl check     - check a service, resource or other entity
       crsctl config    - output autostart configuration
       crsctl debug     - obtain or modify debug state
       crsctl delete    - delete a resource, type or other entity
       crsctl disable   - disable autostart
       crsctl enable    - enable autostart
       crsctl get       - get an entity value
       crsctl getperm   - get entity permissions
       crsctl lsmodules - list debug modules
       crsctl modify    - modify a resource, type or other entity
       crsctl query     - query service state
       crsctl pin       - Pin the nodes in the nodelist
       crsctl relocate  - relocate a resource, server or other entity
       crsctl replace   - replaces the location of voting files
       crsctl setperm   - set entity permissions
       crsctl set       - set an entity value
       crsctl start     - start a resource, server or other entity
       crsctl status    - get status of a resource or other entity
       crsctl stop      - stop a resource, server or other entity
       crsctl unpin     - unpin the nodes in the nodelist
       crsctl unset     - unset a entity value, restoring its default

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

srvctl command list



srvctl commands
SRVCTL:
srvctl command target [options]
commands: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config
targets: database/db|instance/inst|service/serv|nodeapps|asm|listener
targets: database/db|instance/inst|service/serv|nodeapps|asm|listener |diskgroup|home|ons|eons|filesystem|gns|oc4j|scan|scan_listener |srvpool|server|VIP -- From Oracle 11g R2

srvctl -help or srvctl -v



srvctl -V -- prints version
srvctl version: 10.2.0.0.0 (or) srvctl version: 11.2.0.1.0



srvctl -h -- print usage



srvctl status service –h




srvctl enable asm -n node_name [-i asm_inst_name]

-n node_name:Node name
-i inst_name:ASM instance name.


An example of this command is:

srvctl enable asm -n node01 -i asm1





To add/remove listener
srvctl add listener -n node_name -o ORACLE_HOME [-l listener_name]
srvctl add listener –n linuxrac01 –o $ORACLE_HOME –l listenerbhavik_test01
srvctl remove listener -n node_name [-l listener_name]
srvctl remove listener –n linuxrac02 –l listenerbhavik_test02


To add/remove listener in 11g Rel 2
srvctl add listener -l LISTENERASM01 -p "TCP:1525" -o $ORACLE_HOME
srvctl add listener -l listenerbhavik01 -p 1341 -o /db/oracle/ora11201
srvctl remove listener [-l lsnr_name|-a] [-f]
srvctl remove listener -l listenerbhavik01


To start/stop listener
srvctl start listener -n node_name [-l listener_names]
srvctl start listener -n linuxrac01
srvctl stop listener -n node_name [-l listener_names]
srvctl stop listener -n linuxrac01


To check the status of the listener
srvctl status listener [-n node_name] [-l listener_names]
srvctl status listener -n linuxrac02

To configure listener
srvctl config listener -n node_name
srvctl config listener –n linuxrac01
srvctl config listener [-l lsnr_name] [-a]
srvctl config listener -l listenerbhavik01

To modify the listener
srvctl modify listener -n node_name [-l listener_names] -o ORACLE_HOME
srvctl modify listener -n linuxrac03 -o /db/oracle/app/oracle/product/11.2/asm -l "LISTENERbhavik_test04"

To enable/disable listener
srvctl enable listener [-l lsnr_name] [-n node_name]
srvctl enable listener -l listenerbhavik_test02 -n linuxrac02
srvctl disable listener [-l lsnr_name] [-n node_name]
srvctl disable listener -l listenerbhavik_test02 -n linuxrac02

To get/set/unset environment parameter for listener
srvctl getenv listener [-l lsnr_name]
srvctl getenv listener -l listenerbhavik_test02



gets the environment configuration for a cluster database:

srvctl getenv database -d mndb



srvctl setenv listener [-l lsnr_name] [-t "name=val]
srvctl setenv listener -t LANG=en

srvctl unsetenv listener [-l lsnr_name] [-t name]
srvctl unsetenv listener -t "TNS_ADMIN"




Database:
srvctl add database -d db_name -o ORACLE_HOME [-m domain_name][-p spfile] [-A name|ip/netmask]
[-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}]
[-s start_options] [-n db_name] [-y {AUTOMATIC|MANUAL}]
srvctl add database -d prod -o /u01/oracle/product/102/prod
  
srvctl remove database -d db_name [-f]
srvctl remove database -d prod

srvctl start database -d db_name [-o start_options] [-c connect_str|-q]
srvctl start database -d db_name [-o open]
srvctl start database -d db_name -o nomount
srvctl start database -d db_name -o mount

srvctl start db -d prod
srvctl start database -d apps -o open

srvctl stop database -d db_name [-o stop_options] [-c connect_str|-q]
srvctl stop database -d db_name [-o normal]
srvctl stop database -d db_name -o transactional
srvctl stop database -d db_name -o immediate
srvctl stop database -d db_name -o abort
srvctl stop db -d crm -o immediate

srvctl status database -d db_name [-f] [-v] [-S level]
srvctl status database -d db_name -v service_name

srvctl status database -d hrms

srvctl enable database -d db_name
srvctl enable database -d vis

srvctl disable database -d db_name
srvctl disable db -d vis

srvctl config database
srvctl config database -d db_name [-a] [-t]
srvctl config database
srvctl config database -d HYD -a

srvctl modify database -d db_name [-n db_name] [-o ORACLE_HOME] [-m domain_name] [-p spfile]
[-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-y {AUTOMATIC|MANUAL}]
srvctl modify database -d hrms -r physical_standby
srvctl modify db -d RAC -p /u03/oradata/RAC/spfileRAC.ora -- moves p file
srvctl modify database –d HYD –o /u01/app/oracle/product/11.1/db –s open

srvctl getenv database -d db_name [-t name_list]
srvctl getenv database -d prod

srvctl setenv database -d db_name {-t name=val[,name=val,...]|-T name=val}
srvctl setenv database –d HYD –t “TNS_ADMIN=/u01/app/oracle/product/11.1/asm/network/admin”
srvctl setenv db -d prod -t LANG=en

srvctl unsetenv database -d db_name [-t name_list]
srvctl unsetenv database -d prod -t CLASSPATH

In 11g Release 2, some command's syntax has been changed:
srvctl add database -d db_unique_name -o ORACLE_HOME [-x node_name] [-m domain_name] [-p spfile] [-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-t stop_options] [-n db_name] [-y {AUTOMATIC|MANUAL}] [-g server_pool_list] [-a "diskgroup_list"]
srvctl add database -d prod -o /u01/oracle/product/112/prod -m foo.com -p +dg1/prod/spfileprod.ora -r PRIMARY -s open -t normal -n db2 -y AUTOMATIC -g svrpool1,svrpool2 -a "dg1,dg2"

srvctl remove database -d db_unique_name [-f] [-y] [-v]
srvctl remove database -d prod -y

srvctl stop database -d db_unique_name [-o stop_options] [-f]
srvctl stop database -d dev -f

srvctl status database -d db_unique_name [-f] [-v]
srvctl status db -d sat -v

srvctl enable database -d db_unique_name [-n node_name]
srvctl enable database -d vis -n lnx01

srvctl disable database -d db_unique_name [-n node_name]
srvctl disable db -d vis -n lnx03

srvctl config database [-d db_unique_name [-a]]
srvctl config db -d db_erp -a

srvctl modify database -d db_unique_name [-n db_name] [-o ORACLE_HOME] [-u oracle_user] [-m domain] [-p spfile] [-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-t stop_options] [-y {AUTOMATIC|MANUAL}] [-g "server_pool_list"] [-a "diskgroup_list"|-z]
srvctl modify db -d prod -r logical_standby
srvctl modify database -d racTest -a "SYSFILES,LOGS,OLTP"

Instance:
srvctl add instance –d db_name –i inst_name -n node_name
srvctl add instance -d prod -i prod01 -n linux01
  
srvctl remove instance –d db_name –i inst_name [-f]
srvctl remove instance -d prod -i prod01

srvctl start instance -d db_name -i inst_names [-o start_options] [-c connect_str|-q]
srvctl start instance –d db_name –i inst_names [-o open]
srvctl start instance –d db_name –i inst_names -o nomount
srvctl start instance –d db_name –i inst_names -o mount

srvctl start instance –d dev -i dev2

srvctl stop instance -d db_name -i inst_names [-o stop_options] [-c connect_str|-q]
srvctl stop instance –d db_name –i inst_names [-o normal]
srvctl stop instance –d db_name –i inst_names -o transactional
srvctl stop instance –d db_name –i inst_names -o immediate
srvctl stop instance –d db_name –i inst_names -o abort

srvctl stop inst –d vis -i vis

srvctl status instance –d db_name –i inst_names [-f] [-v] [-S level]

srvctl status inst –d racdb -i racdb2

srvctl enable instance –d db_name –i inst_names
srvctl enable instance -d prod -i "prod1,prod2"

srvctl disable instance –d db_name –i inst_names
srvctl disable inst -d prod -i "prod1,prod3"

srvctl modify instance -d db_name -i inst_name {-s asm_inst_name|-r} -- set dependency of instance to ASM
srvctl modify instance -d db_name -i inst_name -n node_name -- move the instance
srvctl modify instance -d db_name -i inst_name -r -- remove the instance

srvctl getenv instance –d db_name –i inst_name [-t name_list]
srvctl setenv instance –d db_name [–i inst_name] {-t "name=val[,name=val,...]" | -T "name=val"}
srvctl unsetenv instance –d db_name [–i inst_name] [-t name_list]

In 11g Release 2, some command's syntax has been changed:
srvctl start instance -d db_unique_name {-n node_name -i "instance_name_list"} [-o start_options]
srvctl start instance -d prod -n node2
srvctl start inst -d prod -i "prod2,prod3"

srvctl stop instance -d db_unique_name {[-n node_name]|[-i "instance_name_list"]} [-o stop_options] [-f]
srvctl stop inst -d prod -n node1
srvctl stop instance -d prod -i prod1

srvctl status instance -d db_unique_name {-n node_name | -i "instance_name_list"} [-f] [-v]
srvctl status instance -d prod -i "prod1,prod2" -v

srvctl modify instance -d db_unique_name -i instance_name {-n node_name|-z}
srvctl modify instance -d prod -i prod1 -n mynode
srvctl modify inst -d prod -i prod1 -z


Service:
srvctl add service -d db_name -s service_name -r pref_insts [-a avail_insts] [-P TAF_policy]
srvctl add service -d db_name -s service_name -u {-r "new_pref_inst" | -a "new_avail_inst"}
srvctl add service -d RAC -s PRD -r RAC01,RAC02 -a RAC03,RAC04
srvctl add serv -d CRM -s CRM -r CRM1 -a CRM3 -P basic

srvctl remove service -d db_name -s service_name [-i inst_name] [-f]
srvctl remove serv -d dev -s sales
srvctl remove service -d dev -s sales -i dev01,dev02

srvctl start service -d db_name [-s service_names [-i inst_name]] [-o start_options]
srvctl start service -d db_name -s service_names [-o open]
srvctl start service -d db_name -s service_names -o nomount
srvctl start service -d db_name -s service_names -o mount
srvctl start serv -d dwh -s dwh

srvctl stop service -d db_name [-s service_names [-i inst_name]] [-f]
srvctl stop serv -d dwh -s dwh

srvctl status service -d db_name [-s service_names] [-f] [-v] [-S level]
srvctl status service -d dev -s dev

srvctl enable service -d db_name -s service_names [–i inst_name]
srvctl enable service -d apps -s apps1

srvctl disable service -d db_name -s service_names [–i inst_name]
srvctl disable serv -d dev -s dev -i dev1

srvctl config service -d db_name [-s service_name] [-a] [-S level]
srvctl config service -d db_name -a -- -a shows TAF configuration
srvctl config service -d TEST -s test PREF:TST1 AVAIL:TST2

srvctl modify service -d db_name -s service_name -i old_inst_name -t new_inst_name [-f]
srvctl modify service -d db_name -s service_name -i avail_inst_name -r [-f]
srvctl modify service -d db_name -s service_name -n -i preferred_list [-a available_list] [-f]
srvctl modify service -d db_name -s service_name -i old_inst_name -a avail_inst -P TAF_policy
srvctl modify serv -d PROD -s DWH -n -i I1,I2,I3,I4 -a I5,I6

srvctl relocate service -d db_name -s service_name –i old_inst_name -t target_inst [-f]

srvctl getenv service -d db_name -s service_name -t name_list
srvctl setenv service -d db_name [-s service_name] {-t "name=val[,name=val,...]" | -T "name=val"}
srvctl unsetenv service -d db_name -s service_name -t name_list

In 11g Release 2, some command's syntax has been changed:
srvctl add service -d db_unique_name -s service_name [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC|MANUAL}] [-q {true|false}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}][-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}][-z failover_retries] [-w failover_delay]
srvctl add service -d rac -s rac1 -q TRUE -m BASIC -e SELECT -z 180 -w 5 -j LONG

srvctl add service -d db_unique_name -s service_name -u {-r preferred_list | -a available_list}

srvctl add service -d db_unique_name -s service_name
-g server_pool [-c {UNIFORM|SINGLETON}] [-k network_number]
[-l [PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY]
[-y {AUTOMATIC|MANUAL}] [-q {TRUE|FALSE}] [-j {SHORT|LONG}]
[-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}]
[-m {NONE|BASIC}] [-P {BASIC|NONE|PRECONNECT}] [-x {TRUE|FALSE}]
[-z failover_retries] [-w failover_delay]

srvctl add service -d db_unique_name -s service_name -r preferred_list [-a available_list] [-P {BASIC|NONE|PRECONNECT}]
[-l [PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY]
[-y {AUTOMATIC|MANUAL}] [-q {TRUE|FALSE}] [-j {SHORT|LONG}]
[-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}]
[-m {NONE|BASIC}] [-x {TRUE|FALSE}] [-z failover_retries] [-w failover_delay]
srvctl add serv -d dev -s sales -r dev01,dev02 -a dev03 -P PRECONNECT

srvctl start service -d db_unique_name [-s "service_name_list" [-n node_name | -i instance_name]] [-o start_options]
srvctl start serv -d dev -s dev
srvctl start service -d dev -s dev -i dev2

srvctl stop service -d db_unique_name [-s "service_name_list"] [-n node_name | -i instance_name] [-f]
srvctl stop service -d dev -s dev
srvctl stop serv -d dev -s dev -i dev2

srvctl status service -d db_unique_name [-s "service_name_list"] [-f] [-v]
srvctl status service -d dev -s dev -v

srvctl enable service -d db_unique_name -s "service_name_list" [-i instance_name | -n node_name]
srvctl enable service -d dev -s dev
srvctl enable serv -d dev -s dev -i dev1

srvctl disable service -d db_unique_name -s "service_name_list" [-i instance_name | -n node_name]
srvctl disable service -d dev -s "dev,marketing"
srvctl disable serv -d dev -s dev -i dev1

srvctl config service -d db_unique_name [-s service_name] [-a]
srvctl config service -d dev -s dev

srvctl modify service -d db_unique_name -s service_name
[-c {UNIFORM|SINGLETON}] [-P {BASIC|PRECONNECT|NONE}]
[-l {[PRIMARY]|[PHYSICAL_STANDBY]|[LOGICAL_STANDBY]|[SNAPSHOT_STANDBY]} [-q {TRUE|FALSE}] [-x {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z failover_retries] [-w failover_delay] [-y {AUTOMATIC|MANUAL}]
srvctl modify service -d db_unique_name -s service_name -i old_instance_name -t new_instance_name [-f]
srvctl modify service -d db_unique_name -s service_name -i avail_inst_name -r [-f]
srvctl modify service -d db_unique_name -s service_name -n -i preferred_list [-a available_list] [-f]
srvctl modify service -d dev -s dev -i dev1 -t dev2
srvctl modify serv -d dev -s dev -i dev1 -r
srvctl modify service -d dev -s dev -n -i dev1 -a dev2

srvctl relocate service -d db_unique_name -s service_name {-c source_node -n target_node|-i old_instance_name -t new_instance_name} [-f]
srvctl relocate service -d dev -s dev -i dev1 -t dev3

Nodeapps:
#srvctl add nodeapps -n node_name -o ORACLE_HOME -A name|ip/netmask[/if1[|if2|...]]
#srvctl add nodeapps -n lnx02 -o $ORACLE_HOME -A 192.168.0.151/255.255.0.0/eth0

#srvctl remove nodeapps -n node_names [-f]

#srvctl start nodeapps -n node_name -- Starts GSD, VIP, listener & ONS

#srvctl stop nodeapps -n node_name [-r] -- Stops GSD, VIP, listener & ONS

#srvctl status nodeapps -n node_name

#srvctl config nodeapps -n node_name [-a] [-g] [-o] [-s] [-l]
-a Display VIP configuration
-g Display GSD configuration
-s Display ONS daemon configuration
-l Display listener configuration

#srvctl modify nodeapps -n node_name [-A new_vip_address]
#srvctl modify nodeapps -n lnx06 -A 10.50.99.43/255.255.252.0/eth0

#srvctl getenv nodeapps -n node_name [-t name_list]

#srvctl setenv nodeapps -n node_name {-t "name=val[,name=val,...]"|-T "name=val"}
#srvctl setenv nodeapps –n adcracdbq3 –t “TNS_ADMIN=/u01/app/oracle/product/11.1/asm/network/admin”

#srvctl unsetenv nodeapps -n node_name [-t name_list]

In 11g Release 2, some command's syntax has been changed:
srvctl add nodeapps -n node_name -A {name|ip}/netmask[/if1[|if2|...]] [-m multicast_ip_address] [-p multicast_port_number] [-l ons_local_port] [-r ons_remote-port] [-t host[:port][,host[:port],...]] [-v]
srvctl add nodeapps -S subnet/netmask[/if1[|if2|...]] [-d dhcp_server_type] [-m multicast_ip_address] [-p multicast_port_number] [-l ons_local_port] [-r ons_remote-port] [-t host[:port][,host[:port],...]] [-v]
#srvctl add nodeapps -n devnode1 -A 1.2.3.4/255.255.255.0

srvctl remove nodeapps [-f] [-y] [-v]
srvctl remove nodeapps

srvctl start nodeapps [-n node_name] [-v]
srvctl start nodeapps

srvctl stop nodeapps [-n node_name] [-r] [-v]
srvctl stop nodeapps

srvctl status nodeapps

srvctl enable nodeapps [-g] [-v]
srvctl enable nodeapps -g -v

srvctl disable nodeapps [-g] [-v]
srvctl disable nodeapps -g -v

srvctl config nodeapps [-a] [-g] [-s] [-e]
srvctl config nodeapps -a -g -s -e

srvctl modify nodeapps [-n node_name -A new_vip_address] [-S subnet/netmask[/if1[|if2|...]] [-m multicast_ip_address] [-p multicast_port_number] [-e eons_listen_port] [-l ons_local_port] [-r ons_remote_port] [-t host[:port][,host:port,...]] [-v]
srvctl modify nodeapps -n mynode1 -A 100.200.300.40/255.255.255.0/eth0

srvctl getenv nodeapps [-a] [-g] [-s] [-e] [-t "name_list"] [-v]
srvctl getenv nodeapps -a

srvctl setenv nodeapps {-t "name=val[,name=val][...]" | -T "name=val"} [-v]
srvctl setenv nodeapps -T "CLASSPATH=/usr/local/jdk/jre/rt.jar" -v

srvctl unsetenv nodeapps -t "name_list" [-v]
srvctl unsetenv nodeapps -t "test_var1,test_var2"

ASM:
srvctl add asm -n node_name -i asminstance -o ORACLE_HOME [-p spfile]

srvctl remove asm -n node_name [-i asminstance] [-f]
srvctl remove asm -n db6

srvctl start asm -n node_name [-i asminstance] [-o start_options] [-c connect_str|-q]
srvctl start asm -n node_name [-i asminstance] [-o open]
srvctl start asm -n node_name [-i asminstance] -o nomount
srvctl start asm -n node_name [-i asminstance] -o mount
srvctl start asm -n linux01

srvctl stop asm -n node_name [-i asminstance] [-o stop_options] [-c connect_str|-q]
srvctl stop asm -n node_name [-i asminstance] [-o normal]
srvctl stop asm -n node_name [-i asminstance] -o transactional
srvctl stop asm -n node_name [-i asminstance] -o immediate
srvctl stop asm -n node_name [-i asminstance]-o abort
srvctl stop asm -n racnode1
srvctl stop asm -n devnode1 -i +asm1

srvctl status asm -n node_name
srvctl status asm -n racnode1

srvctl enable asm -n node_name [-i asminstance]
srvctl enable asm -n lnx03 -i +asm3

srvctl disable asm -n node_name [-i asminstance]
srvctl disable asm -n lnx02 -i +asm2

srvctl config asm -n node_name
srvctl config asm -n lnx08

srvctl modify asm -n node_name -i asminstance [-o ORACLE_HOME] [-p spfile]
srvctl modify asm –n rac6 -i +asm6 –o /u01/app/oracle/product/11.1/asm

In 11g Release 2, some command's syntax has been changed:
srvctl add asm [-l lsnr_name] [-p spfile] [-d asm_diskstring]
srvctl add asm
srvctl add asm -l LISTENERASM -p +dg_data/spfile.ora

srvctl remove asm [-f]
srvctl remove asm -f

srvctl start asm [-n node_name] [-o start_options]
srvctl start asm -n devnode1

srvctl stop asm [-n node_name] [-o stop_options] [-f]
srvctl stop asm -n devnode1 -f

srvctl status asm [-n node_name] [-a]
srvctl status asm -n devnode1 -a

srvctl enable asm [-n node_name]
srvctl enable asm -n devnode1

srvctl disable asm [-n node_name]
srvctl disable asm -n devnode1

srvctl config asm [-a]
srvctl config asm -a

srvctl modify asm [-l lsnr_name] [-p spfile] [-d asm_diskstring]
srvctl modify asm [-n node_name] [-l listener_name] [-d asm_diskstring] [-p spfile_path_name]
srvctl modify asm -l lsnr1

srvctl getenv asm [-t name[, ...]]
srvctl getenv asm

srvctl setenv asm {-t "name=val [,...]" | -T "name=value"}
srvctl setenv asm -t LANG=en

srvctl unsetenv asm -t "name[, ...]"
srvctl unsetenv asm -t CLASSPATH

Listener:
srvctl add listener -n node_name -o ORACLE_HOME [-l listener_name] -- 11g R1 command

srvctl remove listener -n node_name [-l listener_name] -- 11g R1 command

srvctl start listener -n node_name [-l listener_names]
srvctl start listener -n node1

srvctl stop listener -n node_name [-l listener_names]
srvctl stop listener -n node1

srvctl status listener [-n node_name] [-l listener_names] -- 11g R1 command
srvctl status listener -n node2

srvctl config listener -n node_name

srvctl modify listener -n node_name [-l listener_names] -o ORACLE_HOME -- 11g R1command
srvctl modify listener -n racdb4 -o /u01/app/oracle/product/11.1/asm -l "LISTENER_RACDB4"

In 11g Release 2, some command's syntax has been changed:
srvctl add listener [-l lsnr_name] [-s] [-p "[TCP:]port[, ...][/IPC:key][/NMP:pipe_name][/TCPS:s_port] [/SDP:port]"] [-k network_number] [-o ORACLE_HOME]
srvctl add listener -l LISTENERASM -p "TCP:1522" -o $ORACLE_HOME
srvctl add listener -l listener112 -p 1341 -o /ora/ora112

srvctl remove listener [-l lsnr_name|-a] [-f]
srvctl remove listener -l lsnr01

srvctl stop listener [-n node_name] [-l lsnr_name] [-f]

srvctl enable listener [-l lsnr_name] [-n node_name]
srvctl enable listener -l listener_dev -n node5

srvctl disable listener [-l lsnr_name] [-n node_name]
srvctl disable listener -l listener_dev -n node5

srvctl config listener [-l lsnr_name] [-a]
srvctl config listener

srvctl modify listener [-l listener_name] [-o oracle_home] [-u user_name] [-p "[TCP:]port_list[/IPC:key][/NMP:pipe_name][/TCPS:s_port][/SDP:port]"] [-k network_number]
srvctl modify listener -n node1 -p "TCP:1521,1522"

srvctl getenv listener [-l lsnr_name] [-t name[, ...]]
srvctl getenv listener

srvctl setenv listener [-l lsnr_name] {-t "name=val [,...]" | -T "name=value"}
srvctl setenv listener -t LANG=en

srvctl unsetenv listener [-l lsnr_name] -t "name[, ...]"
srvctl unsetenv listener -t "TNS_ADMIN"

New srvctl commands in 11g Release 2

Diskgroup:
srvctl remove diskgroup -g diskgroup_name [-n node_list] [-f]
srvctl remove diskgroup -g DG1 -f

srvctl start diskgroup -g diskgroup_name [-n node_list]
srvctl start diskgroup -g diskgroup1 -n node1,node2

srvctl stop diskgroup -g diskgroup_name [-n node_list] [-f]
srvctl stop diskgroup -g ASM_FRA_DG
srvctl stop diskgroup -g dg1 -n node1,node2 -f

srvctl status diskgroup -g diskgroup_name [-n node_list] [-a]
srvctl status diskgroup -g dg_data -n node1,node2 -a

srvctl enable diskgroup -g diskgroup_name [-n node_list]
srvctl enable diskgroup -g diskgroup1 -n node1,node2

srvctl disable diskgroup -g diskgroup_name [-n node_list]
srvctl disable diskgroup -g dg_fra -n node1, node2

Home:
srvctl start home -o ORACLE_HOME -s state_file [-n node_name]
srvctl start home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt

srvctl stop home -o ORACLE_HOME -s state_file [-t stop_options] [-n node_name] [-f]
srvctl stop home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt

srvctl status home -o ORACLE_HOME -s state_file [-n node_name]
srvctl status home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt

ONS (Oracle Notification Service) :
srvctl add ons [-l ons-local-port] [-r ons-remote-port] [-t host[:port][,host[:port]...]] [-v]
srvctl add ons -l 6200

srvctl remove ons [-f] [-v]
srvctl remove ons -f

srvctl start ons [-v]
srvctl start ons -v

srvctl stop ons [-v]
srvctl stop ons -v

srvctl status ons

srvctl enable ons [-v]
srvctl enable ons

srvctl disable ons [-v]
srvctl disable ons

srvctl config ons

srvctl modify ons [-l ons-local-port] [-r ons-remote-port] [-t host[:port][,host[:port]...]] [-v]
srvctl modify ons

EONS:
srvctl add eons [-p portnum] [-m multicast-ip-address] [-e eons-listen-port] [-v]
#srvctl add eons -p 2018

srvctl remove eons [-f] [-v]
srvctl remove eons -f

srvctl start eons [-v]
srvctl start eons

srvctl stop eons [-f] [-v]
srvctl stop eons -f

srvctl status eons

srvctl enable eons [-v]
srvctl enable eons

srvctl disable eons [-v]
srvctl disable eons

srvctl config eons

srvctl modify eons [-m multicast_ip_address] [-p multicast_port_number] [-e eons_listen_port] [-v]
srvctl modify eons -p 2018

FileSystem:
srvctl add filesystem -d volume_device -v volume_name -g diskgroup_name [-m mountpoint_path] [-u user_name]
srvctl add filesystem -d /dev/asm/d1volume1 -v VOLUME1 -d RAC_DATA -m /oracle/cluster1/acfs1

srvctl remove filesystem -d volume_device_name [-f]
srvctl remove filesystem -d /dev/asm/racvol1

srvctl start filesystem -d volume_device_name [-n node_name]
srvctl start filesystem -d /dev/asm/racvol3

srvctl stop filesystem -d volume_device_name [-n node_name] [-f]
srvctl stop filesystem -d /dev/asm/racvol1 -f

srvctl status filesystem -d volume_device_name
srvctl status filesystem -d /dev/asm/racvol2

srvctl enable filesystem -d volume_device_name
srvctl enable filesystem -d /dev/asm/racvol9

srvctl disable filesystem -d volume_device_name
srvctl disable filesystem -d /dev/asm/racvol1

srvctl config filesystem -d volume_device_path

srvctl modify filesystem -d volume_device_name -u user_name
srvctl modify filesystem -d /dev/asm/racvol1 -u sysadmin

SrvPool:
srvctl add srvpool -g server_pool [-i importance] [-l min_size] [-u max_size] [-n node_list] [-f]
srvctl add srvpool -g SP1 -i 1 -l 3 -u 7 -n node1,node2

srvctl remove srvpool -g server_pool
srvctl remove srvpool -g srvpool1

srvctl status srvpool [-g server_pool] [-a]
srvctl status srvpool -g srvpool2 -a

srvctl config srvpool [-g server_pool]
srvctl config srvpool -g dbpool

srvctl modify srvpool -g server_pool [-i importance] [-l min_size] [-u max_size] [-n node_name_list] [-f]
srvctl modify srvpool -g srvpool4 -i 0 -l 2 -u 4 -n node3, node4

Server:
srvctl status server -n "server_name_list" [-a]
srvctl status server -n server11 -a

srvctl relocate server -n "server_name_list" -g server_pool_name [-f]
srvctl relocate server -n "linux1, linux2" -g sp2

Scan (Single Client Access Name):
srvctl add scan -n scan_name [-k network_number] [-S subnet/netmask[/if1[|if2|...]]]
#srvctl add scan -n scan.mycluster.example.com

srvctl remove scan [-f]
srvctl remove scan -f

srvctl start scan [-i ordinal_number] [-n node_name]
srvctl start scan -i 1 -n node1

srvctl stop scan [-i ordinal_number] [-f]
srvctl stop scan -i 1

srvctl status scan [-i ordinal_number]
srvctl status scan -i 1

srvctl enable scan [-i ordinal_number]
srvctl enable scan -i 1

srvctl disable scan [-i ordinal_number]
srvctl disable scan -i 3

srvctl config scan [-i ordinal_number]
srvctl config scan -i 2

srvctl modify scan -n scan_name
srvctl modify scan -n scan1

srvctl relocate scan -i ordinal_number [-n node_name]
srvctl relocate scan -i 2 -n node2

ordinal_number=1,2,3

Scan_listener:
srvctl add scan_listener [-l lsnr_name_prefix] [-s] [-p "[TCP:]port_list[/IPC:key][/NMP:pipe_name][/TCPS:s_port] [/SDP:port]"]
#srvctl add scan_listener -l myscanlistener

srvctl remove scan_listener [-f]
srvctl remove scan_listener -f

srvctl start scan_listener [-n node_name] [-i ordinal_number]
srvctl start scan_listener -i 1

srvctl stop scan_listener [-i ordinal_number] [-f]
srvctl stop scan_listener -i 3

srvctl status scan_listener [-i ordinal_number]
srvctl status scan_listener -i 1

srvctl enable scan_listener [-i ordinal_number]
srvctl enable scan_listener -i 2

srvctl disable scan_listener [-i ordinal_number]
srvctl disable scan_listener -i 1

srvctl config scan_listener [-i ordinal_number]
srvctl config scan_listener -i 3

srvctl modify scan_listener {-p [TCP:]port[/IPC:key][/NMP:pipe_name] [/TCPS:s_port][/SDP:port] | -u }
srvctl modify scan_listener -u

srvctl relocate scan_listener -i ordinal_number [-n node_name]
srvctl relocate scan_listener -i 1

ordinal_number=1,2,3

GNS (Grid Naming Service):
srvctl add gns -i ip_address -d domain
srvctl add gns -i 192.124.16.96 -d cluster.mycompany.com

srvctl remove gns [-f]
srvctl remove gns

srvctl start gns [-l log_level] [-n node_name]
srvctl start gns

srvctl stop gns [-n node_name [-v] [-f]
srvctl stop gns

srvctl status gns [-n node_name]
srvctl status gns

srvctl enable gns [-n node_name]
srvctl enable gns

srvctl disable gns [-n node_name]
srvctl disable gns -n devnode2

srvctl config gns [-a] [-d] [-k] [-m] [-n node_name] [-p] [-s] [-V] [-q name] [-l] [-v]
srvctl config gns -n lnx03

srvctl modify gns [-i ip_address] [-d domain]
srvctl modify gns -i 192.000.000.007

srvctl relocate gns [-n node_name]
srvctl relocate gns -n node2

VIP (Virtual Internet Protocol):
srvctl add vip -n node_name -A {name|ip}/netmask[/if1[if2|...]] [-k network_number] [-v]
#srvctl add vip -n node96 -A 192.124.16.96/255.255.255.0 -k 2

srvctl remove vip -i "vip_name_list" [-f] [-y] [-v]
srvctl remove vip -i "vip1,vip2,vip3" -f -y -v

srvctl start vip {-n node_name|-i vip_name} [-v]
srvctl start vip -i dev1-vip -v

srvctl stop vip {-n node_name|-i vip_name} [-r] [-v]
srvctl stop vip -n node1 -v

srvctl status vip {-n node_name|-i vip_name}
srvctl status vip -i node1-vip

srvctl enable vip -i vip_name [-v]
srvctl enable vip -i prod-vip -v

srvctl disable vip -i vip_name [-v]
srvctl disable vip -i vip3 -v

srvctl config vip {-n node_name|-i vip_name}
srvctl config vip -n devnode2

srvctl getenv vip -i vip_name [-t "name_list"] [-v]
srvctl getenv vip -i node1-vip

srvctl setenv vip -i vip_name {-t "name=val[,name=val,...]" | -T "name=val"}
srvctl setenv vip -i dev1-vip -t LANG=en

srvctl unsetenv vip -i vip_name -t "name_list" [-v]
srvctl unsetenv vip -i myvip -t CLASSPATH

OC4J (Oracle Container for Java):
srvctl add oc4j [-v]
srvctl add oc4j

srvctl remove oc4j [-f] [-v]
srvctl remove oc4j

srvctl start ocj4 [-v]
srvctl start ocj4 -v

srvctl stop oc4j [-f] [-v]
srvctl stop oc4j -f -v

srvctl status oc4j [-n node_name]
srvctl status oc4j -n lnx01

srvctl enable oc4j [-n node_name] [-v]
srvctl enable oc4j -n dev3

srvctl disable oc4j [-n node_name] [-v]
srvctl disable oc4j -n dev1

srvctl config oc4j

srvctl modify oc4j -p oc4j_rmi_port [-v]
srvctl modify oc4j -p 5385

srvctl relocate oc4j [-n node_name] [-v]
srvctl relocate oc4j -n lxn06 -v

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

crsctl stat res


crsctl stat res -w "TYPE = ora.acfs.type" -p   --- for detail 

crsctl stat res -w "TYPE = ora.acfs.type" -p | grep VOLUME
AUX_VOLUMES=
CANONICAL_VOLUME_DEVICE=/dev/asm/test-81
VOLUME_DEVICE=/dev/asm/test-81
AUX_VOLUMES=
CANONICAL_VOLUME_DEVICE=/dev/asm/test-81
VOLUME_DEVICE=/dev/asm/test-81


kfod status=TRUE asm_diskstring='ORCL:*' disks=all dscvgroup=TRUE




crsctl status res |grep -v "^$"|awk -F "=" 'BEGIN {print " "} {printf("%s",NR%4 ? $2"|" : $2"\n")}'|sed -e 's/  *, /,/g' -e 's/, /,/g' |awk -F "|" 'BEGIN { printf "%-40s%-35s%-20s%-50s\n","Resource Name","Resource Type","Target ","State" }{ split ($3,trg,",") split ($4,st,",")}{for (i in trg) {printf "%-40s%-35s%-20s%-50s\n",$1,$2,trg[i],st[i]}}'




Resource Name                           Resource Type                      Target              State
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)  ora.asm_listener.type              ONLINE              ONLINE on irac01
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)  ora.asm_listener.type              ONLINE              ONLINE on irac02
ora.DATA.TEST.advm                      ora.volume.type                    ONLINE              ONLINE on irac01
ora.DATA.TEST.advm                      ora.volume.type                    ONLINE              ONLINE on irac02
ora.DATA.dg(ora.asmgroup)               ora.diskgroup.type                 ONLINE              ONLINE on irac01

crsctl stat res -t -init
crsctl stat res -t -init|column -t
srvctl status asm 

srvctl status asm
ASM is running on ibrac02,ibrac01



1368695.1 – Oracle Clusterware logs and RDBMS logs rotation policy

[grid@ibrac01 crs]$ pwd
/u01/app/grid/diag/crs/brac01/crs

[grid@ibrac01 crs]$ ls -ltr
total 216
drwxrwxr-x 2 root oinstall       6 Feb  1  2018 metadata_dgif
drwxrwxr-x 2 root oinstall       6 Feb  1  2018 incpkg
drwxrwxr-x 2 root oinstall    4096 Jul 19  2018 metadata
drwxrwxr-x 5 root oinstall      61 May 31  2022 log
drwxrwxr-x 2 grid oinstall      89 Jun  7  2022 metadata_pv
drwxrwxr-x 2 root oinstall    4096 Jun  7  2022 sweep
drwxrwxr-x 2 root oinstall    4096 Jun  7  2022 lck
drwxrwxr-x 2 root oinstall       6 Jul  7  2022 cdump
drwxrwxr-x 2 root oinstall       6 Jun  8 01:40 stage
drwxrwxr-x 2 root oinstall       6 Jun  8 01:40 incident
drwxrwxr-x 2 root oinstall      20 Jul  5 01:40 alert
drwxrwxr-x 2 grid oinstall 2736128 Jul 27 08:24 trace
[grid@ibrac01 crs]$
 
/u01/app/grid/diag/crs/brac01/crs/trace
 trace]$ ls -ltr alert*
-rw-rw---- 1 root oinstall 382804617 Jul 23 05:38 alert.log

11gR2 Clusterware and Grid Home - What You Need to Know (Doc ID 1053147.1)

NOTE:810394.1 - RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent)
NOTE:1050693.1 - Troubleshooting 11.2 Clusterware Node Evictions (Reboots)
NOTE:1053970.1 - Troubleshooting 11.2 Grid Infrastructure root.sh Issues
NOTE:1054006.1 - CTSSD Runs in Observer Mode Even Though No Time Sync Software is Running

NOTE:184875.1 - How To Check The Certification Matrix for Real Application Clusters
NOTE:259301.1 - CRS and 10g/11.1 Real Application Clusters
NOTE:887522.1 - Grid Infrastructure Single Client Access Name (SCAN) Explained
NOTE:946332.1 - Unable To Create 10.1 or 10.2 or 11.1(< 11gR2) ASM RAC Databases (ORA-29702) Using Brand New 11gR2 Grid Infrastructure Installation .

Wednesday, 21 March 2012

Unix all open ports

Display list of all open ports

netstat -tulpn

Tuesday, 20 March 2012

ASM shell script add file

Oracle ASM add file ..

#!/usr/bin/ksh
clear
(
export ORACLE_SID=XYZ

print "Adding datafile to the tablespace\n"
sqlplus -s / as sysdba <<+
WHENEVER SQLERROR EXIT 1;
WHENEVER OSERROR EXIT 1;
ALTER TABLESPACE "ANUJ" ADD DATAFILE '+DATA' SIZE 2g AUTOEXTEND on;
+
)

=======

alter tablespace xxxx add datafile '+DATA' SIZE 2g AUTOEXTEND on;

alter tablespace xxxx add datafile '+DATA' size 1024m autoextend on maxsize unlimited;

set serveroutput on linesize 300

declare

v_stmt2 varchar2(600);

begin

FOR i IN 2..1023 loop

v_stmt2:= 'ALTER TABLESPACE ' ||'TX_DATA'|| ' ADD DATAFILE ' || '''+DATA'''|| ' SIZE 1m AUTOEXTEND on' ;

--dbms_output.put_line(v_stmt2);

execute immediate v_stmt2;

end loop;

end ;

ERROR at line 1:

ORA-01686: max # files (1023) reached for the tablespace TX_DATA

ORA-06512: at line 9

=====




alter tablespace TEST_DATA add datafile '+DATA/irac/test_data02.dbf' size 1G;

Tablespace altered.




datafile backup 

run {
        backup as compressed backupset
        incremental level 0
        format '/u01/irac/df_%T_@_%s_%p_%t'
        datafile 16
        include current controlfile
        ;
}


 alter session set nls_date_format='dd-mm-yyyy hh24:mi';
set linesize 300 pagesize 300
col unrecoverable_time for a25
col NAME for a70
select NAME,file#, unrecoverable_change#, unrecoverable_time,CREATION_TIME from v$datafile
where 1=1
and  unrecoverable_time is not null and unrecoverable_change# > 0
;


NAME                                                                        FILE# UNRECOVERABLE_CHANGE# UNRECOVERABLE_TIME        CREATION_TIME
---------------------------------------------------------------------- ---------- --------------------- ------------------------- ----------------
+DATA/irac/apex_data01.dbf                                                     2            2487391149 11-08-2023 22:00          06-06-2017 08:58

select df.*
from   v$datafile df, v$backup bk 
where  df.file#=bk.file# 
  and  df.unrecoverable_change# <> 0 
  and  df.UNRECOVERABLE_TIME >
   (select max(end_time)
    from   v$rman_backup_job_details
    where  input_type in ('DB FULL' ,'DB INCR')
   );

Anuj Singh Oracle DBA

Search This Blog

Total Pageviews