Forgot your password?    
+ Reply to Thread
Results 1 to 3 of 3

Thread: Error occured while applying pre-req patch of cu2

  1. #1
    Oracle DBA
    Join Date
    Oct 2011
    Posts
    5

    Error occured while applying pre-req patch of cu2

    The following error we got while applying PRE-REQ patch of CU2.Although we RESET the system passwd with manager also..



    AutoPatch needs the password for your 'SYSTEM' ORACLE schema
    in order to determine your installation configuration.

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

    ...Unable to connect.

    AutoPatch error:
    The following ORACLE error:

    ORA-12516: Message 12516 not found; product=RDBMS; facility=ORA



    occurred while executing the SQL statement:

    CONNECT SYSTEM/*****

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Try the following :

    a) Source the database environment and connect using '/ as sysdba' and then using system/manager - Does this work (this is not using listener)
    b) Source the Apps environment and 'tnsping <connection-identifier' - Does this work
    c) Source the Apps environment and use system/password@connection-identifier - Does this work - Whats the error message.

    ORA-12516: TNS:listener could not find available handler with matching protocol stack

    Is the db listener up and running with the right definition.
    See the definition of the database listener you are using , is it using the same prococol (tcp) as the tnsnames.ora
    (see the definition of the connection Identifier you are using in the tnsnames.ora.The value you should see for in the tnsnames.ora is the TWO_TASK value).

    Make sure the DB Listener definition is right and Restart the listener. You should first be able to connect

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    Before starting the patch session...
    Please make sure..your DB and listner is up and System password is correct.
    And you must be able to connect t the DB using system password from Apps Node.

    if all these things match..i hope you will not get the error.
    Regards,
    -Amit

+ Reply to Thread

Similar Threads

  1. Applied CU2 Patch running autoconfig afterwards getting error!! Listing the error
    By dbaANKIT in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 1
    Last Post: 01-30-2012, 12:21 AM
  2. Error occured while applying patch
    By sneha in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 1
    Last Post: 11-12-2011, 04:36 PM
  3. Error occurred while Applying ATG Roll up 4 4676589
    By mdmasood in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 2
    Last Post: 11-11-2011, 05:16 PM
  4. Error while applying 5478710 TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH O on DB 9.2.0.8
    By mdmasood in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 11-10-2011, 04:55 PM
  5. Applying patch for Developer 6i from patchset 14 to patchset 19
    By mdmasood in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 1
    Last Post: 10-25-2011, 07:22 PM

Posting Permissions

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

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics