Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2008
    Posts
    2

    Unanswered: Oracle not starting

    i have oracle 10g R2 installed on my development machine. I have been moved from one office to other. I dont know what has happened. My locally installed database is not running. When i try to log on this message is given

    ORA-12514: Message 12514 not found; product=RDBMS80; facility=ORA

    My tns names and listener are fine. Listner gets started and gets stopped using lsnrctl command and tns ping also gives perfrct ok message. I am unable to figure out the problem.

    Can any body tell me any tip, how could i get my DB Up

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    ORACLE_HOME is not defined.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2008
    Posts
    2

    Oracle DB Starting Problem

    But as i mentioned it was working fine few days ago. Home and every thing was defined and was working properly.

    Can u guide me what to check and how to check

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    12514, 00000, "TNS:listener does not currently know of service requested in connect descriptor"
    // *Cause:  The listener received a request to establish a connection to a
    // database or other service. The connect descriptor received by the listener
    // specified a service name for a service (usually a database service)
    // that either has not yet dynamically registered with the listener or has
    // not been statically configured for the listener.  This may be a temporary
    // condition such as after the listener has started, but before the database
    // instance has registered with the listener.
    // *Action: 
    //  - Wait a moment and try to connect a second time.
    //  - Check which services are currently known by the listener by executing:
    //    lsnrctl services <listener name>
    //  - Check that the SERVICE_NAME parameter in the connect descriptor of the
    //    net service name used specifies a service known by the listener.
    //  - If an easy connect naming connect identifier was used, check that
    //    the service name specified is a service known by the listener.
    //  - Check for an event in the listener.log file.
    MS Access is easier to use.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jul 2008
    Posts
    5
    Did you use the IP or host name in tnsnames? If you're using IP, you may need to change the IP after you move the office.

Posting Permissions

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