Shut down Oracle database..

[root@db01]# su - oracleSun Microsystems Inc. SunOS 5.9 Generic May 2002

/* stop the listener */
[oracle@db01]$ lsnrctl stop
LSNRCTL for Solaris: Version 9.2.0.5.0 - Production on 12-JUL-2007 14:39:08
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db01)(PORT=1521)))The command completed successfully

/* connect to database as SYSDBA */
[oracle@db01]$ sqlplus '/as SYSDBA'
SQL*Plus: Release 9.2.0.5.0 - Production on Thu Jul 12 14:41:50 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.5.0 - Production
/* shutdown the database */
SQL> shutdown immediate
Database closed.Database dismounted.ORACLE instance shut down.SQL> exitDisconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.5.0 -

/* stop GSD */
Production[oracle@db01]$ gsdctl stop

/** Reverse to start */
[oracle@db01]$ gsdctl start
Successfully started GSD on local node

/* connect to database as SYSDBA */
[oracle@db01]$ sqlplus '/as SYSDBA'
SQL*Plus: Release 9.2.0.5.0 - Production on Thu Jul 12 15:04:10 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
/* start database */
SQL> startup
ORACLE instance started.
Total System Global Area 4296515640 bytesFixed Size 737336 bytesVariable Size 4261412864 bytesDatabase Buffers 33554432 bytesRedo Buffers 811008 bytesDatabase mounted.Database opened.SQL> exitDisconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.5.0 - Production
/* start listener */
[oracle@db01]$ lsnrctl start
LSNRCTL for Solaris: Version 9.2.0.5.0 - Production on 12-JUL-2007 15:04:37
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /oracle/app/oracle/product/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 9.2.0.5.0 - ProductionSystem parameter file is /oracle/app/oracle/product/9.2.0/network/admin/listener.oraLog messages written to /oracle/app/oracle/product/9.2.0/network/log/listener.logListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db01)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Solaris: Version 9.2.0.5.0 - ProductionStart Date 12-JUL-2007 15:04:37Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity OFFSNMP OFFListener Parameter File /oracle/app/oracle/product/9.2.0/network/admin/listener.oraListener Log File /oracle/app/oracle/product/9.2.0/network/log/listener.logListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))Services Summary...Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully[oracle@db01]$ exit