Oracle 8i on win2k server

[penzk001]

I have just installed a Oracle 8i on a windows 2000 server. The installation when fine and the wizard created a initial database.

I can connect to the database remotely but locally I cannot connect to the database. Oracle SID is setup with the connect value.

D:\oracle\ora817\network\ADMIN>sqlplus system/manager

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Apr 24 14:59:43 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-12560: TNSrotocol adapter error


Enter user-name:

How can I solve this problem.

 

[SysSupport]

Check your Listener.
Normally this error appears when Listener is not up for the database. When you connected to the DB with SQL*Plus, did you give any connect TNS alias? eg.

SQL>connect system/manager@"db-tns-alias"

If not, then you are connecting using BEQ local protocol, not the tnsnames.ora file.

So here's what you have to do:

1. Open MS-DOS window.
2. c:\> set oracle_sid="enter SID for the DB here"
3. c:\> lsnrctl status (if gives you anything than STARTED, do lsnrctl start )
4. SQL> connect system/manager@tns-alias

If you don't have TNS alias for the db, then you have to create one. Go to %ORACLE_HOME%\network\admin\tnsnames.ora file. Add entry for the DB:

DB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = ........ ???? - enter SID here)
)
)

Then open %ORACLE_HOME%\network\admin\sqlnet.ora and make sure SQLNET.DEFAULT_DOMAIN= is commented out.

Then connect as SQL> connect system/manager@db1

 

[sem]

In fact LOCAL entry in registry under HKLM/Software/Oracle defines default tns alias, thus allowing to connect without @.

Regards, Dima

 

[penzk001]

A part of the problem seems to be a bug in the terminal services of win2k. As from the console of the server itself the error is a different one.
when logging fro the console I get the following errors.
note that oracle_sid is set with the sid of the database.

C:\Documents and Settings\oracle>svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

ORA-12641: Authentication service failed to initialize
SVRMGR> ^C
C:\Documents and Settings\oracle>sqlplus

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Apr 25 11:56:46 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter user-name: internal
ERROR:
ORA-24314: service handle not initialized


Enter user-name:

 

[penzk001]

I managed to solve the problem, it waas solved by modifing the D:\oracle\ora817\network\admin\sqlnet.ora from

from SQLNET.AUTHENTICATION_SERVICES = (ALL)
to SQLNET.AUTHENTICATION_SERVICES = (none)