Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Could not log into SQL*Plus
Do not use the SID but rather, use the tnsnames.ora entry for that database
To connect to an instance called DB ( assuming that tnansmes.ora has an alias called mydb.world defined for that instance)
sqlplusw "sys/pasword_at_db.world AS SYSDBA" should do it
Or try
SqlPlusw /nolog
followed after SqlPLus opens with
connect sys/pasword_at_db.world AS SYSDBA
If your sqlnet.ora file has a NAMES.DEFAULT_DOMAIN = world
you can skip the .world in the connect string..
Peter <peter_at_nomorenewsspammin.ca> wrote:
>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
>>>
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Tue May 20 2003 - 15:36:26 CDT