Re: STARTUP failed

From: Evan Fehlberg <evan.fehlberg_at_tpg.com.au>
Date: Tue, 10 May 2005 22:45:19 +1000
Message-ID: <4280ace5@dnews.tpgi.com.au>

As metntioned, there isn't quite enough info to answer properly. Normally,you would be conected locally to the database to do a startup. connection strings like the following shouldn't go near a TNS service. internal (for pre 9i dinousours like me)? / as sysdba?
sys/password as sysdba?

Or are you connecting as someuser_at_tnsname in which case I agree you need to look at your tnsnames.ora, sqlnet.ora nad listener.ora.

If this is a Unix implementation, you might have TWO_TASK set or something. Good luck.

"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message news:d4td40$eu6$1_at_news1.zwoll1.ov.home.nl...
> Matthias Kientz wrote:
>> I cannot start my database using STARTUP in sqlplus.
>>
>> SQL> STARTUP
>> ORA-12162: TNS:net service name is incorrectly specified
>>
>> What maybe wrong here?
>> Thanks for any help...
>
> The obvious. Your net service name (listener.ora) is incorrect
> It does help to show (cut-'n-paste) how you got this,
> what platform, etc, etc
> --
> Regards,
> Frank van Bortel
Received on Tue May 10 2005 - 07:45:19 CDT