Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Join Date
    Apr 2003
    Posts
    12

    Unanswered: configure listener.ora for 'EXTPROC'

    Hai all,
    I have a problem in creating 'EXTPROC connection' in Listener.ora file while creating Intermedia Text.
    I tried to execute 'exec ctx_output.start_log('log')' but i got the following error.
    SQL> exec ctx_output.start_log('log');
    BEGIN ctx_output.start_log('log'); END;

    *
    ERROR at line 1:
    ORA-20000: interMedia Text error:
    DRG-50704: Net8 listener is not running or cannot start external procedures
    ORA-28575: unable to open RPC connection to external procedure agent
    ORA-06512: at "CTXSYS.DRUE", line 126
    ORA-06512: at "CTXSYS.CTX_OUTPUT", line 39
    ORA-06512: at line 1


    Think there is some problem in Listener.ora or TnsNames.ora.....

    I'm just confused what to do....

    any one who has come across this problem can suggest me.....


    specification
    _______________

    * Oracle 8.1.6
    * Windows NT


    Advance thanks,
    Arul prakash.
    arul

  2. #2
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    Try this,

    alter session set optimizer_mode = rule;
    SATHISH .

  3. #3
    Join Date
    Apr 2003
    Posts
    12

    hai satish

    Hai satish,
    Think u have send the message to me instead of some other.
    Could u answer for my question?

    Here is my question again,
    I'm getting error while creating Intermedia text.

    The error is
    SQL> exec ctx_output.start_log('log');
    BEGIN ctx_output.start_log('log'); END;

    *
    ERROR at line 1:
    ORA-20000: interMedia Text error:
    DRG-50704: Net8 listener is not running or cannot start external procedures
    ORA-28575: unable to open RPC connection to external procedure agent
    ORA-06512: at "CTXSYS.DRUE", line 126
    ORA-06512: at "CTXSYS.CTX_OUTPUT", line 39
    ORA-06512: at line 1

    I think this is because of the improper configuration of the 'Listener.ora,tnsname.ora and sqlnet.ora'.

    Could u please help me how to configure 'EXTPROC' in listener.ora.

    Thanks,
    Arul,
    Chennai.
    arul

  4. #4
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi Arul,

    I've attached copies of the three .ora files. These are for a machine running two instances (dev.asd and quick.asd).

    Hth
    Bill
    Attached Files Attached Files
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  5. #5
    Join Date
    Apr 2003
    Posts
    12
    thanks for your reply Billm,
    I've changed my listener.ora,tnsnames.ora and sql.net files like your files and restarted my computer still it is giving the following ERROR.

    There sre some old Listeners in services, I removed the name from the registry eventhough i could not remove it but its status is disabled. Is this error because of that.

    LSNRCTL> reload
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=karomi)( PORT=1521)))
    TNS-01103: Protocol specific component of the address is incorrectly specified
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    LSNRCTL> start listener
    Starting tnslsnr: please wait...
    Failed to start service, error 3.
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error
    32-bit Windows Error: 3: No such process



    I have attached my files(listener.ora,tnsnames.ora and sql.net).
    Please help me where i'm making mistake.(for start the listener)

    regards,
    Arul
    Attached Files Attached Files
    arul

  6. #6
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    I don't know for certain, but you've got two LISTENER = sections in listener.ora, you also have the exproc entry after your sid entry in the SID_LIST_LISTENER section.

    I don't know if they can be a problem. Also you should carefully check the service name.

    select * from v$parameter where name = 'service_names'

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  7. #7
    Join Date
    Apr 2003
    Posts
    12
    thanks,
    YES,There is two listner.I have deleted one out of them. I have checked the service name as you say (select * from v$parameter where name='service_names'). its correct.

    Still I'm getting the error while start the listener.

    Please help me where i'm making mistake..



    LSNRCTL> reload
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0) ))
    TNS-01103: Protocol specific component of the address is incorrectly specified
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 2: No such file or directory



    LSNRCTL> start listener
    Starting tnslsnr: please wait...

    Failed to start service, error 1058.
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error
    32-bit Windows Error: 1058: Unknown error


    my changed listener.ora is
    -------------------------------

    # LISTENER.ORA Network Configuration File: F:\Oracle\Ora81\NETWORK\ADMIN\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = KAROMI)(PORT = 1521))
    )
    )

    )


    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = kora)
    (ORACLE_HOME = f:\oracle\ora81)
    (SID_NAME = korasid)
    )
    (SID_DESC =
    (PROGRAM = extproc0)
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = F:\Oracle\Ora81)
    )
    )
    arul

  8. #8
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi Arul,

    *** Here's the text for TNS-01103 ***
    TNS-01103 Protocol specific component of the address is incorrectly specified

    Cause: The ADDRESS used to contact the listener is not correctly specified. This error occurs because the address fails to specify the destination of the listener. The address is well formed (for example, there are no missing parentheses) but it is missing a protocol specific component. For example, this is the error returned when the HOST component is missing from a TCP/IP address string.

    Action: Edit the ADDRESS in LISTENER.ORA to include the required protocol-specific keywords. For more information about the keywords required by different protocol adapters, see the Oracle operating system specific-documentation for your platform.
    ***

    That's wierd, your PROTOCOL/HOST/PORT are all properly specified.

    I don't know to be honest - I think in your first post your listener would start and allow connections, but fail on Extproc calls. I think you should use that as a starting point. Can the Net8 config assistant shed any light on it?

    There may be more detailed data in your listener.log file.

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  9. #9
    Join Date
    Apr 2003
    Posts
    12
    Hi Billm,
    Think there is some listener it is not possible to remove. So I reinstall my enire oracle8.1.6 again but i got the error in 'Net8 configurarion assistance' while installation. I simply rejected this error so there is no listener.ora ..etc files in the Network directory.

    I have to configuration the 'Net8 Assistance' manualy.

    Nothing is there in my listener.ora. Please guide me what should i do now to get good listener.ora.(for extproc config).


    arul
    arul

  10. #10
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi Arul,

    I'm afraid I'm out of answers. If the DBCA won't run / install then there is clearly something else amiss on your machine. Be sure to do a full remove of the Oracle prior to reinstalling it (after doing a typical uninstall you may still need to manually delete some stuff including old registry keys, environment vars, services etc).

    With not even a default listener up and running, I would think a clean Oracle is the best starting point. (I guess from you saying you already did a re-install that this is a dev or personal instance!).

    Cheers
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  11. #11
    Join Date
    Apr 2003
    Posts
    12
    thaks Bill,
    Its personal Instance. I will try to do in again.

    arul
    arul

  12. #12
    Join Date
    Apr 2003
    Posts
    12
    Hai Bill,

    I've done the the re-installation of oracle and everything working fine except 'EXTPROC Config' in Listener.
    In other words, there is two listener one for my local server(sid) and other to External procedure call(EXTPROC). I can start my server listener successfully but starting the EXTPROC listener gives error message.
    The error, which i have got is

    ************************************************** ******** LSNRCTL> reload listener
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCO) ))
    TNS-01103: Protocol specific component of the address is incorrectly specified
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 2: No such file or directory
    LSNRCTL> start listener
    Starting tnslsnr: please wait...

    Failed to start service, error 1058.
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error
    32-bit Windows Error: 1058: Unknown error
    ************************************************** ********


    I have attached my listenere.ora ..etc

    I'm happy to run atleast one listener...Hope i can run it that too....
    Attached Files Attached Files
    arul

  13. #13
    Join Date
    Apr 2003
    Posts
    12
    Hi Bill,
    Atlast i find out the problem. The listener, which i was running early may not been killed clearly so i could not any listener in the same name..
    Now i can run all listener(Server,EXTPROC) in the different name.
    So there is not problem in running external procedure call(listener.ora,tnsnames.ora and sql.net).


    The big problem is still i am not free from Errors.

    I tried to execute 'exec ctx_output.start_log('log')'
    Following the error i got,

    ************************************************** ****
    SQL> exec ctx_output.start_log('log');
    BEGIN ctx_output.start_log('log'); END;

    *
    ERROR at line 1:
    ORA-20000: interMedia Text error:
    DRG-50704: Net8 listener is not running or cannot start external procedures
    ORA-28575: unable to open RPC connection to external procedure agent
    ORA-06512: at "CTXSYS.DRUE", line 126
    ORA-06512: at "CTXSYS.CTX_OUTPUT", line 39
    ORA-06512: at line 1


    ************************************************** *********


    Can you please help me where is i am making mistake.


    Arul.
    Attached Files Attached Files
    arul

  14. #14
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi Arul,

    I haven't used intermedia, but it looks like the ORA-20000 was raised by the intermedia PL/SQL side, as a result of it failing on an Extproc call.

    Your listener.ora still doesn't look right, you have a listener called KAROMI and a SID_LIST for KAROMI, then you have a LISTENER1 with a SID_LIST for LISTENER.

    There doesn't appear to be any Extproc sections in your KAROMI listener definition, but the is in LISTENER1. However, the LISTENER1 section doesn't mean anything, it has no HOST entry etc.

    You do atleast have something up and running at the moment, so back uo your various ORA files. Does your DBCA run now? If so, see if that can now connect to and configure KAROMI for you.

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  15. #15
    Join Date
    Apr 2003
    Posts
    12
    Hi Bill,

    Thanks Bill, You are correct, I made a mistake in SID_LIST name. I've changed to 'LISTENER1' from 'LISTENER'.

    While starting the listener1, I'm getting this error.

    ************************************************** *******
    LSNRCTL> start listener1
    Starting tnslsnr: please wait...

    TNSLSNR for 32-bit Windows: Version 8.1.6.0.0 - Production
    System parameter file is F:\Oracle\Ora81\network\admin\listener.ora
    Log messages written to F:\Oracle\Ora81\network\log\listener1.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\EXTPROCOipc
    )))
    TNS-01155: Incorrectly specified SID_LIST_listener1 parameter in LISTENER.ORA
    NL-00303: syntax error in NV string

    ************************************************** *********

    Can u guess what is the reasion for this problem
    My DBCA is working fine.


    arul
    Attached Files Attached Files
    arul

Posting Permissions

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