Concurnt Manager

Ibrahim Malek

    Dear friends

     

    kindly find the attached file should i run CM clean or n't?

     

    regards

      • 1. Re: Concurnt Manager
        Bashar.

        Hi,

         

        Do you face any problems?

        Please provide us with more information about the nodes comprising this instance and the output of the following query:

         

        select node_name, node_mode, support_cp, support_web, support_admin, support_forms

        from fnd_nodes;

         

        Regards,

        Bashar

        • 2. Re: Concurnt Manager
          Ibrahim Malek

          SQL> select node_name,node_mode,support_cp,support_web,support_admin,support_forms from apps.fnd_nodes;

           

           

          NODE_NAME                      N S S S S

          ------------------------------ - - - - -

          AUTHENTICATION                 O N N N N

          SRVHQON16                      O N N N N

          SRVHQON17                      O Y Y Y Y

           

           

          SQL>

          • 3. Re: Concurnt Manager
            Ibrahim Malek

            This is the status after the RUN of cm clean  the conc is unable to start  please advice is this the PROD

            cmclean.jpg

            • 4. Re: Concurnt Manager
              ProDBA

              1) You should check your database/application OS space next alert log of database node.

              2) Stop CM by cmctl.sh, kill all pending requests if present.

              3) Connect APPS user. Execute CMCLEAN once again.

              4) Start CM by cmctl.sh

              5) If issue persist, down application properly execute AUTOCONFIG on database tier then application tier.

              6) Start application services!

               

              Regards,

              • 5. Re: Concurnt Manager
                Ibrahim Malek

                ProDBA

                Dear sir still the same thing the conc is unable to start

                 

                please advice

                • 6. Re: Concurnt Manager
                  ProDBA

                  try to relink fndsm and fndfs.

                  • 7. Re: Concurnt Manager
                    Ibrahim Malek

                    i don't under stand? please explain

                    • 8. Re: Concurnt Manager
                      Ibrahim Malek

                      kindly note that

                       

                      yesterday  the application sysadmin was locked by a mistake from the department head

                       

                      i've used the FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN to reset it


                      i think it may be the problem 


                      regards


                      • 9. Re: Concurnt Manager
                        ProDBA

                        Check the blog, how to relink executable: Expertise in Oracle Apps....: How to relink a single executable (binary file) using ADADMIN utility ?

                        Please try to relink fndsm and fndfs executables.

                        • 10. Re: Concurnt Manager
                          Ibrahim Malek

                          Dear ProDBA

                           

                          this is the result of adadmin

                           

                          AD Administration error:

                          The following ORACLE error:

                           

                           

                          ORA-28000: the account is locked

                           

                           

                           

                           

                          occurred while executing the SQL statement:

                           

                           

                          CONNECT APPS/*****

                           

                           

                          AD Administration error:

                           

                           

                          Unable to connect to APPS DB account

                           

                           

                          aiimdf:Error while calling adudbsnTimestampExist

                          You should check the file

                          /oracle/prod/a01/apps/apps_st/appl/admin/PROD/log/malek

                           

                           

                          for errors.

                          • 11. Re: Concurnt Manager
                            Ibrahim Malek

                            This is the LOG of adadmin

                             

                             

                            vi /oracle/prod/a01/apps/apps_st/appl/admin/PROD/log/malek

                            "/oracle/prod/a01/apps/apps_st/appl/admin/PROD/log/malek" 343 lines, 9834 characters

                             

                             

                            ************* Start of AD Administration session *************

                            AD Administration version: 12.0.0

                            AD Administration started at: Mon Dec 28 2015 12:22:29

                             

                             

                            APPL_TOP is set to /oracle/prod/a01/apps/apps_st/appl

                             

                             

                            NLS_LANG value from the environment is    : American_America.AL32UTF8

                            NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.AL32UTF8

                             

                             

                            You can be notified by email if a failure occurs.

                            Do you wish to activate this feature [No] ? no

                             

                             

                            Please enter the batchsize [1000] : 1000

                             

                             

                             

                             

                            Please enter the name of the Oracle Applications System that this

                            APPL_TOP belongs to.

                             

                             

                            The Applications System name must be unique across all Oracle

                            Applications Systems at your site, must be from 1 to 30 characters

                            long, may only contain alphanumeric and underscore characters,

                            and must start with a letter.

                             

                             

                            Sample Applications System names are: "prod", "test", "demo" and

                            "Development_2".

                             

                             

                            Applications System Name [PROD] : PROD *

                             

                             

                             

                             

                            NOTE: If you do not currently have certain types of files installed

                            in this APPL_TOP, you may not be able to perform certain tasks.

                             

                             

                            Example 1: If you don't have files used for installing or upgrading

                            the database installed in this area, you cannot install or upgrade

                            the database from this APPL_TOP.

                             

                             

                            Example 2: If you don't have forms files installed in this area, you cannot

                            generate them or run them from this APPL_TOP.

                             

                             

                            Example 3: If you don't have concurrent program files installed in this area,

                            you cannot relink concurrent programs or generate reports from this APPL_TOP.

                             

                             

                             

                             

                            Do you currently have files used for installing or upgrading the database

                            installed in this APPL_TOP [YES] ? YES *

                             

                             

                             

                             

                            Do you currently have Java and HTML files for HTML-based functionality

                            installed in this APPL_TOP [YES] ? YES *

                             

                             

                             

                             

                            Do you currently have Oracle Applications forms files installed

                            in this APPL_TOP [YES] ? YES *

                             

                             

                             

                             

                            Do you currently have concurrent program files installed

                            in this APPL_TOP [YES] ? YES *

                             

                             

                             

                             

                            Please enter the name Oracle Applications will use to identify this APPL_TOP.

                             

                             

                            The APPL_TOP name you select must be unique within an Oracle Applications

                            System, must be from 1 to 30 characters long, may only contain

                            alphanumeric and underscore characters, and must start with a letter.

                             

                             

                            Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

                             

                             

                            APPL_TOP Name [srvhqon17] : srvhqon17 *

                             

                             

                             

                             

                             

                             

                            You are about to use or modify Oracle Applications product tables

                            in your ORACLE database 'PROD'

                            using ORACLE executables in '/oracle/prod/a01/apps/tech_st/10.1.2'.

                             

                             

                            Is this the correct database [Yes] ? yes

                             

                             

                            AD Administration needs the password for your 'SYSTEM' ORACLE schema

                            in order to determine your installation configuration.

                             

                             

                            Enter the password for your 'SYSTEM' ORACLE schema: *****

                             

                             

                             

                             

                            Connecting to SYSTEM......Connected successfully.

                             

                             

                            The ORACLE username specified below for Application Object Library

                            uniquely identifies your existing product group: APPLSYS

                             

                             

                            Enter the ORACLE password of Application Object Library [APPS] : *****

                             

                             

                            AD Administration is verifying your username/password.

                            Connecting to APPLSYS......Connected successfully.

                             

                             

                            The status of various features in this run of AD Administration is:

                             

                             

                                                                       <-Feature version in->

                            Feature                          Active?   APPLTOP    Data model    Flags

                            ------------------------------   -------   --------   -----------   -----------

                            CHECKFILE                        Yes       1          1             Y N N Y N Y

                            PREREQ                           Yes       6          6             Y N N Y N Y

                            CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N

                            PATCH_TIMING                     Yes       2          2             Y N N Y N Y

                            PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y

                            SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y

                            JAVA_WORKER                      Yes       1          1             Y N N Y N Y

                            CODELEVEL                        Yes       1          1             Y N N Y N Y

                             

                             

                             

                             

                             

                             

                            Connecting to SYSTEM......Connected successfully.

                             

                             

                            Connecting to APPLSYS......Connected successfully.

                             

                             

                            Identifier for the current session is 72886

                             

                             

                            Reading product information from file...

                             

                             

                            Reading language and territory information from file...

                             

                             

                            Reading language information from applUS.txt ...

                             

                             

                            AD Administration warning:

                            Product Data File

                            /oracle/prod/a01/apps/apps_st/appl/admin/zfaprod.txt

                            does not exist for product "zfa".

                            This product is registered in the database but the

                            above file does not exist in APPL_TOP.  The product

                            will be ignored without error.

                             

                             

                             

                             

                            AD Administration warning:

                            Product Data File

                            /oracle/prod/a01/apps/apps_st/appl/admin/zsaprod.txt

                            does not exist for product "zsa".

                            This product is registered in the database but the

                            above file does not exist in APPL_TOP.  The product

                            will be ignored without error.

                             

                             

                             

                             

                            AD Administration warning:

                            Product Data File

                            /oracle/prod/a01/apps/apps_st/appl/admin/jtsprod.txt

                            does not exist for product "jts".

                            This product is registered in the database but the

                            above file does not exist in APPL_TOP.  The product

                            will be ignored without error.

                             

                             

                             

                             

                            Reading database to see what industry is currently installed.

                             

                             

                            Reading FND_LANGUAGES to see what is currently installed.

                            Currently, the following languages are installed:

                             

                             

                            Code   Language                                Status

                            ----   --------------------------------------- ---------

                            US     American English                        Base

                            AR     Arabic                                  Install

                             

                             

                            Reading language information from applAR.txt ...

                             

                             

                            Your base language will be AMERICAN.

                             

                             

                            Your other languages to install are: ARABIC

                             

                             

                            Setting up module information.

                            Reading database for information about the modules.

                            Saving module information.

                            Reading database for information about the products.

                            Connecting to SYSTEM......Connected successfully.

                             

                             

                            Connecting to APPLSYS......Connected successfully.

                             

                             

                            Connecting to SYSTEM......Connected successfully.

                             

                             

                            Reading database for information about how products depend on each other.

                            Connecting to APPLSYS......Connected successfully.

                             

                             

                            Reading topfile.txt ...

                             

                             

                            Saving product information.

                            Connecting to SYSTEM......Connected successfully.

                             

                             

                            Connecting to APPLSYS......Connected successfully.

                             

                             

                             

                             

                            AD code level : [A.6]

                             

                             

                            Connecting to SYSTEM......Connected successfully.

                             

                             

                            Connecting to APPS......Connected successfully.

                             

                             

                            Connecting to APPLSYS......Connected successfully.

                             

                             

                                        AD Administration Main Menu

                               --------------------------------------------------

                             

                             

                               1.    Generate Applications Files menu

                             

                             

                               2.    Maintain Applications Files menu

                            • 12. Re: Concurnt Manager
                              ProDBA

                              1) SQLPLUS / as sysdba

                              2) alter user apps account unlock;

                              3) Try to start application

                               

                              Regards,

                              • 13. Re: Concurnt Manager
                                Ibrahim Malek

                                still the same 

                                cmclean.jpg

                                • 14. Re: Concurnt Manager
                                  Ibrahim Malek

                                  Now Only The output processor is n't running

                                   

                                   

                                  output post.jpg

                                  1 2 上一个 下一个