please help a newbie
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: please help a newbie

  1. #1
    Join Date
    Mar 2001
    Posts
    20

    Wink

    I keep getting the following two errors very randomly
    The error:

    ORA12560 TNS: protocol adaptor error

    develops into

    ORA12500 TNS: Listener failed to start a dedicated server process

    I have created a number of asp pages that draw data from and write to an oracle database. the asp pages work fine until out of nowhere these errors occur. After a few times hitting the refresh button on Internet Explorer the error goes away and the page renders as intended.

    The errors consistently point to asp lines of the following format:

    recordsetname.ActiveConnection = ...

    This really irritates me as the pages themselves seem to work fine. Any idea? I am running oracle 8i personal and Microsoft Personal Web Server on the same machine for testing. Any ideas?

    Please help
    Marc

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Post your database name, tnsnames.ora/listener.ora from your oracle_home/network/admin directory. If you can't find search for 'em with the name.

    Reddy,Sam

  3. #3
    Join Date
    Mar 2001
    Posts
    20
    # TNSNAMES.ORA Network Configuration File: c:\Oracle\Ora81\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

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

    ULLRICH.GLOBAL =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ullrich)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ullrich.global)
    )
    )

    _________________________________________________

    # LISTENER.ORA Network Configuration File: c:\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 = ullrich)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = ullrich)(PORT = 2481))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = c:\Oracle\Ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = ullrich.global)
    (ORACLE_HOME = c:\Oracle\Ora81)
    (SID_NAME = ullrich)
    )
    )


    __________________________________________

    The database name as the file indicate is: mullrich.global

    Hope this helps solve the mystery. These files were generated by the standard installation. And as I said the errors reported are sort of random. 4 pages or so come up fine and then the error hitts. after hitting refresh a few times the called asp page works. A few pages later the error hist again. Thanks for taking the time.

    Marc

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    TNSNAMES.ORA

    ULLRICH.GLOBAL =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ullrich)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ullrich.global)
    <B>(SRVR = DEDICATED) </B>
    )
    )

    _________________________________________________
    Check your lister services to see whether dedicated services had been started

    lsnrctl services

    If the above doesn't fix the problem, then try disabling the global database name from your listener.ora and try restarting the instance and bouncing the listener.

    lsnrctl reload

    Hope this would solve the problem.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Mar 2001
    Posts
    20
    tried all of that. it seems that the error is now confined to:

    ORA12560 TNS: protocol adaptor error

    it still occurs as befor. sorry. any other ideas what could trigger this wild behavior.

    Thanks,
    Marc

  6. #6
    Join Date
    Mar 2001
    Posts
    12

    Maybe out of resource

    One possible reason is you system run out of some operating
    system resources. This error may be a result of too many
    TNS connections, files or sockets opened
    simultaneously.

    You can check the processes parameter in the
    init.ora file. Processes should be set to the
    number of background processes plus one for each
    connection to the database.

    If the init.ora processes parameter seems
    fine, it might be necessary to increase the Unix
    kernel parameters for the maximum number of
    processes or users.


Posting Permissions

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



Click Here to Expand Forum to Full Width