Printable View
hi,
I am really astonished to see at server when i connect by writing username/password it says tns-protocol adapter error but it takes username/password@servicename it connects ,this problem is occasional.I think when I give service name it connects thru Net8.how does connection take place without service name.Is this something to do with multithreaded server.
thanks for all informations,as i am not finding this bit of info any where in documentations.
bye
when you connect throw @xxxx you are using the TCP-protocol, where you use username/pass you are using the IPC protocol. So check you mts-configuration in the ipc-protocol, check your listener (working fine on ipc-protocol)
drishti,
Look for ORACLE_SID env variable setting on your server.
If there,s not ORACLE_SID value, ORACLE does not which databse server you are trying to connect on and so it's need to have it specified.
You can try to verify it running server manager.
Whent the prompt appears you should see the same tns error and if yopu try top connect as internal the same error arises again.
Then set instance parameter to you instance name writing
set instance
and then try to connect internal without specifing the service name If it's running now you have to set the ORACLE_SID env variable.
hello,
i donot have multiple databases,so tahts not the case of env bvariable,i think.my mts is configured with tcp and 3 dispatchers r there.how to check mts with IPC.
thanks for all help.
drshti,
ORALCE_SID env variable is one of the mandatory Oracle env variables you must always set and not only when you have a multiple instance database!!
However the problem should be caused by a mts misconfiguration, but consider ORACLE_SID env variable too.
It's very easy to verify and faster than mts configuration.
Bye
this is a tipical mts configuration:
mts_dispatchers="ipc,1"
mts_dispatchers="tcp,9"
mts_max_dispatchers=30
mts_servers=9
mts_max_servers=100
mts_service=****
mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=***))"
mts_listener_address="(ADDRESS=(PROTOCOL=tcp) (HOST=****) (PORT=*****))"
your listener may look like this:
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= ****)
)
)
(ADDRESS =
(COMMUNITY = ******)
(PROTOCOL = TCP)
(Host = smt570) #senza Keon
(Port = 1521) #senza Keon
.....etc..etc.
Your IPC protocol (in your listener, must be before the TCP specs)