Re: Could not log into SQL*Plus

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Tue, 20 May 2003 20:11:19 GMT
Message-ID: <bo2lcvcsgf0rp3bm575ghjpvjnkvjmr1rh@4ax.com>

On Sat, 10 May 2003 16:28:45 GMT, faked_at_spam.me.not.com (Jeremy Russell) wrote:

Suppose my databse name is DB
I typed
sqlplusw "sys/password_at_DB as sysdba"
but it still complained that "the service name cannot be resolved" with a Windows dialog box popping up.
I tried
sqlplusw "sys/password_at_OracleServiceDB as sysdba" still it complained that "the service name cannot be resolved" with a Windows dialog box popping up.

What could be the problem?

Thanks

>I think you want this:
>
>sqlplusw "sys/password_at_SID as sysdba"
>
>i.e. put the entire string in double quotes and replace the password
>and SID above with your own values.
>
>YMMV
>
>On Sat, 10 May 2003 09:35:51 GMT, Peter <peter_at_nomorenewsspammin.ca>
>wrote:
>
>>I tried to login SQL*PLUS graphical tool as "SYS as SYSDBA"
>>But what should I enter for "host string" text box?
>>
>>I even tried the command line
>>"sqlplusw sys as sysdba/password"
>>
>>The manual is not very clear on the correct syntax.
>>Does anyone know?
>>Thanks
>>
Received on Tue May 20 2003 - 15:11:19 CDT