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 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mranalini Shetty INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
