ggnagaraj : Here is what I got

[rjayaleela]

When I did tnsping jaya I got
TNS-03505 : Failed to resolve name

[jovery]

Did you save the network configuration before you exited the Net8 config utility?

Regards

[rjayaleela]

I have followed all the steps shown in Net 8 Configuration Assistant. At the end I pressed finish. One more thing is I can view jaya under service Naming under Local under Net8 configuration in Net 8 Assistant and I saved it.But still when I open SQL Plus I get could not resolve service name.
Please help.

[jovery]

Can you post the contents of you $ORACLE_HOME/network/admin/tnsnames.ora so we can see how the service has been defined.

Also do you have multiple ORACLE_HOMES? If so have you made sure the tnsnames.ora file in each has the service defined?

Regards

[rjayaleela]

here is my tnsnames.ora file content..
# TNSNAMES.ORA Network Configuration File: D:\ORCL\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

JAYA.=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
)
(CONNECT_DATA =
(SID = APPS)
)
)

I dont have any multiple copies of tnsnames.ora.
I didnot get your second question :
>> Do you have multiple ORACLE_HOMES ?
IN MY D: directory I have another directory called Oracle8.0.Should I delete it.

[rjayaleela]

# TNSNAMES.ORA Network Configuration File: D:\ORCL\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

JAYA.{value}=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = {ip address})(PORT = 1521))
)
(CONNECT_DATA =
(SID = APPS)
)
)

here {value} is same as NAMES.DEFAULT_DOMAIN value in sqlnet.ora.

[ggnanaraj]

Originally posted by rjayaleela
(SID = APPS)

Do one thing, go to the database server and using sqlplus, give username: internal and press enter without entering anything in the other 2 fields.

Now, at sql prompt, type the following...

select * from v$instance;

Now, is the instance_name column (from the query) and your SID value quoted above (from the tnsnames.ora) the same ?

If not, change and retry the connection from the client.

HTH.

[jovery]

It may be that your default ORACLE_HOME is still the 8.0 one an easy way to test that would be to copy the tnsnames.ora and sqlnet.ora from your 8.1 home to the network/admin (or more likely net80/admin) in the 8.0 directory tree, then try to connect via SQLPlus.

If that works you will need to deinstall the 8.0 home and check your registry entries to make sure it is using the correct default home

Oracle client installs on windoz are just great fun

Regards

[rjayaleela]

I cant access anything from server machine. I have access only to my machine which connects as client to remote server.

[rjayaleela]

Hi Jovery,
In the registry I have checked the values for ORACLE_HOME and ORACLE_HOME_NAME

they point to the correct directory where Oracle is installed. One thing let me know where is there a problem : In configuring Oracle Client or in installation.