Re: Starting and Shutting DB

From: Don Williams <Don.Williams_at_dal.ca>
Date: 1996/03/11
Message-ID: <Don.Williams-1103961225150001_at_dwilliams.dentistry.dal.ca>#1/1

Hello,

First you supply more information as to youe environment to give others more of an idea to help you. I will try anyway, first to start and stop the DB you can use SQL*DBA type help once you are connected internel to get a list of the commands. ie. shutdown immediate. Next...Your listener.ora file should be modified to include your protocol.. Here an idea...IBM RS/6000 running AIX UNIX

LISTENER.ORA $ cat lis*

################


# Filename......: listener.ora

# Node..........: local
# Date..........: 28-FEB-94 09:23:20

################

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = TCP)
          (Host =xxx.xxx.xxx)
          (Port = 1521)
        )

  )

TRACE_LEVEL_LISTENER=16
TRACE_DIRECTORY_LISTENER=/var/local/oracle/product/7.2.3/network/trace
TRACE_FILE_LISTENER=listener.trc

LOGGING_LISTENER=ON
LOG_DIRECTORY_LISTENER=/var/local/oracle/product/7.2.3/network/log LOG_FILE_LISTENER=listener.log
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 0
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = FOD)
      (ORACLE_HOME=/var/local/oracle/product/7.2.3)

    )
  )

TNSNAMES.ORA$ cat tns*

################


# Filename......: tnsnames.ora

# Name..........: FOD
# Date..........: 28-FEB-96 09:23:04

################

FOD =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = xxx.xxx.xxx)
          (Port = 1521)
        )

    )
    (CONNECT_DATA =
       (SID = FOD)
    )
  )

Check out the Appendix in the Installation & Config manual for more help on syntax etc...

HTH
Don

In article <4ht5d7$h8o_at_news.doit.wisc.edu>, mqader_at_facstaff.wisc.edu (Mirwais Qader) wrote:

> How would you start and shutdown the database once software is installed?
> 
> I started it with dbstart and tried dbshut to shut it down, but some 8 
> processes seem to be active in the background.
> 
> 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)
>   )
>  )
> 
> 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
 
-- 
Don A Williams                  
Oracle DBA/Developer          
Dalhousie University           
Halifax, Canada         

INTERNET: Don.Williams_at_dal.ca Received on Mon Mar 11 1996 - 00:00:00 CET