Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2003
    Posts
    12

    Unanswered: Error: Oracle Not Available

    I have installed Oracle 8i onto my machine.
    But When I try to log on to it , I get the following message:

    Error:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    you have installed the rdbms software but no instance / database or your os-kernel parameters or init<SID>.ora parameters are not set properly ...

    use dbca to create a database instance

  3. #3
    Join Date
    Dec 2003
    Posts
    12
    could u plz guide me how to create a new instance

  4. #4
    Join Date
    Dec 2003
    Posts
    12
    should i select
    1.create a database
    2.change database configuration

  5. #5
    Join Date
    Nov 2002
    Posts
    833
    Originally posted by andrew_123
    should i select
    1.create a database
    2.change database configuration
    create database is the selection choose either oltp database dw db depending on your needs

  6. #6
    Join Date
    Dec 2003
    Posts
    12
    thanks for helping

  7. #7
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    HI,

    If ORA_SID is correctly defined, then this error can indicate that the instance is unavailable, i.e. shut down or crashed.

    To check for the instance background processes, do the following:
    $ SET DEFAULT SYS$LOGIN
    or any directory where the user can write files
    $ SHOW SYSTEM/OUTPUT=SYS.LIS
    $ SEARCH SYS.LIS ORA_<value of ORA_SID, i.e. "PROD", "V715", etc.>

    This should give several lines of output if the instance is running, if not, you see:
    %SEARCH-I-NOMATCHES, no strings matched
    SATHISH .

  8. #8
    Join Date
    Dec 2003
    Posts
    12
    thanks a lot.
    That solves the problem

Posting Permissions

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