Hi all , On one RS/6000 Box , i am not using Tivoli`s scheduler., Instead I use maestro scheduler . It executes script which shut downs the oracle database.. Performs backups --and brings oracle up.. for some reason the database does not come up from last week , and has to start manually .. While doing so it gives some problems. Here is the log of backup at the end of it you will see some errors. I don't know where to look for these errors in TSM, Oracle or AIX? Thanks Shekhar .. medrs2:more O46854.0115 =============================================================== = JOB : MEDRS2#WKLYRS2.RS2BKUP = USER : root = JCLFILE : /usr/tivoli/tsm/client/ba/bin/rs2script = Job Number: 46854 = Mon Mar 12 01:15:17 EST 2001 =============================================================== MAESTRO for UNIX/JOBMANRC 6.1 (C) Tivoli Systems Inc. 1998 Starting /maestro/jobmanrc /usr/tivoli/tsm/client/ba/bin/rs2script MAESTRO for UNIX (AIX)/JOBINFO 6.1 (9.3) (C) Tivoli Systems Inc. 1998 Installed for group 'DEFAULT'. Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options PL/SQL Release 8.1.5.0.0 - Production SVRMGR> Connected. SVRMGR> Database closed. Database dismounted. ORACLE instance shut down. SVRMGR> 115 (1%) Server Manager complete. Database "ACWQ" shut down. O46854.0115 (2%) Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options PL/SQL Release 8.1.5.0.0 - Production SVRMGR> Connected. SVRMGR> Database closed. Database dismounted. ORACLE instance shut down. SVRMGR> Server Manager complete. Database "ACWT" shut down. Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation. All Rights Reserved. Node Name: MEDRS2 Session established with server TSM: AIX-RS/6000 Server Version 3, Release 7, Level 4.0 Server date/time: 03/12/01 01:17:35 Last access: 03/11/01 03:51:51 Incremental backup of volume '/' Incremental backup of volume '/usr' Incremental backup of volume '/var' Incremental backup of volume '/home' Incremental backup of volume '/ora01' Incremental backup of volume '/ora02' Incremental backup of volume '/ora03' O46854.0115 (10%) Incremental backup of volume '/ora04' Incremental backup of volume '/ora05' Incremental backup of volume '/ora06' Incremental backup of volume '/maestro' Incremental backup of volume '/tsm' Incremental backup of volume '/tsmpool' Incremental backup of volume '/tsmdb' Incremental backup of volume '/tsmdb1' Incremental backup of volume '/tsmdata' ANS1898I ***** Processed 1,000 files ***** Directory--> 1,536 / [Sent] Normal File--> 712 /bosinst.data [Sent] Normal File--> 20,552 /dsmerror.log [Sent] Normal File--> 6,380 /image.data [Sent] Special File--> 0 /dev/fd0 [Sent] Special File--> 0 /dev/mt0 [Sent] Special File--> 0 /dev/mt1 [Sent] Retry # 1 Normal File--> 1,390 /maestro/stdlist/2001.03.11/NETMAN [ Sent] Retry # 1 Normal File--> 1,281 /maestro/stdlist/2001.03.11/O40184.0 425 [Sent] Retry # 1 Normal File--> 42,722 /maestro/stdlist/2001.03.11/O45034.0 115 [Sent] Retry # 1 Normal File--> 32,735 /maestro/stdlist/2001.03.12/O46854.0 115 [Sent] Successful incremental backup of '/maestro' Successful incremental backup of '/tsm' Successful incremental backup of '/tsmpool' Successful incremental backup of '/tsmdb' Successful incremental backup of '/tsmdb1' O46854.0115 (82%) Successful incremental backup of '/tsmdata' Total number of objects inspected: 64,270 Total number of objects backed up: 297 Total number of objects updated: 0 Total number of objects rebound: 0 Total number of objects deleted: 0 Total number of objects expired: 20 Total number of objects failed: 0 Total number of bytes transferred: 26.07 GB Data transfer time: 5,628.10 sec Network data transfer rate: 4,858.98 KB/sec Aggregate data transfer rate: 3,370.30 KB/sec Objects compressed by: 0% Elapsed processing time: 02:15:14 SQL*Plus: Release 8.1.5.0.0 - Production on Mon Mar 12 03:32:53 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Total System Global Area 193621124 bytes Fixed Size 64644 bytes Variable Size 126275584 bytes Database Buffers 67108864 bytes Redo Buffers 172032 bytes Database mounted. Database opened. SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.0 - Productio n46854.0115 (91%) With the Partitioning and Java options PL/SQL Release 8.1.5.0.0 - Production Database "TDMSX" warm started. SQL*Plus: Release 8.1.5.0.0 - Production on Mon Mar 12 03:33:39 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. SQL> Connected to an idle instance. SQL> ORACLE instance started. Total System Global Area 193621124 bytes Fixed Size 64644 bytes Variable Size 126275584 bytes Database Buffers 67108864 bytes Redo Buffers 172032 bytes Database mounted. Database opened. SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.0 - Productio n With the Partitioning and Java options PL/SQL Release 8.1.5.0.0 - Production Database "TDMS2D" warm started. LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.5.0.0 - Production on 12-MAR-0 1 03:33:46 (c) Copyright 1998 Oracle Corporation. All rights reserved. Starting /ora01/app/oracle/product/8.1.5/bin/tnslsnr: please wait... TNSLSNR for IBM/AIX RISC System/6000: Version 8.1.5.0.0 - Production System parameter file is /ora01/app/oracle/product/8.1.5/network/admin/listener. ora Log messages written to /ora01/app/oracle/product/8.1.5/network/log/listener.log Listening on: (DESCRIPTION=(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))(ADDRE SS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Listening on: (DESCRIPTION=(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))(ADDRE SS=(PROTOCOL=TCP)(HOST=medrs2)(PORT=1521))) Connecting to (DESCRIPTION=(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))(ADDRE SS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for IBM/AIX RISC System/6000: Version 8.1.5.0. 0 - Production Start Date 12-MAR-01 03:33:47 Uptime 0 days 0 hr. 0 min. 2 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /ora01/app/oracle/product/8.1.5/network/admin/listener .ora Listener Log File /ora01/app/oracle/product/8.1.5/network/log/listener.l og Services Summary... ACWQ has 1 service handler(s) ACWT has 1 service handler(s) CCDWD has 1 service handler(s) OEM has 1 service handler(s) PLSExtProc has 1 service handler(s) TDMS2D has 1 service handler(s) TDMS2T has 1 service handler(s) TDMSD has 1 service handler(s) TDMST has 1 service handler(s) TDMSTBU has 1 service handler(s) TDMSX has 1 service handler(s) test has 1 service handler(s) The command completed successfully Oracle Names Control for IBM/AIX RISC System/6000: Version 8.1.5.0.0 - Productio n on 12-MAR-01 03:33:50 (c) Copyright 1997 Oracle Corporation. All rights reserved. Currently managing name server "NS1.medf.bayer.com" Version banner is "Oracle Names for IBM/AIX RISC System/6000: Version 8.1.5.0.0 - Production" Starting "/ora01/app/oracle/product/8.1.5/bin/names"...server not started, error s follow NNC-00002: error listening on stream (ADDRESS=(PROTOCOL=TCP)(HOST=medrs2.medf.ba yer.com)(PORT=1575)) TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use IBM/AIX RISC System/6000 Error: 6 =============================================================== = Exit Status : 0 = System Time (Seconds) : 862 Elapsed Time (Minutes) : 138 = User Time (Seconds) : 120 = Mon Mar 12 03:33:51 EST 2001 =============================================================== medrs2: rpcinfo -p | grep 1575