9 Replies Latest reply: Jan 17, 2011 8:54 AM by 559983 RSS

    Audit vault add redo collector error with ORA-12514

    559983
      I'm testing audit vault on OEL 5.5. When add REDO collect on AV server got error from server:


      avorcldb add_collector -srcname AVCLIENT.ORACLE.COM -agentname agent1 -colltype REDO -collname REDO_collect -av avclient.oracle.com:1521:SRCDB1

      source AVCLIENT.ORACLE.COM verified for REDO Log Audit Collector collector
      Adding collector...
      Collector added successfully.

      remember the following information for use in avctl
      Collector name (collname): REDO_collect
      initializing REDO Collector
      ERROR: could not get AV source user connection using jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=avclient.oracle.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SRCDB1)))
      ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor


      And naming resolve is ok, I can connect source from AV sever.


      your early reply will be appreciated
        • 1. Re: Audit vault add redo collector error with ORA-12514
          683924
          Try using IP address instead of Host name in the command
          like this

          avorcldb add_collector -srcname AVCLIENT.ORACLE.COM -agentname agent1 -colltype REDO -collname REDO_collect -av 172.000.000.000:1521:SRCDB1
          • 2. Re: Audit vault add redo collector error with ORA-12514
            559983
            Hi khurram,

            Tried,but still got same error

            Edited by: user556980 on 2011-1-10 下午8:15
            • 3. Re: Audit vault add redo collector error with ORA-12514
              683924
              Hi Dear
              the error depect that you are not ussing the correct connect discriptor please make sure that u are using the correct syntax.as per i think your service name is not right please conform it and correct it this may resolve the issue
              • 4. Re: Audit vault add redo collector error with ORA-12514
                Elmin
                Hi, I noticed that your command is avorcldb add_collector -srcname AVCLIENT.ORACLE.COM -agentname agent1 -colltype REDO -collname REDO_collect -av avclient.oracle.com:1521:SRCDB1.

                Can you explain me the next thing: your srcname is AVCLIENT.ORACLE.COM, and your audit vault server has the same name avclient.oracle.com:1521:SRCDB1???
                Comman should be
                avorcldb add_collector -srcname <server with source database> -agentname agent1 -colltype REDO -collname REDO_collect -av <audit vault server>:port:<audit vault database>.

                Try this command_1, just in case that yours audit source server and audit vault server have the same name. Otherwise try command_2, but be careful to put correct ORACLE_HOME for source database, my is /home/oracle/product/10.2.0

                command_1:
                avorcldb add_collector -srcname AVCLIENT.ORACLE.COM -agentname agent1 -colltype REDO -orclhome /home/oracle/product/10.2.0 -collname REDO_collect -av avclient.oracle.com:1521:SRCDB1

                command_2:
                avorcldb add_collector -srcname AVCLIENT.ORACLE.COM -agentname agent1 -colltype REDO -orclhome /home/oracle/product/10.2.0 -collname REDO_collect -av avclient.oracle.com:1521:SRCDB1

                Good luck!
                Elmin.
                • 5. Re: Audit vault add redo collector error with ORA-12514
                  683924
                  hi,

                  there is a confussion please clerify that either you are facing this problem in adding the Redo collector or in starting the collector. from your statement it is depicted that your collector is added sucessfully ?
                  • 6. Re: Audit vault add redo collector error with ORA-12514
                    683924
                    hi
                    here is also aa proposed solution to check service conectivity

                    ***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:*



                    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.
                    • 7. Re: Audit vault add redo collector error with ORA-12514
                      559983
                      Thanks for Elmin and khurram's help

                      There did conceptual confusion on previous command, and I correct it with follow command, but still got the same error

                      avorcldb add_collector -srcname AVCLIENT.ORACLE.COM -agentname agent1 -colltype REDO -collname REDO_collect2 -av avserver.oracle.com:1521:av

                      Additional information:

                      Tnsnames.ora

                      AV =
                      (DESCRIPTION =
                      (ADDRESS_LIST =
                      (ADDRESS = (PROTOCOL = TCP)(HOST = avserver.oracle.com)(PORT = 1521))
                      )
                      (CONNECT_DATA =
                      (SERVER = DEDICATED)
                      (SERVICE_NAME = av.oracle.com)
                      )
                      )

                      lsnrctl status
                      Services Summary...
                      Service "PLSExtProc" has 1 instance(s).
                      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                      Service "av.oracle.com" has 1 instance(s).
                      Instance "av", status READY, has 1 handler(s) for this service...
                      Service "avXDB.oracle.com" has 1 instance(s).
                      Instance "av", status READY, has 1 handler(s) for this service...
                      Service "av_XPT.oracle.com" has 1 instance(s).
                      Instance "av", status READY, has 1 handler(s) for this service...

                      And DB parameter like this

                      AVserver DB hostname avserver.oracle.com
                      global_names False
                      service_names av.oracle.com
                      db_domain oracle.com

                      AV source DB hostname avclient.oracle.com
                      global_names Ture
                      service_names avclient
                      db_domain

                      Just as khurram said REDO collector can be added successful, but can't startup

                      Edited by: user556980 on 2011-1-11 下午6:54
                      • 8. Re: Audit vault add redo collector error with ORA-12514
                        683924
                        Hi Dear,
                        as mentioned in your tnsname.ora file your service name is (av.oracle.com) but in your comand you are just using AV,
                        please check the statement agiain and retry. if the problem persist then do the above mentioned action.
                        Hope it will resolve the issue

                        Regards
                        • 9. Re: Audit vault add redo collector error with ORA-12514
                          559983
                          Hi khurram,

                          I'm misunderstanding of parameter service name, when correct it as av.oracle.com, it does work.

                          Thank you very much!