Unable to Connect at Command Line 1

[JohnBates]

hi all,

This is the current path:

C:\oracle\product\10.2.0>connect SYS/pnclAF07@fs9enft1 as SYSDBA

I've changed the directory path several times, but always get "connect is not a recognized command"

Waht is wrong?

Thanks, john

 

[commatom]

Um I think I need more info to help...

Are you trying to connect to SQL*Plus?

And where are you connecting from? A command line prompt?

 

[JohnBates]

Thanks for asking commatom.

I finally got it....I was trying to connect to a user db, but within the RMAN backup tool. This worked:

RMAN> connect target sys/servername@UserDatabasename

"connected to target database.... "

I'm not very good with the syntax yet.

They don't make it easy

Thanks, John

 

[LGTObug]

Hello,

If you want to connect via commandline and SQLPLUS, use the following syntax:

sqlplus <username>/<password>@<database_sid>

If you want to connect via RMAN:

With Catalog:
rman target <username>/<password>@<database_sid> catalog <username>/<password>@<database_sid>

Without Catalog:

rman target <username>/<password>@<database_sid> nocatalog





Oracle RMAN Catalog:

The "RMAN Catalog" "is another Database Instance" which keeps the Information about the Oracle Backups made with rman.
It´s advisable for backing up more than one database and to keep the Backup Information centrally in one Database.

If you dont use a catalog the Backupinformation will be saved in the Controlfile.



I hope it helps.
Regards

 

[JohnBates]

Thanks LGTObug. being new to Oracle, it is difficult for me when the connection sysntax is different for RMAN than with SqlPlus. But I got it to work by using "target".

and thanks for the info about With Catalog - good tip.

John