| Shared Server Configuration Doubt [message #135543] |
Thu, 01 September 2005 02:43  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Hi all
I faced an issue while configuring Shared Server on my database.
Oracle 9.2.0.1
OS: WinXP Professional
Initial scenario:
sqlnet.ora file:
| Quote: |
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
|
Entry in tnsnames.ora:
| Quote: |
ORCL_Shared =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <my ip>)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = Shared)
(SERVICE_NAME = orcl)
)
)
|
TNSPING response:
| Quote: |
tnsping orcl_shared
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 01-SEP-2005 12:12:06
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
c:\oracle9i\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = WINGR185013-013)(PORT = 1521))) (CONNECT_DA
TA = (SERVER = Shared) (SERVICE_NAME = orcl)))
OK (10 msec)
|
LSNRCTL services result:
| Quote: |
lsnrctl services
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 01-SEP-2005 12:56:
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "OEMREP" has 1 instance(s).
Instance "OEMREP", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "orcl" has 2 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "orcl", status READY, has 2 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: <my ip>, pid: 1188>
(ADDRESS=(PROTOCOL=tcp)(HOST=<my ip>)(PORT=3249))
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
The command completed successfully
|
Now with this configuration, When I try connecting using shared server connection I get:
| Quote: |
SQL> conn scott/tiger@orcl_shared
ERROR:
ORA-12637: Packet receive failed
|
After this I made the following change in sqlnet.ora:
| Quote: |
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
|
Now I am able to connect.
| Quote: |
SQL> conn scott/tiger@orcl_shared
Connected.
|
Now my query is What does disabling the parameter SQLNET.AUTHENTICATION_SERVICES= (NTS) signifies.
Thnx in advance
Girish
|
|
|
|
| Re: Shared Server Configuration Doubt [message #135564 is a reply to message #135543] |
Thu, 01 September 2005 04:29  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi,
SQLNET.AUTHENTICATION_SERVICES=(NTS) enables Windows NT native authentication.
If you hash it out, it will default to SQLNET.AUTHENTICATION_SERVICES=(NONE), which indicates that a valid Oracle username and password must be used to access the database.
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
