Hi,

Our new database is behaving a little strange. Both our
Oracle Server and Client are on the same machine but while
connecting through the Client I need to specify
"username@database_name". The same does not happen when I
run sqlplus, "sqlplus scott/tiger" works. The error message thrown when
I use only "username" is

ORA-01034: ORACLE NOT AVAILABLE

The variable ORACLE_SID is appropriately set, it's pointing
to the new database name. The new database is mounted and
the listener services are up.

Someone kind of hinted that the database is created as a
remote
database. Can I check what it currently is ... I mean a
default one /
remote.

We didn't face this problem with the old database. On
comparing the init.ora files we found that the new
database did not have the db_domain name set. We tried
setting this in the init file (was done after the database
was created).

Would help if I got some hint on where and what to look for.

Thanks and Regards,
M Shetty