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
# Date..........: 28-FEB-94 09:23:20
LISTENER =
(ADDRESS_LIST =
)
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 =
)
# Date..........: 28-FEB-96 09:23:04
FOD =
(DESCRIPTION =
(ADDRESS_LIST =
)
(CONNECT_DATA =
(SID = FOD)
)
)
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*
################# Node..........: local
# Filename......: listener.ora
# 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*
################# Name..........: FOD
# Filename......: tnsnames.ora
# 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