-
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
-
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
-
# 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
-
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!
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|