Results 1 to 11 of 11
  1. #1
    Join Date
    Sep 2003
    Posts
    6

    Unanswered: Trouble starting listener on Win2K machine (w/local database)

    I'm running Oracle 8i with a simple local database named 'emanager' installed on a Win2K box (who's name is ORACLEPC.tks.com). I just want to get Listener started but I get the following error when issueing a LSNRCTL START:

    (mind you, it was Oracle 7 with Oracle 8 loaded over it.. but I dont think that's the problem)
    ========================================

    LSNRCTL for 32-bit Windows: Version 2.3.4.0.0 - Production on 18-SEP-03 09:16:16

    Copyright(c) ORacle Corporation 1994. All Rights Reserved

    Starting tnslsnr: please wait...

    TNSLSNR for 32-bit Windows: Version 2.3.4.0.0 - Production
    System parameter file is: c:\oracle\ora81\network\admin\listener.ora
    Log messages written to: c:\orawin95\network\log\listener.log
    Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=392)(HOST=192.168.226. 65)(PORT=1521))
    Attempted to listen on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
    TNS-12560: TNSrotocol adapter error
    TNS-00530 Protocol adapter error
    32-bit Windows Error: 161: Unknown system error

    =============================================

    Here's a copy of my LISTENER.ORA file:

    ------------------------------------
    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = ORACLEPC.tks.com)
    (Port = 1521)
    )
    )
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_LEVEL_LISTENER = OFF
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = emanager)
    )
    )

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

    Here's the TNSNAMES file:



    emanager.tks.com =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = ORACLEPC.tks.com)
    (Port = 1521)
    )
    )
    (CONNECT_DATA = (SID = emanager)
    )
    )


    -------------------------------------------
    And here's my SQLNET file:



    NAMES.DEFAULT_ZONE = WORLD

    NAME.DEFAULT_ZONE = world

    NAMES.DEFAULT_DOMAIN = tks.com

    TRACE_LEVEL_CLIENT = OFF

    NAMES.DIRECTORY_PATH= (TNSNAMES)

    AUTOMATIC_IPC = OFF


    ==============================================



    Does this give anyone enough information to know why lsnrctl start wont work?

    I've tried about everything it seems...

    Thanks in advance for even reading this!

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Log messages written to: c:\orawin95\network\log\listener.log

    This tells me that you may have some crossover from Or7... Have
    you checked your PATH .... Take references to OR7 out if they exists.
    Have you used the NET8 Configuration Assistant to set up the listener.ora ?

    Gregg

  3. #3
    Join Date
    Sep 2003
    Posts
    6
    gbrabham - thanks for the reply.. I used to also live in Greenville (off Roper Mountain road).. was a beautiful place


    Well, there are references to c:\orawin95\bin in the Path.. but that's the only location of LSNRCTL.EXE on my machine.


    Do you think it might be 7 and 8 stepping on each other?
    (This isn't my machine, so I'm hesitant to reinstall)

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    I'm not far from where you were.... I'm off Pelham Rd.

    System parameter file is: c:\oracle\ora81\network\admin\listener.ora

    This tells me the OR8i is installed and you should have a LSNRCTL.EXE
    in c:\oracle\ora81\bin... If not, it sounds like you are trying to run
    OR7 lsnrctl with OR8 files (possibly dll's etc...)...

    Or is it that the database engine is OR7 and the Client is OR8 ??

    Gregg

  5. #5
    Join Date
    Sep 2003
    Posts
    6
    Hehehe..boy, do I have egg on my face. After much fussing with it, I think I've uncovered the problem.

    *ahem*

    and it is a tad embarassing that I didn't figure this out sooner. But I'm not an Oracle Guru (just yet).


    But.. here's what I think the problem is.

    Errr... I have to have Server components installed on here to run LSNRCTL, would that be right?


    My ORA8 folder (rather the clients ORA8 folder) is about 130 meg. And that folder does not contain LSNRCTL. Only the older ORAWIN95 folder has it.


    So, could this mean that the client gave me a laptop with only the Oracle Client installed??!? This would be why I could create a database thru SVRMGR23 but not fire up listener properly?!?!?

    Does that make sense?!




    BTW, I lived not far from the intersection of Pelham and Roper Moutain Road! My daughter went to Pelham elementary. (This was about 5 years ago) I'm in Oklahoma now.. ha!

  6. #6
    Join Date
    Sep 2003
    Posts
    6
    stupid question here...

    But maybe I'm confused over SVRMGR. Does that not start up a local server of sorts?

  7. #7
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    It does sound like you have OR7 server and OR8 client...
    svrmgrl does not start up a local instance.... It allows you to log into
    an instance and startup or shutdown a database.

    oradim starts and stops services ... Whether or not to automatically
    start the database is housed in the registry.

    We've been in Taylors Elem, Buena Vista Elem and Riverside High.
    Oldest is a freshman at Clemson... I also coach C-Team football
    at Riverside High.

    Gregg

  8. #8
    Join Date
    Sep 2003
    Posts
    4

    Re: Trouble starting listener on Win2K machine (w/local database)

    I think the first problem is basic connectivity. Ensure that the network is well installed by pinging other PCs in the subnet. Second probability could be the IP lookup problem. Change the Host parameter's value from ORACLEPC.tks.com to 192.168.226.65. Do not touch the LISTENER.ora file. Instead start the Net8 Assistant and delete the existing LISTENER. Create a new LISTENER and assign the IP ADDRESS instead of the DOMAIN NAME.

    Just a ghost work. Try it, who knows where you land.

    bye
    Originally posted by PaulNern
    I'm running Oracle 8i with a simple local database named 'emanager' installed on a Win2K box (who's name is ORACLEPC.tks.com). I just want to get Listener started but I get the following error when issueing a LSNRCTL START:

    (mind you, it was Oracle 7 with Oracle 8 loaded over it.. but I dont think that's the problem)
    ========================================

    LSNRCTL for 32-bit Windows: Version 2.3.4.0.0 - Production on 18-SEP-03 09:16:16

    Copyright(c) ORacle Corporation 1994. All Rights Reserved

    Starting tnslsnr: please wait...

    TNSLSNR for 32-bit Windows: Version 2.3.4.0.0 - Production
    System parameter file is: c:\oracle\ora81\network\admin\listener.ora
    Log messages written to: c:\orawin95\network\log\listener.log
    Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=392)(HOST=192.168.226. 65)(PORT=1521))
    Attempted to listen on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
    TNS-12560: TNSrotocol adapter error
    TNS-00530 Protocol adapter error
    32-bit Windows Error: 161: Unknown system error

    =============================================

    Here's a copy of my LISTENER.ORA file:

    ------------------------------------
    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = ORACLEPC.tks.com)
    (Port = 1521)
    )
    )
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_LEVEL_LISTENER = OFF
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = emanager)
    )
    )

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

    Here's the TNSNAMES file:



    emanager.tks.com =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = ORACLEPC.tks.com)
    (Port = 1521)
    )
    )
    (CONNECT_DATA = (SID = emanager)
    )
    )


    -------------------------------------------
    And here's my SQLNET file:



    NAMES.DEFAULT_ZONE = WORLD

    NAME.DEFAULT_ZONE = world

    NAMES.DEFAULT_DOMAIN = tks.com

    TRACE_LEVEL_CLIENT = OFF

    NAMES.DIRECTORY_PATH= (TNSNAMES)

    AUTOMATIC_IPC = OFF


    ==============================================



    Does this give anyone enough information to know why lsnrctl start wont work?

    I've tried about everything it seems...

    Thanks in advance for even reading this!

  9. #9
    Join Date
    Sep 2003
    Posts
    6

    Re: Trouble starting listener on Win2K machine (w/local database)

    Gregg, thanks for all the help thus far.

    The bottom line to all this is I'm doing a C++ excutable that merges data into this clients existing database and I've never worked direct with Oracle before. Most of the above 'dinking around' has been trying to get an ODBC driver set up..


    Looking further at the machine the client gave me (with the Oracle7 and Oracle8 pieces) there is no ORACLE.INI file. Is that unusuall?



    And backing up just a little bit, with a more general question. If I want to set up an ODBC connection to a local database on this machine only, I still need LSNRCTL START to run correctly? Would that be true?


    thanks again.. I know these questions might be out from left field a bit.. but I'm getting there.

    (I truely believe the Oracle instal on this PC is a bit horked.. I've installed a trial version of Personal Oracle 9i on another Win2k machine, and everything seems to fall into place correctly)

  10. #10
    Join Date
    Sep 2003
    Posts
    6
    One more silly question. If, on this whacky laptop, I can start SVRMGR23 and say:


    CONNECT INTERNAL;
    STARTUP PFILE = C:\PROGRAMS\SMRTDB\DATABASE\INITSMRTDB.ORA

    (it then says Database Mounted, Database Open)

    and I can then start selecting from tables and such...


    Shouldn't I be able to set up an ODBC connection if the above works???
    If I could just get an ODBC connection then all would be well with the universe.

  11. #11
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    If you are using svmgr23 then it is an Oracle7 database engine running.
    You can log in using svrmgr23 and select from tables ...
    to verify what you've got ...
    svrmgr23> select * from db_version;

    will tell you the database info...

    As far as an ODBC connection ... you should get the correct level
    of odbc driver ... The 8.1.7 version was buggy... I used 8.1.7.4 with
    my clients with no problems (but that was against an OR8i database)...

    Gregg

Posting Permissions

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