This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jan 29, 2013 4:44 AM by viksjp RSS

Form6i (CHAR) is not connecting to ORacle 10g database

viksjp Newbie
Currently Being Moderated
Hi - We have Form6i (CHAR) installed on AIX 5.3 and database in oracle 10gR1. When tried connecting to ORACLE DATABASE from oracle 10gR1 path it is connecting to database, but when connecting from the forms SQLPLUS it is giving error TNS-12538: TNS:no such protocol adapter.

Please let me know if you the steps to resolve the issue/ if anyone faced similar issue and has solution please let me know.
-------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/product/ODS6i/network/admin [rdmpoc]>tnsping rdmpoc

TNS Ping Utility for IBM/AIX RISC System/6000: Version 8.0.6.0.0 - Production on 18-DEC-12 15:33:25

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx)(PORT=1521))
TNS-12538: TNS:no such protocol adapter
/u01/app/oracle/product/ODS6i/network/admin [rdmpoc]>
----------------------------------------------------------------------------------------------------------------------------------------------------

Regards,
Vikram.

Edited by: viksjp on 19-Dec-2012 01:57
  • 1. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    KhaledFarouk Explorer
    Currently Being Moderated
    Hello: Vikram.

    try to copy and replace the tnsnames.ora file from the database directory to the forms6i directory.

    that may work.

    * don't forget to get backup form the file before replace

    Respectfully
    Khaled Farouk
  • 2. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    viksjp Newbie
    Currently Being Moderated
    When i tried to stop the listner, following error is shown:

    /u01/app/oracle/product/ODS6i/network/admin [rdmpoc]>lsnrctl

    LSNRCTL for IBM/AIX RISC System/6000: Version 8.0.6.0.0 - Production on 19-DEC-12 13:42:44

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    Welcome to LSNRCTL, type "help" for information.

    LSNRCTL> stop
    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=<oracle_sid>))
    TNS-12532: TNS:invalid argument
    TNS-12560: TNS:protocol adapter error
    TNS-00502: Invalid argument

    Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))
    TNS-12224: TNS:no listener
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    IBM/AIX RISC System/6000 Error: 2: No such file or directory
    Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=uxlprdmpoc)(Port=1521))
    TNS-12222: TNS:no such protocol adapter
    TNS-12538: TNS:no such protocol adapter
    TNS-12560: TNS:protocol adapter error
    TNS-00508: No such protocol adapter

    LSNRCTL> exit
  • 3. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    viksjp Newbie
    Currently Being Moderated
    Hi Khaled - Thanks for the details, I tried the option but still the same issue. I tried to start the listner from FORMS path, is that correct?

    Regards,
    Vikram.
  • 4. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    yoonas Expert
    Currently Being Moderated
    Hi,

    I guess your listner is running from database home, so you can go to your database home and set enviroment variables(oraenv) and try stopping the listner.

    please post the output of lsnrctl status command

    post your forms tnsnames.ora content

    try connecting to database from another machine and see whats happening

    Regards
    Yoonas
  • 5. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    KhaledFarouk Explorer
    Currently Being Moderated
    Hello

    could you please post your current tnsnames.ora data from the database and the forms .
  • 6. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    viksjp Newbie
    Currently Being Moderated
    Hi Yoonas - Thanks, yes, as per your update my listner was in oracle path. So, i was having issue when tried to start from FORMS path.

    tnsnames.ora file is same in both DB and FORMS path

    # tnsnames.ora Network Configuration File: /u01/app/oracle/10.1.0.2/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

    RDMPOC =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.38.10)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = RDMPOC)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    I can start the listner, but still i'm facing issue in connecting to DB from forms.

    Regards,
    Vikram.
  • 7. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    yoonas Expert
    Currently Being Moderated
    Hi,

    Please post the output of "lsnrctl status"

    Regards
    Yoonas

    Edited by: yoonus on Dec 20, 2012 9:43 AM
  • 8. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    viksjp Newbie
    Currently Being Moderated
    Hi Yoonus - OAS admis is reinstalling Forms. i will post it tomorrow.

    Regards,
    Vikram.

    Edited by: viksjp on 24-Dec-2012 07:00
  • 9. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    viksjp Newbie
    Currently Being Moderated
    Hi - Please find the lsnrctl status output from ORACLE DB path and FORMS path

    ORACLE DB:

    batch:/u01/app/rdm/bin # lsnrctl status

    LSNRCTL for IBM/AIX RISC System/6000: Version 10.1.0.2.0 - Production on 02-JAN-2013 10:59:19

    Copyright (c) 1991, 2004, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.1.0.2.0 - Production
    Start Date 12-NOV-2012 09:15:57
    Uptime 51 days 1 hr. 43 min. 22 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP ON
    Listener Parameter File /u01/app/oracle/product/10.1.0.2/network/admin/listener.ora
    Listener Log File /u01/app/oracle/product/10.1.0.2/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=uxlprdmpoc.whsmith.co.uk)(PORT=1521)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "RDMPOC" has 1 instance(s).
    Instance "RDMPOC", status READY, has 1 handler(s) for this service...
    Service "trmsppt" has 1 instance(s).
    Instance "trmsppt", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
    uxlprdmpoc batch:/u01/app/rdm/bin #

    FORMS PATH:

    /u01/app/oracle/product/ODS6i/bin [rdmpoc]>lsnrctl status

    LSNRCTL for IBM/AIX RISC System/6000: Version 8.0.6.0.0 - Production on 02-JAN-13 11:00:45

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    TNS-01150: The address of the specified listener name is incorrect
    NL-00305: the specified path name does not exist
    /u01/app/oracle/product/ODS6i/bin [rdmpoc]>

    Regards,
    Vikram.
  • 10. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    yoonas Expert
    Currently Being Moderated
    Please start sqlplus from database home and connect
    sqlplus user/password@RDMPOC

    now start sqlplus from forms home

    sqlplus user/password@RDMPOC

    can you ping to 10.16.38.10

    ping uxlprdmpoc.whsmith.co.uk

    contents of sqlnet.ora

    Pleas post the out of above

    Edited by: yoonus on Jan 2, 2013 4:22 AM
  • 11. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    viksjp Newbie
    Currently Being Moderated
    Hi Yoonus - Please find the details:

    Connecting DB through SQLPLUS from database home works fine:

    batch:/u01/app/oracle/product/10.1.0.2 # sqlplus par3214/par3214@rdmpoc

    SQL*Plus: Release 10.1.0.2.0 - Production on Wed Jan 2 13:00:45 2013

    Copyright (c) 1982, 2004, Oracle. All rights reserved.


    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options

    SQL>

    Connecting DB through SQLPLUS from Forms home throws following error:

    /u01/app/oracle/product/ODS6i/bin [rdmpoc]>sqlplus

    SQL*Plus: Release 8.0.6.0.0 - Production on Wed Jan 2 12:59:16 2013

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    Enter user-name: ^C/u01/app/oracle/product/ODS6i/bin [rdmpoc]>
    /u01/app/oracle/product/ODS6i/bin [rdmpoc]>sqlplus par3214/par3214@rdmpoc

    SQL*Plus: Release 8.0.6.0.0 - Production on Wed Jan 2 12:59:22 2013

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    ERROR:
    ORA-12222: TNS:no such protocol adapter

    --------------
    PING is working
    --------------
    Enter user-name: ^C/u01/app/oracle/product/ODS6i/bin [rdmpoc]>ping uxlprdmpoc.whsmith.co.uk
    PING uxlprdmpoc.whsmith.co.uk (10.16.38.10): 56 data bytes
    64 bytes from 10.16.38.10: icmp_seq=0 ttl=255 time=0 ms
    64 bytes from 10.16.38.10: icmp_seq=1 ttl=255 time=0 ms
    64 bytes from 10.16.38.10: icmp_seq=2 ttl=255 time=0 ms
    64 bytes from 10.16.38.10: icmp_seq=3 ttl=255 time=0 ms
    64 bytes from 10.16.38.10: icmp_seq=4 ttl=255 time=0 ms
    64 bytes from 10.16.38.10: icmp_seq=5 ttl=255 time=0 ms
    --- uxlprdmpoc.whsmith.co.uk ping statistics ---
    6 packets transmitted, 6 packets received, 0% packet loss
    round-trip min/avg/max = 0/0/0 ms

    /u01/app/oracle/product/ODS6i/bin [rdmpoc]>ping 10.16.38.10
    PING 10.16.38.10 (10.16.38.10): 56 data bytes
    64 bytes from 10.16.38.10: icmp_seq=0 ttl=255 time=0 ms
    64 bytes from 10.16.38.10: icmp_seq=1 ttl=255 time=0 ms

    64 bytes from 10.16.38.10: icmp_seq=2 ttl=255 time=0 ms
    64 bytes from 10.16.38.10: icmp_seq=3 ttl=255 time=0 ms
    64 bytes from 10.16.38.10: icmp_seq=4 ttl=255 time=0 ms
    64 bytes from 10.16.38.10: icmp_seq=5 ttl=255 time=0 ms
    --- 10.16.38.10 ping statistics ---
    6 packets transmitted, 6 packets received, 0% packet loss
    round-trip min/avg/max = 0/0/0 ms
    /u01/app/oracle/product/ODS6i/bin [rdmpoc]>


    Sqlnet.ora contents (This file was present only in DATABASE home network admin path)

    cat sqlnet.ora
    # sqlnet.ora Network Configuration File: /u01/app/oracle/10.1.0.2/network/admin/sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


    Thanks,
    Vikram.
  • 12. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    yoonas Expert
    Currently Being Moderated
    can you just post form tnsnames as well, sorry i forgot that in previous post

    can you open a new terminal and try forms sqlplus (without setting any environment variables for database home)

    Edited by: yoonus on Jan 2, 2013 5:38 AM

    Edited by: yoonus on Jan 2, 2013 5:40 AM
  • 13. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    viksjp Newbie
    Currently Being Moderated
    Hi - Forms 6.0.8.8.3 version installed on AIX5.3. Please confirm if this version works on AIX 5.3. Please confirm do we need to apply patch to this version to get FORMs 6 working.

    Regards,
    Vikram.
  • 14. Re: Form6i (CHAR) is not connecting to ORacle 10g database
    viksjp Newbie
    Currently Being Moderated
    Hi Yoonus - Please find the tnsnames.ora file.

    RDMPOC =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.38.10)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = RDMPOC)
    )
    )



    Regards,
    Vikram,
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points