Thursday, 8 February 2018

https://knome.ultimatix.net/blogposts/410903-guj-rapdrp-technical-session-on-digital-machine-learning
https://knome.ultimatix.net/blogposts/398213-looking-for-opportunity-in-machine-learningdata-science
https://knome.ultimatix.net/blogposts/396888-want-associates-with-experience-in-machine-learning-with-python-immediate-requirement
https://knome.ultimatix.net/blogposts/377477-a-complete-tutorial-to-learn-data-science-with-python-from-scratch
https://knome.ultimatix.net/blogposts/376158-deep-learning-specialization-coursera
machine learning

Miscellenous

MAXQUERYLEN : Identifies the length of the longest query (in seconds) executed in the instance during the period. 
You can use this statistic to estimate the proper setting of the UNDO_RETENTION initialization parameter. 
The length of a query is measured from the cursor open time to the last fetch/execute time of the cursor. 
Only the length of those cursors that have been fetched/executed during the period are reflected in the view.

Query which orders the MAXQUERYLEN column of v$undostat data in descending order  .
 select *
from v$undostat us , v$sql s
where us.MAXQUERYID = s.sql_id 
order by  UNDOBLKS desc;
We can use maxqueryid column present in v$undostat to join with v$sql view in order to get sql query which is using undo space.
How do you get the undo usage ?
UNDOBLKS column present in the v$undostat gives the number of undo blocks are being used currently. you have to multiply with size of block to get the usage.


how total undo size is calculated.
Content column present in dba_tablespaces provides information regarding whether tablespace is a temporary tablespace , permanent tablespace or undo tablespaces.
there you can retrive all undo tablespaces.  sometimes tablespace may be offline . so filter only online undo tablespace using status column of dba_tablespaces
now I need all the datafiles associated to these undo tablespaces to get bytes or size of datafiles. this we can get from v$datafile but concern is v$datafile doesn't contain
any undotablespace name or any tablespace name . it contain tablespace number hence I need to combine tablespace_name of dba_tablespaces to name column of v$tablespace 
which contain tablespace name with it id. so here I am getting id of tablespace with I need to combine with v$datafile to get total bytes used for undo tablespace.




SQL> select sum(d.bytes) "undo"
  2  from v$datafile d,
  3  v$tablespace t,
  4  dba_tablespaces s
  5  where s.contents = 'UNDO'
  6  and s.status = 'ONLINE'
  7  and t.name = s.tablespace_name
  8  and d.ts# = t.ts#;

 UNDO
----------
 10485760




HOw do you check whether FTP is configured and running or not ?


I found that I have several services running related to ftp


cat /etc/services | grep ftp
ftp-data        20/tcp
ftp             21/tcp
tftp            69/udp
sftp            115/tcp
ftps-data       989/tcp                         # FTP over SSL (data)
ftps            990/tcp
venus-se        2431/udp                        # udp sftp side effect
codasrv-se      2433/udp                        # udp sftp side effect
frox            2121/tcp                        # frox: caching ftp proxy
zope-ftp        8021/tcp                        # zope management by ftp




The /etc/services file is used to tell what ports are standard for a given service. It does not mean that they are installed. If you look at the file, you can see that ftp data is transferred on port 21 using TCP and that port 21 is the standard ftp port and also uses TCP. It is a tool that client and servers can use to determine what ports to open for a connection. It is also a reference for administration purposes to know what service goes w/ what ports.

HTH

Forrest


/etc/services file contain service port number and protocol.

if you want to view running service use nmap or netstat command


netstat -antlp | grep ftp
tcp        0      0 0.0.0.0:21              0.0.0.0:*               LISTEN      26142/vsftpd


nmap localhost or IPADDRESS

Starting Nmap 4.62 ( http://nmap.org ) at 2010-07-18 13:12 PDT
Interesting ports on localhost (127.0.0.1):
Not shown: 1705 closed ports
PORT     STATE SERVICE
21/tcp   open  ftp
22/tcp   open  ssh
25/tcp   open  smtp
80/tcp   open  http
......
.....
....




[root@localhost ~]# find / -name groupadd 2>/null/dev
bash: /null/dev: No such file or directory
[root@localhost ~]# find / -name groupadd
/usr/sbin/groupadd
[root@localhost ~]# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/o/bin
[root@localhost ~]# set PATH=$PATH:groupadd -g 1200 asmadmin
[root@localhost ~]# groupadd -g 1201 asmdba
bash: groupadd: command not found
[root@localhost ~]# groupadd -g 1202 asmoper
bash: groupadd: command not found
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# set PATH=$PATH:/usr/sbin
[root@localhost ~]# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/o/bin
[root@localhost ~]# export PATH=$PATH:/usr/sbin
[root@localhost ~]# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/o/bin:/usr/sbin
[root@localhost ~]# groupadd -g 1200 asmadmin
[root@localhost ~]#


C100129463

CREATE SEQUENCE CA_PAID_LEAVERS.GENERATE_SCH_ID
  START WITH 6000
  MAXVALUE 9999999999999999999999999999
  MINVALUE 6000
  NOCYCLE
  CACHE 20
  ORDER;

select * from dba_tables where table_name=PS_LOCATION_TBL@;
select * from PS_LOCATION_TBL@HR8_SOURCE.NAT.BT.COM;
select * from dba_db_links;

PUBLIC
Specify PUBLIC to create a public database link visible to all users. If you omit this clause, then the database link is private and is available only to you.
The data accessible on the remote database depends on the identity the database link uses when connecting to the remote database:
  • If you specify CONNECT TO user IDENTIFIED BY password, then the database link connects with the specified user and password.
  • If you specify CONNECT TO CURRENT_USER, then the database link connects with the user in effect based on the scope in which the link is used.
  • If you omit both of those clauses, then the database link connects to the remote database as the locally connected user.


    SELECT name, value
    FROM gv$parameter

    WHERE (name LIKE '%link%')

    OR (name IN ('global_names', 'dblink_encrypt_login')); 
PS interface ?

    How do you reset essentials in workspace ?

    windows->workspace->reset essentials

  what is that 2 square brackets that is present at the bottom?

one is foreground color and other is background colour


what is color picker dialogue box ?


if you want exact colour of a things present in photo . how do u get that ?

eye dropper tool.


sometime you wanna to fill enter foreground or background with one colour then how do you achive that?

edit->fill->there u have options


what is the use of gradient tool?


how do make use rectangular marquee tool?


how to deselect selected area?

what is add to selection , subtract from selection, intersect  with selection?


where the brightness menu appears?

image--> brightness

what is revert and wr is  it?

select any image with rectangular maquee tool . go to select ---> modift --- feather .wht is the use of it?


wt is the use of load selection and save selection?


Peoplesoft


Components of a PeopleSoft System


 PeopleSoft is a chain of linked technologies that stretch between the user and the database.


The database is fundamental to the entire structure, but the technology stack stretches out through the BEA Tuxedo Application Server and the Java servlet to the user's browser


How do you memorise Peoplesoft Diagram ?


1) Peoplesoft schema it contains peoplesoft tables and application tables


of course who will monitor application tables.
Peoplesoft tools Application server 


there will be webserver it is java enabled web browser between the Internet browser and Peoplesoft tool application 


How people soft applications connect webserver . it is through Jolt and how webserver will connect to internet browser it is through HTTP.


what ever I have explained above is Application execution part . 


There are actually 2 parts 
1) application Execution part.
2) application Development part. 


Application development part also contains people soft  application server that server host application development tools. it is through Tuxedo

How do you search for a file.. in liux. 


There are 3 types 


1) using find command.


2) Using locate command


3)  which command


1)
$ find / -name uuencode 2>/dev/null
/usr/bin/uuencode


2) $ locate uuencode
/usr/bin/uuencode
/usr/share/man/man1/uuencode.1.gz
/usr/share/man/man1p/uuencode.1p.gz
/usr/share/man/man5/uuencode.5.gz




3)which uuencode


How to signal the end of stdin input in bash
















  • Ctrl+C sends a kill signal to the running process.
  • Ctrl+D sends an End of Transmission character.


  • How to get windows server uptime ?

    Event : Cache buffer chains



    how to replace gap between lines notepad++ 
    find - \r\n\r\n
    replace with - \r\n




           Following Text type are good in outlook :

    Gill SANS mt Microsoft new tai lue Microsoft tai le Microsoft yahei Dubai EBRIMA



    A look at world’s 100 most powerful technology companies



        Accenture (Ireland)
    2)      Acer (Taiwan)
        Adobe (US)
    4)      Advanced Micro Devices (AMD) (US)
    5)      Advantest (Japan)
    6)      Akamai Technologies (US)
    7)      Alphabet (US)
    8)      Amazon (US)
    9)      Amdocs (US)
    10)  Analog Devices (US)

    11)  Apple (US)
    12)  Applied Materials (US)
    13)  ARRIS International (US)
    14)  ASE Group (Taiwan)
    15)  ASM Pacific Technology (Hong Kong)
    16)  ASUS (Taiwan)
    17)  Atos (France)
    18)  Autodesk (US)
    19)  CA Technologies (US)
    20)  Canon (Japan)
    21)  Capgemini (France)
    22)  Celestica (Canada)
    23)  CGI (Canada)
    24)  Cisco (US)
    25)  Cognizant (US)
    26)  CommScope (US)
    27)  Computacenter (UK)
    28)  Computershare (Australia)
    29)  dormakaba (Switzerland)
    30)  DXC Technology (US)
    31)  eBay Inc. (US)
    32)  Ericsson (Sweden)
    33)  Facebook (US)
    34)  FUJIFILM (Japan)
    35)  Fujikura Ltd. (Japan)
    36)  Fujitsu Ltd. (Japan)
    37)  Gemalto (Netherlands)
    38)  HCL Technologies Ltd. (India)
    39)  Hewlett Packard Enterprise (US)
    40)  HP (US)
    41)  IBM (US)
    42)  Infineon Technologies (Germany)
    43)  Infosys (India)
    44)  Intel (US)
    45)  Intuit (US)
    46)  Lam Research (US)
    47)  Leidos (US)
    48)  Lenovo (China)
    49)  LG Electronics (Korea; Republic (S. Korea)
    50)  LITE-ON Technology (Taiwan)
    51)  ManTech International Corporation (US)
    52)  Mastercard (US)
    53)  Micron Technology (US)
    54)  Microsoft (US)
    55)  Motorola Solutions (US)
    56)  Nanya Technology (Taiwan)
    57)  National Instruments (US)
    58)  NCR Corporation (US)
    59)  NEC (Japan)
    60)  Nokia (Finland)
    61)  Nvidia (US)
    62)  NXP Semiconductors (Netherlands)
    63)  OKI Electric Industry Co., Ltd. (Japan)
    64)  ON Semiconductor (US)
    65)  Oracle (US)
    66)  PEGATRON Corporation (Taiwan)
    67)  Powertech Technology Inc. (Taiwan)
    68)  Qisda Corporation (Taiwan)
    69)  Qualcomm (US)
    70)  Quanta Computer (Taiwan)
    71)  Renesas Electronics Corporation (Japan)
    72)  ROHM (Japan)
    73)  Salesforce (US)
    74)  Samsung Electronics (Korea; Republic S. Korea)
    75)  SAP (Germany)
    76)  Seiko Epson Corporation (Japan)
    77)  Sharp Corporation (Japan)
    78)  Siliconware Precision Industries Ltd. (SPIL) (Taiwan)
    79)  SK Hynix Inc (Korea; Republic S. Korea)
    80)  Sony (Japan)
    81)  Sopra Steria (France)
    82)  STMicroelectronics (Switzerland)
    83)  Symantec Corporation (US)
    84)  Taiwan Semiconductor Manufacturing Co., Ltd. (TSMC) (Taiwan)
    85)  Tata Consultancy Services (India)
    86)  Tech Mahindra (India)
    87)  Tencent (China)
    88)  Teradata (US)
    89)  Texas Instruments (US)



    https://www.linkedin.com/pulse/linkedin-top-companies-2018-where-india-wants-work-now-abhigyan-chand/?trk=li_fb_apac-in_bcs_topcompanies18_facebook_blogpaid&utm_campaign=topcompanies18&utm_medium=social&utm_source=facebook&utm_content=blogpaid







       

    Monday, 5 February 2018

    blogger



    https://www.youtube.com/watch?v=-QKaaxMyrs0&t=7s ---- > how to set Home page in blogger

    create a post or page with subject welcome - save , publish and cancel .

    go to Setting-Preference->custom redirect-edit

    For ex : http://rocky-dba.blogspot.in/2018/03/welcome.html

    in from field just put -- /


    in "To" filed place = /2018/03/welcome.html


    How to add in label in Google .?

    Open Gmail in browser , click on 3 lines that you see at left top corner , it gives names of all labels. Go down to bottom . Click on desktop view , once you see desktop view , you can go to label section , there you see edit lable option , click on it and add label


    how to add css and html
    https://www.youtube.com/watch?v=24QmGjcqIiw


    http://freefrontend.com/css-tabs/ --- SAMPLE CSS CODES

    LINUX

    To change hostname:

    https://superuser.com/questions/451082/redhat-enterprise-linux-6-edit-hostname


    -------------------------------------
    xming and x11 forwarding for putty :

    if you are installing oracle software , then x11 forwarding for putty and xming software should be running.

    1) First start the xming with value 0 .
    2) open putty --> left side --> click on connection--->ssh-->X11---> check "enable x11 forwarding"--> x display locatoin = localhost:0 and go to session , enter ip address and save setting.
    3) open putty and test by entering xclock. it was working.

    when xclock was working , I check display variable both as oracle user and root user it was set to "localhost:10.0" , not sure how it got set to 10.0

    [root@PRIMARY ~]# echo $DISPLAY
    localhost:10.0



    https://www.youtube.com/watch?v=CoN3nbB4tQc -- > for setting display
    ==============================================================
    shutdown -h now as root user to shut down the linux.

    reboot is for restart

    ------------------

    how to replace words in vi editor.

    :%s/DGDB1/DGDB2/g


    how to copy folder from server to server using SCP.
    scp -r DGDB1 OELSTN:/oracle/oradata/fra

    Thursday, 1 February 2018

    Performance issue ,

    what do you check from performance wise.?

    if you understand clearly OS watcher and TFA clearly , you find most of the performance details.



    here is a link :

    TFaa- https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=574621158717715&parent=OSwatcher&sourceId=download&id=1513912.1&_afrWindowMode=0&_adf.ctrl-state=9z0rzmbu9_173

    oswatcer : https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=574953915811780&parent=DOCUMENT&sourceId=301137.1&id=1531223.1&_afrWindowMode=0&_adf.ctrl-state=9z0rzmbu9_202
    -------------------


    First check how many inactive session are present , check fragmentation details , blocking sessions. stale statistics , index usable or unsable.

    check listeners logs if there is any client time out issues.

    /var/adm/syslog/syslog.log - For RAC issue , need to check syslogs.

    check  application cpu, memeory etc..
    (Did you check the listener log at the time the client was having time out issues?)

    check if any tables or indexes in stale status , static details in Last Analyesed and dba_tab_modifications



    oradebug setmypid 
    oradebug unlimit 
    oradebug -g all hanganalyze 3 
    wait 30 seconds 
    oradebug -g all hanganalyze 3 
    wait 30 seconds 
    oradebug -g all dump systemstate 258 
    wait 30 seconds 
    oradebug -g all dump systemstate 258 
    exit  

    Can I have this details?
    1. How long does the job take to complete under normal run?
    2. How long it too now when performance is bad?
    3. From when job is experiencing slow performance?
    4. When was the last time job completed within excepted time?
    5. What is the frequency of the job(daily, weekly) run? For all the runs does the job run at same time of the day?
    6. Was there any code change ,change in data volume or any changes we should be aware off?

    Mon Jan 08 15:21:21 2018
    Errors in file /u01/app/oracle/admin/PIDSD/diag/rdbms/pidsd/PIDSD/trace/PIDSD_ctwr_7471.trc  (incident=128315):
    ORA-04031: unable to allocate 13508456 bytes of shared memory ("large pool","unknown object","large pool","CTWR dba buffer")
    Incident details in: /u01/app/oracle/admin/PIDSD/diag/rdbms/pidsd/PIDSD/incident/incdir_128315/PIDSD_ctwr_7471_i128315.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Mon Jan 08 15:22:44 2018
    ORA-04031 heap dump being written to trace file /u01/app/oracle/admin/PIDSD/diag/rdbms/pidsd/PIDSD/incident/incdir_128315/PIDSD_ctwr_7471_i128315.trc
    Mon Jan 08 15:27:18 2018
    minact-scn: got error during useg scan e:12751 usn:5
    minact-scn: useg scan erroring out with error e:12751
    Mon Jan 08 15:32:35 2018
    minact-scn: got error during useg scan e:12751 usn:5
    minact-scn: useg scan erroring out with error e:12751
    Mon Jan 08 15:35:52 2018
    Thread 1 cannot allocate new log, sequence 54390
    Private strand flush not complete
      Current log# 2 seq# 54389 mem# 0: /u02/origlog/PIDSD/PIDSDredo_t1_g2_m1.dbf
      Current log# 2 seq# 54389 mem# 1: /u02/mirrlog/PIDSD/PIDSDredo_t1_g2_m2.dbf

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




    lan0 is down, please bring it up.

    g1u3750c:12102/bin $ oifcfg getif
    lan0  15.69.32.0  global  public
    lan1  15.69.132.0  global  cluster_interconnect
    lan2  15.69.132.0  global  cluster_interconnect

    ifconfig lan0

    [‎08-‎01-‎2018 07:54 PM]
    g1u3750c:12102/bin $ ifconfig lan0
    lan0: flags=a000000000001842<BROADCAST,RUNNING,MULTICAST,CKO,TSO,PORT>
            inet 0.0.0.0 netmask 0




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

    Things to be check if there is any issue.

    Node health check - CPU , Memmory ,  DISK, Network.,load average.

    server up time ,logs



    Tuesday, 23 January 2018

    ORACLE MISCELLANEOUS

    ORACLE MISCELLANEOUS

    When you use DIRECT=Y this causes export to extract data by reading the data directly, bypassing the SQL Command Processing layer. This method can be much faster than a conventional path export.

    Conventional path export uses the SQL SELECT statement to extract data from tables. Data is read from disk into a buffer cache, and rows are transferred to the evaluating buffer. The data, after passing expression evaluation, is transferred to the export client, which then writes the data into the export file.

    In a direct path export, data is read from disk into the buffer cache and rows are transferred directly to the export client. The evaluating buffer is bypassed. The data is already in the format that export expects, thus avoiding unnecessary data conversion. The data is transferred to the export client, which then writes the data into the export file.


    [23/10, 18:31] ‪+91 88845 46426‬: How to reduce sysaux tablespace occupancy due to fragmented tables and indexes, could you please suggest me
    [23/10, 19:09] ‪+91 96996 17243‬: Doc id-1029252.6
    [23/10, 19:09] ‪+91 96996 17243‬: Check this
    [23/10, 19:10] ‪+91 96996 17243‬: Also check 1965061.1 and 287679.1
    [23/10, 19:10] ‪+91 96996 17243‬: You can also rebuild indexes

    [24/10, 13:37] ‪+91 82372 03726‬: I have a below table having two columns.
    GENDER   NAME
    M                 A
    F                 B
    F                 C
    M                D

    I need o/p like-
    Name1   Name2
    A              B
    D              C
    [24/10, 13:38] ‪+91 82372 03726‬: solve it
    [24/10, 15:06] ‪+91 94715 28382‬: Use self join

    Very good document for undo retention.

    https://community.oracle.com/community/support/support-blogs/database-support-blog/blog/2015/12/10/ora-1555-do-you-know-how-to-resolve-this-issue

    https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:275215756923

    DB upgrade
    http://dbaclass.com/article/upgrade-database-from-11g-to-12c-manually/


    $ find . -name oraenv -print
    ./11204/bin/oraenv



    if database is down , what and all you check

    1st one is alert log and 2nd one is  server up time.




    To get Oracle Dumps :

    http://srimahesh-world.blogspot.in/2013/07/1z0-053-dump-free-download-oracle-11g.html?m=1

    To get all dumps :

    www.ora-certification.com

    Demonstration of Linux Io

    https://haydenjames.io/linux-server-performance-disk-io-slowing-application/

    http://www.informit.com/articles/article.aspx?p=481867

    You will get all DBA scripts.
    http://itexpert-tech.com/oracle-database-administration-scripts-dba-bundle/

    Rman scenario :
    My requirement was to restore the RMAN backup in another server. At the time of restore i need only one tablespace need to restore because to export the deleted table.

    Did any one have document plz share to my email id: ravipatisrinath@gmail.com



    g1u2560c:home/oracle $ oerr ora 01677
    01677, 00000, "standby file name convert parameters differ from other instance"
    // *Cause: The DB_FILE_STANDBY_NAME_CONVERT or LOG_FILE_STANDBY_NAME_CONVERT
    //         initialization parameters are not the same as in other instances
    //         that already have the database mounted.
    // *Action: Change initialization parameters DB_FILE_STANDBY_NAME_CONVERT and
    //          LOG_FILE_STANDBY_NAME_CONVERT to match other instances.
    g1u2560c:home/oracle $

    http://oracle-dba-quickanswers.blogspot.com/2012/01/startup-of-rac-database-fails-with-ora.html



    https://www.youtube.com/watch?v=CoN3nbB4tQc --> How to set display variable for oracle installation.


    https://docs.oracle.com/cd/E19421-01/820-5016/ggxof/index.html ---> oracle dataguard

    https://asktom.oracle.com/pls/asktom/f%3Fp%3D100:11:0::::P11_QUESTION_ID:5081036300346841765 ---> difference between static listener and dynamic listener. Why static listeners are needed for oracle dataguard.


    http://www.dbaces.com/database-consulting-and-projects/database-performance-assessment-and-tuning - database tuning.

    http://www.dbaces.com/resources/knowledge-base/112-oracle-listener-registration - excellent for static listeners and dynamic listeners.

    how to create and add block values to table.


    CREATE TABLE EVENTS(
      EVENTID INTEGER NOT NULL,
      SOURCE VARCHAR2(50 ),
      TYPE VARCHAR2(50 ),
      EVENT_DATE DATE,
      DESCRIPTION VARCHAR2(100 )
    )
    /


    INSERT INTO EVENTS (EVENTID, "SOURCE", TYPE, EVENT_DATE, DESCRIPTION)
    SELECT level, level, 'warning',
            TO_DATE(TRUNC(DBMS_RANDOM.VALUE(TO_CHAR(DATE '2000-01-01','J') ,TO_CHAR(DATE '9999-12-31','J'))),'J')
            ,dbms_random.value(1,100)
      FROM DUAL
    CONNECT BY LEVEL <= 1000;


    insert into scott.dept values(&num,'&name','&loc');


    http://rocky-dba.blogspot.in/2017/12/blog-post.html

    how to track alert log file.

    http://www.oracle-ckpt.com/tracking-alert-log-file-by-xdbgalertext/

    http://www.oracle-ckpt.com/table-fragmentation/

    http://www.oracle-ckpt.com/database-administration/

    http://www.oracle-ckpt.com/cpu-usage-queries/

    http://www.oracle-ckpt.com/scripts-for-locks-and-blocking-sessions/

    http://www.oracle-ckpt.com/unixos-scripts/

    http://www.oracle-ckpt.com/snapshot-workload-repository-retention/



    http://oraclerac-rips.blogspot.in/2012/11/tuning-oracle-disk-io-asm-configuration.html -- good


    how to check ORA error solution using Oerr utility...

    g1u3536:db_2/dbs $ oerr rman 06429
    6429, 1, "%s database is not compatible with this version of RMAN"
    // *Cause:  The indicated database is not compatible with this version of
    //          the Recovery Manager (RMAN).  Other messages have also
    //          been issued which detail the cause of the error.
    // *Action: See the other messages.  If the database is CATALOG, then you may
    //          be able to use the CREATE CATALOG or UPGRADE CATALOG commands
    //          to correct the problem.  If the database is TARGET or AUXILIARY,
    //          then you must either upgrade the target database or use a
    //          newer version of the RMAN executable.


    https://blog.dbi-services.com/querying-the-oracle-management-repository/ -- OEM


    https://web.stanford.edu/dept/itss/docs/oracle/10gR2/backup.102/b14191/osrecov005.htm - restoring control files.


    _______________________________________


    HTTP protocol
    Hypertext Transfer Protocol. A protocol that provides the language that enables Web browsers and application Web servers to communicate


    WebDAV protocol
    World Wide Web Distributed Authoring and Versioning. A protocol with a set of extensions to the HTTP protocol which allows users to manage files on remote Web servers.


    An Oracle database is represented to clients as a service; that is, the database performs work on behalf of clients. A database can have one or more services associated with it.


    To connect to a database service, clients use a connect descriptor that provides the location of the database and the name of the database service. 



    (DESCRIPTION= 
      (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
      (CONNECT_DATA=
        (SERVICE_NAME=sales.us.acme.com)))
    



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

    IM25957160

    02/18/2018 18:23:36 US/Central (john.headley@hpe.com):
    gvu0599.austin.hp.com is not a server it is an oracle vip.  Please check from your end as it is supposed to be up on g1u0523c.

    g1u0525c:home/oracle $ srvctl status nodeapps -n g1u0523c
    Network is enabled
    Network is running on node: g1u0523c
    GSD is disabled
    GSD is not running on node: g1u0523c
    ONS is enabled
    ONS daemon is running on node: g1u0523c
    PRKO-2165 : VIP does not exist on node(s) : g1u0523c

    g1u0525c:home/oracle $ srvctl status nodeapps -n g1u0525c
    VIP gvu0600.austin.hp.com is enabled
    VIP gvu0600.austin.hp.com is running on node: g1u0525c
    Network is enabled
    Network is running on node: g1u0525c
    GSD is disabled
    GSD is not running on node: g1u0525c
    ONS is enabled
    ONS daemon is running on node: g1u0525c
    g1u0525c:home/oracle $ srvctl status nodeapps -n g1u0524c
    VIP gvu0601.austin.hp.com is enabled
    VIP gvu0601.austin.hp.com is running on node: g1u0524c
    Network is enabled
    Network is running on node: g1u0524c
    GSD is disabled
    GSD is not running on node: g1u0524c
    ONS is enabled
    ONS daemon is running on node: g1u0524c
    g1u0525c:home/oracle $ srvctl status nodeapps -n g1u0526c
    VIP gvu0602.austin.hp.com is enabled
    VIP gvu0602.austin.hp.com is running on node: g1u0526c
    Network is enabled
    Network is running on node: g1u0526c
    GSD is disabled
    GSD is not running on node: g1u0526c
    ONS is enabled
    ONS daemon is running on node: g1u0526c
    >>>>>>>>>>>>>>>>>>>>>>>>>

    02/18/2018 17:29:20 US/Central (murillo-alvarez@hpe.com):
    Hello team

    mentioned gvu0599 package is not listed in cluster:

    g1u0523c:home/murilloa $ cmviewcl

    CLUSTER        STATUS
    gvc10523       up

      NODE           STATUS       STATE
      g1u0523c       up           running
      g1u0525c       up           running
      g1u0524c       up           running

        PACKAGE           STATUS           STATE            AUTO_RUN    NODE
        gvu0599-b         up               running          disabled    g1u0524c
        gvu0600-b         up               running          disabled    g1u0524c

      NODE           STATUS       STATE
      g1u0526c       up           running

        PACKAGE           STATUS           STATE            AUTO_RUN    NODE
        gvu0601-b         up               running          enabled     g1u0526c
        gvu0602-b         up               running          enabled     g1u0526c

    MULTI_NODE_PACKAGES

      PACKAGE           STATUS           STATE            AUTO_RUN    SYSTEM
      SG-CFS-pkg        up               running          enabled     yes
      SG-CFS-DG02-ORA   up               running          enabled     no
      SG-CFS-DG03-ORA   up               running          enabled     no
      SG-CFS-DG04-ORA   up               running          enabled     no
      SG-CFS-DG05-ORA   up               running          enabled     no
      SG-CFS-DG06-ORA   up               running          enabled     no
      SG-CFS-DG07-ORA   up               running          enabled     no
      SG-CFS-DG08-ORA   up               running          enabled     no
      SG-CFS-DG10-ORA   up               running          enabled     no
      crsp              up               running          enabled     no


    NSLOOKUP detects an IP and resolves the name:

    Default Server:  resolver.hp.net
    Address:  16.110.135.52

     gvu0599.austin.hp.com
    Server:  resolver.hp.net
    Address:  16.110.135.52

    Non-authoritative answer:
    Name:    gvu0599.austin.hp.com
    Address:  16.236.21.103

     16.236.21.103
    Server:  resolver.hp.net
    Address:  16.110.135.52

    Name:    gvu0599.austin.hp.com
    Address:  16.236.21.103


    C:\Users\mjorgeal>ping 16.236.21.103

    Pinging 16.236.21.103 with 32 bytes of data:
    Control-C

    but no ping or ssh  connectivity

    that IP is also not listed in the active NICs:

    g1u0523c:home/murilloa $ netstat -in
    Name      Mtu  Network         Address         Ipkts              Ierrs Opkts              Oerrs Coll
    lan0:1    1500 16.236.20.0     16.236.21.89    25104              0     18356              0     0
    lan13:80  1500 169.254.0.0     169.254.35.122  0                  0     0                  0     0
    Warning: The above name 'lan13:801' is truncated, use -w to show the output in wide format
    lan11     1500 16.237.0.0      16.237.2.74     144293             0     10797              0     0
    lan9*     1500 none            none            0                  0     0                  0     0
    lan8*     1500 none            none            0                  0     0                  0     0
    lan0      1500 16.236.20.0     16.236.21.58    9794480            0     13415338           0     0
    lo0      32808 127.0.0.0       127.0.0.1       688638             0     688659             0     0
    lan13     1500 16.236.240.0    16.236.240.93   13876714           0     13859223           0     0


    There are any entries for that package in log files:

    g1u0523c:home/murilloa $ tail -f /var/adm/syslog/syslog.log  | grep 16.236.21.103
    g1u0523c:home/murilloa $ tail  /var/adm/syslog/syslog.log  | grep 16.236.21.103
    g1u0523c:home/murilloa $ tail  /var/adm/syslog/syslog.log  | grep gvu0599
    g1u0523c:home/murilloa $


    Please check

    Thanks
    >>>>>>>>>>>>>>>>>>>>>>>>>

    02/18/2018 22:28:32 Greenwich/Universal (HPOO):
    |OO - 077 - Automated Lean Dispatcher~ Run ID 10584088|
    >>>>>>>>>>>>>>>>>>>>>>>>>

    02/18/2018 16:24:24 US/Central (gusdlt92@hpe.com):
    bundle lean (itio use only)
    >>>>>>>>>>>>>>>>>>>>>>>>>

    02/18/2018 22:23:46 Greenwich/Universal (HPOO):
    |OO - 080 - Lean Interaction IM Elevation~ Incident generated per Lean SD Elevation SCR ruleID (32) SCR comparator runID (10584063)|
    Service Recipient: rakesh.karam@hp.com
    Contact: rakesh.karam@hp.com
    ${theJournal}
    >>>>>>>>>>>>>>>>>>>>>>>>>
    02/21/18 08:01:49 Greenwich/Universal (sla):
    TTF - Low - Normal - Inc has hit 50% warning level
    02/22/18 17:10:05 Greenwich/Universal (sla):
    TTF - Low - Normal - Inc has been breached



    -------------------------------------------


    change permision of oracle directory or binary files and check what errors you get


    -------------------------------------------------------------------------------------------



    Subramanian, Saravanan
      1* select owner,index_name ,index_type from  dba_indexes where table_name='CORETRA'
    SQL> /

    OWNER                          INDEX_NAME                     INDEX_TYPE
    ------------------------------ ------------------------------ ---------------------------
    WSSDBA                         CORETRA_KEY                    NORMAL
    04:30
    Subramanian, Saravanan 11:58 AM:

    GDBA to rebuild index of CORETRA

    George Peter, Nishant ((IS DBA Services)) 12:21 PM:

    rebuid of WSSDBA.CORETRA_KEY  is completed
    04:30
    IM25988046
    04:31
    IM26007169
    04:35

    ALTER INDEX WSSDBA.CORETRA_KEY REBUILD ONLINE PARALLEL 32;


    ALTER INDEX WSSDBA.CORETRA_KEY REBUILD PARALLEL 32;


    select owner, index_name, table_name, status, degree from dba_indexes where index_name='CORETRA_KEY';

    27 February 2018Karam, Rakesh (IS DBA Services)Hey .. Manoj ,
    04:46TUesday and wednesday
    04:46L3 people wont prepare HO..
    04:46again I have to prepare for those day..
    04:47Vakamalla, Manoj Reddy (IS DBA Services)Thursday and Friday who prepared then ?
    04:47Karam, Rakesh (IS DBA Services)ok
    04:48let it be
    04:48Vakamalla, Manoj Reddy (IS DBA Services)If you have problem in prepring HO. No issues. yes or no should do bro.
    No need all the details.
    04:48you have to rebuild the index with no parallel again
    04:57Karam, Rakesh (IS DBA Services)Bro... Ok .. will prepare , you dont do.
    04:58Bro... Ok .. will prepareHO , you dont do.

    04:58Why No parallel ?
    04:58agian
    04:58again
    04:58Vakamalla, Manoj Reddy (IS DBA Services)I've already started HO
    No issues you leave it.
    04:59select owner, index_name, table_name, status, degree from dba_indexes where index_name='&index_name';
    04:59
    run this and enter index name
    04:59
    and then give me the output
    04:59
    Karam, Rakesh (IS DBA Services)
    SQL> select owner, index_name, table_name, status, degree from dba_indexes where index_name='CORETRA_KEY';

    OWNER                          INDEX_NAME
    ------------------------------ ------------------------------
    TABLE_NAME                     STATUS   DEGREE
    ------------------------------ -------- ----------------------------------------
    WSSDBA                         CORETRA_KEY
    CORETRA                        VALID    32
    05:00
     ---------------------------------------------------------------------------Vakamalla, Manoj Reddy (IS DBA Services)
    alter index WSSDBA.CORETRA_KEY noparallel;
    05:01
    run this now
    05:01
    and then again run below query.

    select owner, index_name, table_name, status, degree from dba_indexes where index_name='CORETRA_KEY';

    05:01
    then send me the output.
    05:02
    Karam, Rakesh (IS DBA Services)
    SQL> alter index WSSDBA.CORETRA_KEY noparallel;

    Index altered.

    SQL> select owner, index_name, table_name, status, degree from dba_indexes where index_name='CORETRA_KEY';

    OWNER                          INDEX_NAME
    ------------------------------ ------------------------------
    TABLE_NAME                     STATUS   DEGREE
    ------------------------------ -------- ----------------------------------------
    WSSDBA                         CORETRA_KEY
    CORETRA                        VALID    1


    SQL>
    05:02
    Vakamalla, Manoj Reddy (IS DBA Services)
    got it ?
    05:02
    Karam, Rakesh (IS DBA Services)
    Number of threads per instance for scanning the index

    05:03
    Degree means Number of threads per instance for scanning the index

    05:04
    If degree is more ,then index scanning wil be faster right
    05:04
    ?
    05:04
    Vakamalla, Manoj Reddy (IS DBA Services)
    When you see at the degree column, the value was 32 as you ran the index with 32 parallel. So, everytime a query uses this index, it will fetch the data in 32 parallel.
    So, it will use lot of resources and keep much load on DB.
    So, unless we keep the noparallel, it will be running in parallel and cause performance issues.
    05:04
    we need to run the rebuild index in parallel and again in no parallel.
    05:05
    to rebuild alone, we need to use parallel. So, once the rebuild is completed, we will make it to no parallel and just as single instance.

    05:05
    Karam, Rakesh (IS DBA Services)
    Ok Thanks
    05:05
    Vakamalla, Manoj Reddy (IS DBA Services)
    Np!
    05:05

    ====================
    query to check instance start time.

    SQL> select STARTUP_TIME,INSTANCE_NAME from v$instance;

    INSTANCE_NAME             HOST_NAME      STARTUP_TIME
    CRNAP3               g1u3764c            2/24/2018 4:39:45 PM
    CRNAP2               g1u3763c            8/26/2017 7:55:57 AM
    CRNAP1               g1u3762c            8/24/2017 9:00:54 AM


    http://www.oracle.com/technetwork/articles/linux/saternos-scripting-088882.html - Oracle techniques for shell scripting.



    Background


    Different processes such as lmon, lmd, and lms communicate with corresponding processes on other instances, so when the instance and database hang, those processes may be waiting for a resource such as a latch, an enqueue, or a data block.  Those processes that are waiting can not respond to the network ping or send any communication over the network to the remote instances.  As a result, other instances evict the problem instance.

    You may see a message similar to the following in the alert.log of the instance that is evicting another instance:
    Remote instance kill is issued [112:1]: 8
    or
    Evicting instance 2 from cluster

    Query to check if data is increased recently in the tables.

    SELECT
    --SS.BEGIN_INTERVAL_TIME,
    SS. END_INTERVAL_TIME,
    STAT.SQL_ID,
    PLAN_HASH_VALUE,
    EXECUTIONS_TOTAL Executions,
    -- round(ELAPSED_TIME_DELTA/1000/1000/60) Ela_time_delta_min,
    round(ELAPSED_TIME_TOTAL/1000/1000/60) Ela_time_total_min,
    --round(CPU_TIME_DELTA/1000/1000/60) CPU_time_min,
    ROWS_PROCESSED_TOTAL ROWS_PROCESSED,
    BUFFER_GETS_TOTAL BUFFER_GETS,
    --round(decode(ROWS_PROCESSED_DELTA,O,BUFFER_GETS_DELTA,BUFFER_GETS_DELTA/ROWS_PROCESSED_DELTA)) BLOCKS_PER_ROW, DISK_READS_TOTAL DISK_READS,
    SQL_PROFILE
    FROM DBA_HIST_SQLSTAT STAT, DBA_HIST_SQLTEXT TXT, DBA_HIST_SNAPSHOT SS
    WHERE STAT.SQL_ID = TXT.SQL_ID AND STAT.DBID = TXT.DBID
    AND SS.DBID = STAT.DBID AND SS. INSTANCE_NUMBER = STAT.INSTANCE_NUMBER
    AND STAT.SNAP_ID = SS.SNAP_ID
    --AND SS. BEGIN_INTERVAL_TIME >= sysdate-60
    AND UPPER(STAT.SQL_ID) = upper('&SQL_ID')
    ORDER BY SS. END_INTERVAL_TIME desc,
    ELAPSED_TIME_DELTA desc;

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

    http://www.dba-oracle.com/art_oramag_rac_taf.htm

    Oracle RAC and Hardware Failover
    To detect a node failure, the Cluster Manager uses a background process?Global Enqueue Service Monitor (LMON)?to monitor the health of the cluster. When a node fails, the Cluster Manager reports the change in the cluster's membership to Global Cache Services (GCS) and Global Enqueue Service (GES). These services are then re-mastered based on the current membership of the cluster.
    To successfully re-master the cluster services, Oracle RAC keeps track of all resources and resource states on each node and then uses this information to restart these resources on a backup node.

    These processes also manage the state of in-flight transactions and work with TAF to either restart or resume the transactions on the new node. Now let's see how Oracle RAC and TAF work together to ensure that a server failure does not cause an unplanned service interruption.


    http://www.orafaq.com/node/1840  -- Oracle connection is explained well



    Thursday, 28 December 2017

    Blocking query sessions
    how to get PID from SID
    sqlId from sid.
    sql text from sqlid
    how to kill session.
    locked object
    how to check how many sessions are running for same users.

    Blocking session query.
    ----------------------------

    SELECT DECODE (l.BLOCK, 0, 'Waiting', 'Blocking ->') user_status
    ,CHR (39) || s.SID || ',' || s.serial# || CHR (39) sid_serial
    ,(SELECT instance_name FROM gv$instance WHERE inst_id = l.inst_id)
    conn_instance
    ,s.SID
    ,s.PROGRAM
    ,s.osuser
    ,s.machine
    ,DECODE (l.TYPE,'RT', 'Redo Log Buffer','TD', 'Dictionary'
    ,'TM', 'DML','TS', 'Temp Segments','TX', 'Transaction'
    ,'UL', 'User','RW', 'Row Wait',l.TYPE) lock_type
    --,id1
    --,id2
    ,DECODE (l.lmode,0, 'None',1, 'Null',2, 'Row Share',3, 'Row Excl.'
    ,4, 'Share',5, 'S/Row Excl.',6, 'Exclusive'
    ,LTRIM (TO_CHAR (lmode, '990'))) lock_mode
    ,ctime
    --,DECODE(l.BLOCK, 0, 'Not Blocking', 1, 'Blocking', 2, 'Global') lock_status
    ,object_name
    FROM
    gv$lock l
    JOIN
       gv$session s
    ON (l.inst_id = s.inst_id
    AND l.SID = s.SID)
    JOIN gv$locked_object o
    ON (o.inst_id = s.inst_id
    AND s.SID = o.session_id)
    JOIN dba_objects d
    ON (d.object_id = o.object_id)
    WHERE (l.id1, l.id2, l.TYPE) IN (SELECT id1, id2, TYPE
    FROM gv$lock
    WHERE request > 0)
    ORDER BY id1, id2, ctime DESC;


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

    2)

    set lines 200 pages 200
    select l1.inst_id,l1.sid, ' IS BLOCKING ', l2.sid,l1.type,l2.type,l1.lmode,l2.lmode,l2.inst_id
    from gv$lock l1, gv$lock l2
    where l1.block =1 and l2.request > 0
    and l1.id1=l2.id1
    and l1.id2=l2.id2;


    3)


    Wait time in seconds

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

    set lines 200 pages 200

    col wait_class for a10

    col MACHINE for a10

    col EVENT for a10

    col USERNAME for a10

    col MACHINE for a10

    col status for a10



    select

       blocking_session,blocking_instance, inst_id,

       sid,

       serial#,

       USERNAME, status,

       SQL_ID,

       wait_class,

       MACHINE,

       seconds_in_wait

    from

       gv$session

    where

       blocking_session is not NULL and seconds_in_wait >100

    order by

       seconds_in_wait;
    ===============================================================



    How to get PID from SID:

    ------------------------

    col sid format 999999

    col username format a20

    col osuser format a15

    select a.sid, a.serial#,a.username, a.osuser, b.spid

    from v$session a, v$process b

    where a.paddr= b.addr

    and a.sid='&sid'

    order by a.sid;





    SQLID from SID

    -------------------------------------

    column plsql_entry_object_id format 99999 heading c1

    column plsql_entry_subprogram_id format 99999 heading c2

    column plsql_object_id format 99999 heading c3

    column plsql_subprogram_id format 99999 heading c4

    select t1.sql_id,( select t2.sql_fulltext from v$sql t2 where t1.sql_id = t2.sql_id and t1.sql_child_number = t2.child_number ) sql_fulltext,
    ( select t2.sql_fulltext
    from v$sql t2
    where t1.prev_sql_id = t2.sql_id and
    t1.prev_child_number = t2.child_number ) prev_sql_fulltext,
    plsql_entry_object_id,
    plsql_entry_subprogram_id,
    plsql_object_id,
    plsql_subprogram_id
    from v$session t1
    where sid = 201 ;

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

    select sql_text from v$sql where sql_id = 'a7u3m7hf3w3y4' ;


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

    select distinct(username) from gv$session;
    select count(*) , username from gv$session group by username;


    Locked object :

    TO single database.
    ------------------
    select
       c.owner,
       c.object_name,
       c.object_type,
       b.sid,
       b.serial#,
       b.status,
       b.osuser,
       b.machine
    from
       v$locked_object a ,
       v$session b,
       dba_objects c
    where
       b.sid = a.session_id
    and
       a.object_id = c.object_id;





    To RAC database.
    =============

    select
       c.owner,
       c.object_name,
       c.object_type,
       b.INST_ID,
       b.sid,
       b.serial#,
       b.status,
       b.osuser,
       b.machine
    from
       gv$locked_object a ,
       gv$session b,
       dba_objects c
    where
       b.sid = a.session_id
    and
       a.object_id = c.object_id;




    following error occurs,if there is any locked objects.
    Error starting at line : 1 in command -
    DROP INDEX sys.TQD_QUEUE_KEY_BM_IDX
    Error report -
    SQL Error: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
    00054. 00000 -  "resource busy and acquire with NOWAIT specified or timeout expired"
    *Cause:    Interested resource is busy.
    *Action:   Retry if necessary or increase timeout.

    Tuesday, 19 December 2017

    https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmbackp.htm - FOr BACKUP topics user official site.

    RMAN catalog and RMAN stored script.

    Reference : http://www.oracle.com/technetwork/issue-archive/2009/09-sep/o59recovery-085185.html.

    https://docs.oracle.com/cd/B14117_01/server.101/b10734/rcmcnctg.htm#1008104.


    RMAN> list script names;

    List of Stored Scripts in Recovery Catalog


        Global Scripts


           Script Name
           Description
           -----------------------------------------------------------------------
           archive_bck_del

           archive_bck_no_del

           full_archive_delete

           global_medfull_level0

           global_smallfull_level0


    RMAN> print Global Script archive_bck_del
    2> ;

    printing stored global script: archive_bck_del
    {
    backup Archivelog ALL
    skip inaccessible
    format='Arch_Delete_%d_%s_%p.dbf'
    filesperset=20
    delete input;
    }

    RMAN> print Global Script archive_bck_no_del
    2> ;

    printing stored global script: archive_bck_no_del
    {
    backup Archivelog ALL
    skip inaccessible
    format='Arch_NoDelete_%d_%s_%p.dbf'
    filesperset=20;
    }

    RMAN> print Global Script full_archive_delete;

    printing stored global script: full_archive_delete
    {
    backup Archivelog ALL
    format='Arch_Delete_%d_%s_%p.dbf'
    skip inaccessible
    filesperset=20
    delete input
    not backed up 2 times;
    }

    RMAN> print Global Script global_medfull_level0;

    printing stored global script: global_medfull_level0
    {
       execute global script global_smallfull_level0;
    }

    RMAN> print global script global_smallfull_level0
    2> ;

    printing stored global script: global_smallfull_level0
    {
         backup incremental level 0
         format='Small_Full_BCK_%d_%s_%p.dbf'
         database
         filesperset = 10;
    }


    RMAN> show all
    2> ;

    RMAN configuration parameters for database with db_unique_name PDMLI are:
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 45 DAYS;
    CONFIGURE BACKUP OPTIMIZATION ON;
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO 'control_file_%F';
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u07/app/oracle/arch/PDMLI/RMAN/%d-%T_%F';
    CONFIGURE DEVICE TYPE DISK PARALLELISM 16 BACKUP TYPE TO BACKUPSET;
    CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so';
    CONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 4;
    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/reorg/PDMLI/backups/snapcf_PDMLI.f';


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

    OMNI Backup tool:


    /opt/omni/bin/omnirpt -report dl_info -tab | grep <dbname>

    ex : g2u2554g:rdbms/log $ /opt/omni/bin/omnirpt -report dl_info -tab | grep PIDSI
    Oracle8 Backup  B1_g2u2554g_PIDSI_F             oracle.dba@g2u2554g.austin.hpicorp.net  -       -
    Oracle8 Backup  B1_g2u2554g_PIDSI_log_del               oracle.dba@g2u2554g.austin.hpicorp.net  -       -

    g2u2554g:rdbms/log $ /opt/omni/bin/omnirpt -rep dl_sched -tab|grep -i PIDSI
    Oracle8 Backup  B1_g2u2554g_PIDSI_F             12/15/17 15:45:00       1513352700 2017-12-15 15:45:00  full
    Oracle8 Backup  B1_g2u2554g_PIDSI_log_del               12/10/17 21:45:00       1512942300 2017-12-10 21:45:00  full


    g2u2554g:rdbms/log $ rman target /

    Recovery Manager: Release 12.1.0.2.0 - Production on Sun Dec 10 06:29:28 2017

    Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

    connected to target database: PIDSI (DBID=1923135860)

    RMAN> exit


    Recovery Manager complete.
    g2u2554g:rdbms/log $ /opt/omni/lbin/util_cmd -getmethod Oracle8 1923135860
    DB_NAME='PIDSI';
    CLIENT=('g2u2554g.austin.hpicorp.net%PIDSI');
    TGT_NLS_LANG='AMERICAN_AMERICA.AL32UTF8';
    CATALOG={
            CATALOG_DB_VERSION='11.2.0.3.0';
            RCPasswd='FHBBEHBBEHBBQGBBDIBBOHBBCHBBPHBB';
            RC_NLS_LANG='AMERICAN_AMERICA.AL32UTF8';
            RCService='AUSRCII';
            RCUser='RMAN_PIDSI';
            HOST_NAME='';
    };


    rman target omnibackup/omni_PIDSI@PIDSI catalog RMAN_PIDSI/dcc_rman@AUSRCII

    /opt/omni/bin/omnidb -ses -data "B1_g2u2554g_PIDSI_log_del" -last 15

    nohup /opt/omni/bin/omnib -oracle8_list B1_g2u2554g_PIDSI_log_del -protect > /tmp/B1_g2u2554g_PIDSI_log_del &(This one was not working)


    nohup /opt/omni/bin/omnib -oracle8_list B1_g2u2554g_PIDSI_log_del  -protect days 15 > /tmp/B1_g2u2554g_PIDSI_log_del &


    Backup issue:
    ============

    /opt/omni/bin/omnirpt -rep dl_sched -tab|grep -i YESNO2I

    /opt/omni/bin/omnirpt -report dl_info -tab | grep YESNO2I


    execute sys.dbms_backup_restore.resetcfilesection(9);

    /opt/omni/lbin/util_cmd -getmethod Oracle8  331502902 ---- what is the use of this command  --- 1923135860

    /opt/omni/lbin/util_cmd -getmethod Oracle8 1143709814

    rman target omnibackup/omni_PDMLI@PDMLI catalog RMAN_PDMLI/dcc_rman@AUSRCII

    rman target omnibackup/omni_MA9@MA9 catalog rman_MA9/dcc_rman@AUSRCIP

    rman target omnibackup/omni_D7C@D7C catalog RMAN_D7C/dcc_rman@AUSRC3P




    /opt/omni/bin/omnidb -ses -data "S2S_B1_synchpdb_SYNCHP_F" -last 15

    nohup /opt/omni/bin/omnib -oracle8_list S2S_V1_wcsdelpdb_WCSDELP_F > /tmp/S2S_V1_wcsdelpdb_WCSDELP_F &

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

    To check backup SPEC related to particular DB
    -------------------------------------------------------
    /opt/omni/bin/omnirpt -report dl_info -tab | grep TRSTGP

     find . -name "HOUCM1Sarch_*.dbf" -mtime +10 -exec ll {} \;


    To check last 15 days backup status
    -------------------------------------------
    /opt/omni/bin/omnidb -ses -data "Oracle8 S2S_V1_wcsautpdb_WCSAUTP_log_del" -last 15

    /opt/omni/bin/omnidb -ses -data "Oracle8 B1_gvu10887_RDSP_F" -last 15

    S2S_B1_trstgpdb_TRSTGP_log_del

    To check backup Log
    -------------------------
    /opt/omni/bin/omnidb –ses 2017/07/11-792 -report

    /opt/omni/bin/omnidb –details 2017/07/06-683 -re

    To run backup manually
    -----------------------------
    nohup /opt/omni/bin/omnib -oracle8_list B1_dbcift6-inc_FT6_I -protect > /tmp/B1_dbcift6-inc_FT6_I & ( this one was not working )

    nohup /opt/omni/bin/omnib -oracle8_list B1_g2u2554g_PIDSI_log_del -protect > /tmp/B1_g2u2554g_PIDSI_log_del &

    nohup /opt/omni/bin/omnib -oracle8_list B1_gvu10584_AUIARC1I_log_del -protect days 15 > /tmp/B1_gvu10584_AUIARC1I_log_del &

    B1_gvu4902_TRLIV1P_log_del

    To delete applied archive logs at Standby DB
    ------------------------------------------------------
    ksh /u01/app/oracle/admin/scripts/Applied_log_on_standby_delete.ksh

    ksh /home/oracle/Applied_log_on_standby_delete.ksh
    -------------------------------------------------------------------

    backup
    ====


    col STATUS format a9
    col hrs format 999.99
    select SESSION_KEY, INPUT_TYPE, STATUS,
    to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
    to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,
    elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS
    order by session_key;


    SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE='OMNIBACKUP';

    GRANT DBA TO OMNIBACKUP;