Results 1 to 5 of 5

Thread: ORA-12529 error

  1. #1
    Join Date
    May 2007
    Posts
    2

    Unanswered: ORA-12529 error

    Hi,

    I'm new to the forum and to oracle but was given the responsibility of managing it till we hire someone. Lucky me. I had an hour of knowledge transfer with the previous owner...but only on the immediate needs. For the last few months, I have been able to extinguished a few fires with the limited knowledge, unfortunately though, that lucky streak is about to run out.

    One of the users is reporting the following error from his window environment:


    C:\>sqlplus s12_133s/iae@crel
    SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 25 13:25:35 2007
    Copyright (c) 1982, 2005, Oracle. All rights reserved.
    ERROR:
    ORA-12529: TNS:connect request rejected based on current filtering rules

    I have not worked on the windows setup before as I'm mainly a unix person so have no clue where to begin. The user have mentioned an IP address change on his system and thought that this information may be hardcoded in one of the files. Could you advise?

    Thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I don't do Windows, either
    12529, 00000, "TNS:connect request rejected based on current filtering rules"
    // *Cause: Connection Manager and its listener were configured with filtering
    // rules specifying that the connect request be rejected.
    // *Action: If this connect request should be allowed, then contact the
    // administrator to modify the filtering rules.
    Base upon the above, I'd say it has less to do with Windows & more to do with (obsoleted) Oracle's Connection Manager.

    P.S.
    I did not know that HomeDepot ran Oracle.
    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
    May 2007
    Posts
    2
    Thanks for the input.

    umm..what do you mean obsoleted? We're still up and running so I gather that it's still in use? Guess I'll have to go through the manuals that was left behind to understand more about the anatomy of this product and it's connection to the window world. I gather that the component is on unix but would you know the file name I can search for? I did a listing of valid system that can connect to Oracle and his system name is still listed.

    Thanks.
    ps. Home Depot has everything! )

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >what do you mean obsoleted?
    As in, Oracle no longer supports Connection Manager(CM).
    >We're still up and running so I gather that it's still in use?
    Are you bragging or complaining about CM.
    So is Oracle V7.3.4.5 in some places.
    You might be able to find manuals at http://tahiti.oracle.com; then again might not.
    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
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Changing the clients IP address would be a problem with connection manager. Check out the following link. It might help you out.

    http://download-east.oracle.com/docs...96580/cman.htm
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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