Oracle Database Cache Configuration Error while installing Oracle9iAS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Oracle Database Cache Configuration Error while installing Oracle9iAS

  1. #1
    Join Date
    Feb 2002
    Posts
    54

    Oracle Database Cache Configuration Error while installing Oracle9iAS

    Dear Sir/Ma'am,

    While installing Oracle9iAS 1.0.2.1.0 i encountered the error connecting to the cache failed. Below is the log of the error messages:

    CACHE CONFIGURATION ASSISTANT PROGRESS

    CONFIGURING CACHE --> Processing Failed

    Configuring the Cache
    Creating the Cache
    Starting up the Cache
    Setting up the Cache Listener
    Connecting to the Cache
    Connecting to the Cache Failed
    Reason: ORA-01034: ORACLE not available
    ORA-27101:shared memory realm does not exist
    SVR4 Error: 2: No such file or directory

    Processing failed.

    My OS in Sun Solaris 8.

    I retried it in the Oracle Database Cache Configuration Assistant screen for about 3 times now and still im getting the same error.

    Any help on how to solve this error will be greatly appreciated.

    Thank you very much.

    Regards,

    Edward
    =======================
    Manifest plainness,
    embrace simplicity,
    reduce selfishness,
    have few desires. LAO TZU
    =======================

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Obviously you are trying to create the database cache repository in a db that doesn't exist.

    Cheers

  3. #3
    Join Date
    Feb 2002
    Posts
    54
    I have an existing origin database. You cant proceed with the database cache configuration if the origin database is not existing right? From the installation screens, i think the configuration assistant is creating a database which it cannot connect to? Ive seen in the $ORACLE_HOME/dbs directory datafiles and an init.ora which i think the configuration assistant created.. How come it cannot connect to the database that it creates? Thanks..
    =======================
    Manifest plainness,
    embrace simplicity,
    reduce selfishness,
    have few desires. LAO TZU
    =======================

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    dont you supply connection information to your GUI? Are they correct?

    have you set environment variables?

    can you connect to your database?

    it's not a db cache error

  5. #5
    Join Date
    Feb 2002
    Posts
    54
    Originally posted by pando
    dont you supply connection information to your GUI? Are they correct?

    have you set environment variables?

    can you connect to your database?

    it's not a db cache error
    I supplied information regarding the origin database (username,password and service name). They are correct.

    Ive set the environment variables. Oracle home and oracle sid. Do i have to set the oracle sid variable?

    i can connect using sqlplus.

    thanks in advance pando.
    =======================
    Manifest plainness,
    embrace simplicity,
    reduce selfishness,
    have few desires. LAO TZU
    =======================

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    set ORACLE_SID as well, that error looks more like caused by a local connection without ORACLE_SID set than a remote connection using service name

  7. #7
    Join Date
    Feb 2002
    Posts
    54
    Originally posted by pando
    set ORACLE_SID as well, that error looks more like caused by a local connection without ORACLE_SID set than a remote connection using service name
    I've already set the ORACLE_SID and the ORACLE_HOME in the profile of the user im using to install Oracle9iAS. Ive set the ORACLE_SID to the value of my origin database.

    What else do i need to do? In the error log ive posted yesterday, the error is in the part where the configuration assistant connects to the cache. Is this a tnsname issue? What are the steps i need to do?

    Thanks.
    =======================
    Manifest plainness,
    embrace simplicity,
    reduce selfishness,
    have few desires. LAO TZU
    =======================

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width