Re: Connecting to Oracle Instances - N00B

Shadow wrote:
> I'm trying to connect to a specific Oracle instance on my localhost.
> If I do:
>
> - sqlplus connect as system/passwd_at_instance as sysdba
>
> should that connect me?
>

No.
Before giving the correct command, do you want to connect as sysdba?

sqlplus "/ as sysdba"
or:
sqlplus /nolog
SQL> connect / as sysdba

would be preferred, or else:

sqlplus system/manager_at_tns_alias

If you really want system and sysdba, try: sqlplus "system/manager_at_tns_alias as sysdba"

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...