Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN: connecting to target db problem???
i guess if we can run recovery manager through sqlnet...(the default mode is no).
asokol99_at_my-deja.com wrote in message <8e1jmk$g28$1_at_nnrp1.deja.com>...
>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