Re: Starting and Shutting DB

Mirwais Qader (mqader_at_facstaff.wisc.edu) wrote:
: How would you start and shutdown the database once software is installed?

I use sql*dba, connect internal, then SHUTDOWN.

: I started it with dbstart and tried dbshut to shut it down, but some 8
: processes seem to be active in the background.

Haven't tried this so can't comment on it.

: Also, should I modify my listener.ora file and add the portname listener? If
: so, what section? Here is my listener.ora file right now:
 

: I am also wondering if I should have a TCP section since we are using the
: TCP/IP protocol with SQL*Net V2?
 

: LISTENER=
: (ADDRESS_LIST=
: (ADDRESS=
: (PROTOCOL=IPC)
: (KEY=sid1)
: )
: )

Here's a sample:

LISTENER_KVAX=
    (ADDRESS_LIST=

        (ADDRESS=
            (PROTOCOL=TCP)
            (HOST=KVAX)
            (PORT=1521)
        )

Port number is a random, unused one. Take your pick.

: STARTUP_WAIT_TIME_LISTENER = 0
: CONNECT_TIMEOUT_LISTENER = 10
 
: SID_LIST_LISTENER=
: (SID_LIST=
: (SID_DESC=
: (SID_NAME=sid1)
: (ORACLE_HOME=/users/oracle/oraclebase/product/7.2.2.4)
: )
: )
 

: TRACE_LEVEL_LISTENER = OFF
: PASSWORD_LISTENER = (dfsfssde231q232)
 

: I added the following in /etc/services prior to installing.
 

: listener 1521/tcp

--
Leng Kaing
DBA - Directory Technology P/L
Email: lkaing_at_ventnds1.telecom.com.au
Ph: +61-3-9892-9081  Fax: +61-3-9892-9344