RMAN: connecting to target db problem???

From: <asokol99_at_my-deja.com>
Date: 2000/04/24
Message-ID: <8e1jmk$g28$1@nnrp1.deja.com>#1/1

I have several 8.0.5 and 8.1.6 databases on the same Sun server. I created a new instance for Recovery Manager under 8.1.6 home. Created a catalog. Now i have a problem trying to connect to the target databases (and maybe i didn't read manual correctly, but it certainly is NOT explicit about that (or wrong)).

Here is the scenario:

I log into my oracle unix account.
Say, i have a database test1, created under Oracle 8.1.6. No problems connecting with "/" as you can see:
(it was already registered)

ORACLE_OWNER=oracle
ORACLE_BASE=/export/home/oracle
ORACLE_HOME=/export/home/oracle/product/8.1.6
ORACLE_DOC=/export/home/oracle/doc
ORACLE_SID=test1

cassandra% rman target / catalog rman/rman_at_rman1

Recovery Manager: Release 8.1.6.0.0 - Production

RMAN-06005: connected to target database: TEST1 (DBID=3943866115) RMAN-06008: connected to recovery catalog database

RMAN> exit

I do the same thing with slightly different command and get a problem

cassandra% rman target sys/colts_at_extract1 catalog rman/rman_at_rman1

Recovery Manager: Release 8.1.6.0.0 - Production

RMAN-00571: ====================================================
RMAN-00569: ======== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ====================================================

RMAN-00554: initialization of internal recovery manager package failed RMAN-04005: error from target database: ORA-01031: insufficient privileges

(i have password file etc).

Now, to the second problem:
say i have another database, call it DEV1, created under 8.0.5. My environment is still 8.1.6:

ORACLE_OWNER=oracle
ORACLE_BASE=/export/home/oracle
ORACLE_HOME=/export/home/oracle/product/8.1.6
ORACLE_DOC=/export/home/oracle/doc
ORACLE_SID=dev1

I issue rman command:
cassandra% rman target / catalog rman/rman_at_rman1

Recovery Manager: Release 8.1.6.0.0 - Production

RMAN-06193: connected to target database (not started) RMAN-06008: connected to recovery catalog database

Q: DO target database and catalog have to be on the same Oracle release version?
or they can be on different releases (manual doesn't mention that, or at least i couldn't find the answer).

second thing: i issue the following command:

cassandra% rman target sys/revolution_at_dev1 catalog rman/rman_at_rman1

Recovery Manager: Release 8.1.6.0.0 - Production

RMAN-00571: ======================================================
RMAN-00569: ========== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ======================================================

RMAN-00554: initialization of internal recovery manager package failed RMAN-04005: error from target database: ORA-01017: invalid username/password; logon denied

Now I can't even connect. (it looks like I had no problems in the previous example) Why? (looks like it relates to the first problem). Again, i created password file etc, but then again, i'm trying to log as SYS, so theoretically i don't even need password file.

Can someone clear me on rman, please.

Thanks, Alex Sokol
Boston Communications Group.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Apr 24 2000 - 00:00:00 CDT