Re: ORA 12560: TNS: Protocol Adapter Error

the logon should be system/manager don't put a / after manager. also make sure that the SID of the database is set as an environment variable
under windows 2000 professional, select control panel, system, and the the advanced tab, then click on the button environment variables, look for the bottom-most button named new, click on that and in the dialog box, for the variable name enter ORACLE_SID, for the variable value enter the name of the database you just created, then click on OK to close the dialog box,then continue clicking OK until you are back in the control panel window, and then click on the X to close it. You should now be able to connect via sqlplus as system/manager.

Hope this helps !!!

Regards,

Dave Bennett, OCP DBA
ocp_dba_at_worldnet.att.net

Karsten Wutzke wrote:

> Hi all!
>
> I have posted a message just a few hours ago, but the problem seems to
> be harder to solve than expected. I have searched the net already, but I
> couldn't find any useful answers, whereas I found MANY questions
> regarding the same issue.
>
> I have installed Oracle8i Personal on my machine (Windows 2k Pro). The
> DB is to be used locally only, at least for now. When I try to log on
> with "sys"/"manager"/"" (without the "" of course), the error message
> "ORA 12560: TNS: Protocol Adapter Error" appears. Does anyone know
> what's going on?
>
> Thanks for helping a COMPLETE DB NEWBIE...
>
> Karsten
>
> PS: Sorry for the X-post, but it's really important to me!
Received on Thu Aug 16 2001 - 14:35:16 CDT