Amazon Partner

Tuesday, 21 October 2014

ORA-01033 when connecting to PDB, Pluggable Database ORACLE initialization or shutdown in progress


ORA-01033: ORACLE initialization or shutdown in progress 

ORA-01033: ORACLE initialization or shutdown in progress
01033. 00000 -  "ORACLE initialization or shutdown in progress"
*Cause:    An attempt was made to log on while Oracle is being started up
           or shutdown.

*Action:   Wait a few minutes. Then retry the operation.

Thursday, 16 October 2014

Upload was successful but collections currently disabled - disk full

oracle@dbserver1:/u01/app/oracle/diag> emctl status agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 11.1.0.1.0
OMS Version       : 11.1.0.1.0
Protocol Version  : 11.1.0.0.0
Agent Home        : /u01/app/oracle/product/agent11g
Agent binaries    : /u01/app/oracle/product/agent11g
Agent Process ID  : 25212
Parent Process ID : 25185
Agent URL         : https://dbserver1.oraukint.local:3872/emd/main/
Repository URL    : https://oemserver.orauk.local:1159/em/upload
Started at        : 2014-10-16 15:01:19
Started by user   : oracle
Last Reload       : 2014-10-16 15:16:26
Last successful upload                       : 2014-10-16 15:12:51
Total Megabytes of XML files uploaded so far :    25.58
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :     3.97%
Collection Status                            : Disabled by Upload Manager
Last successful heartbeat to OMS             : 2014-10-16 15:17:58
---------------------------------------------------------------
Agent is Running and Ready
oracle@dbserver1:/u01/app/oracle/diag> emctl  upload agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
EMD upload error: Upload was successful but collections currently disabled - disk full


oracle@dbserver1:/>cd $ORACLE_HOME/config

grep -i  DiskUsedPct emd.properties
UploadMaxDiskUsedPct=98
UploadMaxDiskUsedPctFloor=98



oracle@dbserver1:/u01/app/oracle/product/agent11g/sysman/config> bdf .
Filesystem          kbytes    used   avail %used Mounted on
/dev/vg01/lvol1    52424704 45984123 6440581   99% /u01

Solution:-

- As we can clearly see disk utilization is above the defined limit in emd.properties.

Clear space from /u01 filesystem where agent is installed.
restart agent 
emctl stop agent
emctl start agent.


oracle@dbserver1:/u01/app/oracle/product/agent11g/sysman/config> emctl stop agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
Stopping agent ... stopped.
oracle@dbserver1:/u01/app/oracle/product/agent11g/sysman/config> emctl start agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
Starting agent ............................. started.
oracle@dbserver1:/u01/app/oracle/product/agent11g/sysman/config> emctl status agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 11.1.0.1.0
OMS Version       : 11.1.0.1.0
Protocol Version  : 11.1.0.0.0
Agent Home        : /u01/app/oracle/product/agent11g
Agent binaries    : /u01/app/oracle/product/agent11g
Agent Process ID  : 350
Parent Process ID : 325
Agent URL         : 
https://dbserver1.oraukint.local:3872/emd/main/
Repository URL    : 
https://oemserver.orauk.local:1159/em/upload
Started at        : 2014-10-16 15:33:17
Started by user   : oracle
Last Reload       : 2014-10-16 15:33:17
Last successful upload                       : 2014-10-16 15:34:23
Total Megabytes of XML files uploaded so far :     0.15
Number of XML files pending upload           :        0
Size of XML files pending upload(MB)         :     0.00
Available disk space on upload filesystem    :    26.32%
Last successful heartbeat to OMS             : 2014-10-16 15:34:14
---------------------------------------------------------------
Agent is Running and Ready