Results 1 to 5 of 5

Thread: 8i and 9i in same machine!

  1. #1
    Join Date
    Aug 2003
    Location
    Brazil
    Posts
    3

    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

  2. #2
    Join Date
    Jun 2003
    Posts
    16

    Lightbulb 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.

  3. #3
    Join Date
    Aug 2003
    Location
    Brazil
    Posts
    3

    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.

  4. #4
    Join Date
    Jun 2003
    Posts
    16

    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.

  5. #5
    Join Date
    Aug 2003
    Location
    Brazil
    Posts
    3

    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
  •