8i and 9i in same machine!

Printable View

08-19-2003, 05:26 PM
bragabio

8i and 9i in same machine!

Is it possible install a 2 diferent version of oracle(8i e 9i)in same machine?
When i try create a DB (with script: CreateDB.sql) i recive the following message:
ORA-01092: ORACLE instance terminated. Disconnection forced

Please i need help.
Regards.
Fábio
08-21-2003, 06:48 AM
DaDuck

yes that is possible

Before starting a database u might wanna set the $ORACLE_HOME parameter.

:confused: Which OS are you using?

which values do you get after typing 'set' at the prompt?

Regards,

D.
08-21-2003, 07:41 AM
bragabio

Oracle 8i and 9i in same machine

Thanks DaDuck,
I'm using a Solaris (SunFire 420R with T3). I can install using graphical interface. But now i have aother problem. I install 8i in a diferent path that 9i, but i need start diferents listeners for diferent oracles, but i can't start 2 listeners. Do you know how start 2 listeners whit diferent binary ?

Regards,
bragabio.
08-21-2003, 08:02 AM
DaDuck

use different listener names in listener.ora

So now u have 2 ORACLE_HOMEs available.
An 8 and a 9 ORACLE_HOME.

go to the 8i ORACLE_HOME/bin and use:
./lsnrctl
It will tell u which version it's using.
then enter:
start listener8i
(listener8i is the listener name u stated in 8i $ORACLE_HOME/network/admin/listener.ora).

Same trick u can use in the 9i ORACLE_HOME.

Hope this set u a bit further.
08-21-2003, 12:36 PM
bragabio

2 listener up

Thanks again DaDuck.

In 9i i can start the listener whit the following command: lsnrctl start listener9i

In 8i i CAN'T start the listner whit the following command: lsnrctl start listener8i

I recived the following error:
[sunfire/oracle8]:/network/admin > lsnrctl start listener8i

LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 21-AUG-2000 12:03:27

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Starting /dsk_t3/oracle8i/oracle817/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 8.1.7.0.0 - Production
System parameter file is /dsk_t3/oracle8i/oracle817/network/admin/listener.ora
Log messages written to /dsk_t3/oracle8i/oracle817/network/log/listener8i.log
TNS-01151: Missing listener name, listener8i, in LISTENER.ORA

My listener.ora for 8i:
[sunfire/oracle8]:/network/admin > cat listener.ora
listener8 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.146)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.146)(PORT = 1526))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /dsk_t3/oracle8i/oracle8)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = crprep)
(ORACLE_HOME = /dsk_t3/oracle8i/oracle8)
)
)

Best Regards,
bragabio.