Re: running two oracle databases

#==========Mr Angus Che Yeung Liu, 7/6/95==========
#Hi,
# I'm quite new to oracle. I've got this question: I want to run two
#oracle server instance at the same time, one for production and the other
#for testing. I want to switch between the two database. Besides,
#changing the ORACLE_SID parameter, how can I easily switch to other
#database, let's say testing database, when I'm using the production
#database ??

You can always connect with SQL or other tools by using the SQL*Net v1 connect string. e.g. sqlplus <user>/<pass>_at_T:<node>:<sid> or the SQL*Net V2.x service name e.g. sqlplus <user>/<pass>_at_<service_name>

# Another question: I'm used to use SQL*NET V1 which start the oracle
#service by "orasrv", however I recently installed the SQL*NET V2, I've
#found that orasrv has disappeared, instead, I've told that I should start
#tnrlsrv. However, I find that there is no respond, what's wrong ??

You really need to get the SQL*Net V2 manuals which explain how to do all this but your biggest problem may be that you don't run "tnrlsrv" to start the V2.x listener. You need to run lsnrctl which starts the listener up ( assumming you've created all of the *.ora config files for SQL*Net V2). You will need the manuals to get you going on this. SQL*Net V2 is quite a bit more complicated than V1

Hope this points you in the right direction at least.

Jim Gregory

Thanks in advance !

Angus(angusliu_at_hk.super.net) Received on Thu Jul 06 1995 - 00:00:00 CEST