Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2007
    Posts
    4

    Unanswered: Grid Control Problems ora-12557

    Hello, I'm trying to install the Oracle DataGuard in my work. I have two server with these features:
    2 Processors Intel Xeon 2.8 GHz
    4 GB Ram
    6 SATA hdd 250GB (Raid 5)
    for each server. Actually, only one server have the database production, and the another server I have for testing purpose. I must be have a high availability system. I want to build an Oracle RAC system, but I think that I need an external storage (something like SAN, or fibre channel or iSCSI). Well, I assumed that I don't create a Oracle RAC because I do not have the hardware requirements. Then, I thougth use Oracle DataGuard. For that, I have one server in one building and another server in another building like a standby database. If a server fail, then I use the another.

    I decided to create Oracle DataGuard configuration. I installed windows 2003 server standard edition in my server for test purpose, and then I installed the Oracle Database 10 g with my database. After I installed the Oracle Grid Control with a new database for repository. Well, when the installation of Oracle Grid Control was completed, I didn´t connect to my database because sqlplus show me an error (Ora-12557). Before I install the Oracle Grid Control I can connect perfectly with my database, but after that I can not connect any time.

    Anyone can help me, please????

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    12557, 00000, "TNSrotocol adapter not loadable"
    // *Cause: On some platforms (such as OS/2) protocol adapters are loaded at
    // run-time. If the shared library (or DLL) for the protocol adapter is
    // missing or one of its supporting libraries is missing then this error is
    // returned.
    // *Action: For further details, turn on tracing and reexecute the operation.
    // The trace file will include the name of the shared library (or DLL) that
    // could not be loaded.
    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
    Apr 2007
    Posts
    4
    Excuse me, but I don´t understand your reply. You says me the definition of ora-12557, but I want to know how can I fixed it. I re-installed the system, but I can´t connect with the systems.
    Can anyone help me?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Delete the ORACLE_HOME environment variable from the System environment settings and set it only in the Windows Registry.
    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
    Apr 2007
    Posts
    4
    Ok, I deleted the ORACLE_HOME variable, but I did not connect with my database. Can you help me?

Posting Permissions

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