Re: Creating a **DEFAULT** database

Forgot to mention the error msg that I get on connecting using just the
"username" --

ORA-01034: ORACLE NOT AVAILABLE
Thanks and Regards,
Mranalini

Mranalini Shetty wrote:

> 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>> --> Please see the official ORACLE-L FAQ: http://www.orafaq.com> --> Author: Mranalini Shetty> INET: mranalini.shetty_at_patni.com>> 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: ListGuru_at_fatcity.com (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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mranalini Shetty
INET: mranalini.shetty_at_patni.com
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: ListGuru_at_fatcity.com (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).