Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle databases not starting
I found this on the oracle technet but it means nothing to me.
For a start I am running Oracle on a freestanding server not on a network
What os the SQL *Net driver?
What is the JSB driver
What is MFTP
What is the TCP_VENDOR key?
What is a valid TCP_VENDOR key?
How do you load a JSB driver?
How do you specify a correct TCP_VENDOR key?
Please help
ORA-12560 TNS:Protocol Adapter Error (network not loaded) This error occurs when the SQL*Net driver cannot find the JSB driver because you may have either forgotten to load the JSB driver (for instance MFTP) or used an incorrect TCP_VENDOR key (for example, TCP_VENDOR=NOVLWP). Load the JSB driver or use the correct TCP_VENDOR key.
Phil McAvity wrote:
> All,
>
> I had a complete working Oracle installation but noticed a problem when
> trying to run toad or sqlplus. When I checked the services it showed my
> database service as in the 'starting' state. I left it for a long time
> but the state didn't change.
>
> I have deinstalled and reinstalled Oracle and even sadly removed the my
> two databases in an effort to get things working.
>
> Having reinstalled Oracle, I get the following when trying to use
> sqlplus
>
> D:\>sqlplus
>
> SQL*Plus: Release 8.1.6.0.0 - Production on Wed May 2 08:08:35 2001
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> Enter user-name: system
> Enter password: password
> ERROR:
> ORA-12560: TNS:protocol adapter error
>
> Enter user-name:
>
> I have no idea what a TNS: protocol adapter error is.
>
> Can someone please help. It am keen to be able to resolve these type of
> problems on my own - could someone recommend a book or series of books?
Received on Wed May 02 2001 - 02:52:15 CDT
![]() |
![]() |