-
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
-
yes that is possible
Before starting a database u might wanna set the $ORACLE_HOME parameter.
Which OS are you using?
which values do you get after typing 'set' at the prompt?
Regards,
D.
-
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.
Best Regards,
Fábio RGB.
-
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.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|