Oracle SID for 8i

[Shiva]

Hi all, I am having a wierd issue here. I downloaded Oracle8i (8.1.7) from technet.oracle.com and have successfully installed it (though it is an older version, that is what is used by the client). Now, when I use Net8 Asisstant GUI on the client to connect to the server, the server is recognized only when I mention the SID for this field "(Oracle 8 or Previous) SID" and not for "(Oracle 8i) Service Name " - though it is Oracle 8i. I tired even global database name. Can anyone point to me why is this so ?

Shiva.

[pando]

well what does your tnsnames.ora say?


like this

DEV901 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pando)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dev901)
)
)


or something like this

DEV901 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pando)(PORT = 1521))
)
(CONNECT_DATA =
(SID = dev901)
)
)

[Shiva]

Yes, that is the problem - my TNSNAMES is showing SID and not SERVICE_NAME.

Shiva.


[Edited by Shiva on 04-24-2002 at 01:49 PM]

[sanjay92]

Check you service_name parameter in init.ora or connect to database using sys
sql> show parameter service_names

If there is no value then edit your init.ora to include
service_names=YourServiceName
This is the service name, you could use in your tnsnames.ora

Sanjay

Originally posted by pando
well what does your tnsnames.ora say?


like this

DEV901 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pando)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dev901)
)
)


or something like this

DEV901 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pando)(PORT = 1521))
)
(CONNECT_DATA =
(SID = dev901)
)
)

[pando]

by default service_names is db_name.db_domain so it is not really necessary specify it in init.ora

[sanjay92]

But you could specify a different service name by using this parameter. Infact you could define multiple service names by using this parameter.

Sanjay

Originally posted by pando
by default service_names is db_name.db_domain so it is not really necessary specify it in init.ora

[pando]

um what do you multiple service name...?
you mean you can put several service_names in init.ora?

[pando]

ah I know what do you mean forget last post

however the post was not really about this

[Shiva]

I have Oracle 8i (8.1.7) version, but why does it expect SID and not Service name while connecting from the client to the server?

Shiva.

[pando]

because you configured it so, when you use netassistant it asks you something like you want to configure tnsnames.ora for 8 or 8i and I think you put 8 so it generated a version 8 tnsnames.ora