Re: Creating a **DEFAULT** database

You have to check TNSNAMES.ORA in the home where the client or SQL*Plus is installed. Check the entry for the new database. You may need to add it if there is no such an entry.

Cheers,
Valentin

"mshetty" <mshetty_at_mail.com> wrote in message news:bfbb8fd4.0207270200.6bbc4bb6_at_posting.google.com...
> 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_at_database_name". The same does not
> happen when I run sqlplus, "sqlplus scott/tiger" works.
>
> 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<SID>.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
Received on Sun Jul 28 2002 - 17:45:56 CEST