Re: Help: Problem registering a database with RMAN on 8.1.7

Hi,

From the error dump, it seems you've connected to your target database via a dispatcher (ie: using MTS) - RMAN doesn't like this. To check whether your databases are running in MTS mode run:

$ ps ax | grep ora

If you see any processes like 'ora_d000_prd1' and 'ora_s000_prd1' then you can be sure your database is running in MTS mode. To prevent RMAN from connecting via a dispatcher, make a new entry in tnsnames.ora for each of your databases, using the "SRVR=DEDICATED" clause.

eg:
PRD1_D =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=<your host>)(PORT=1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = PRD1.WORLD)
(SRVR = DEDICATED)

    )
  )

For good measure, make a similar entry for your TST3 database. Test the new service names work using sqlplus, then you can use them with RMAN to ensure that it uses dedicated network connections to your catalog and target databases:

$ rman catalog user/pwd_at_tst3_d target user/pwd_at_prd1_d

Let me know if you still have a problem (my rman/817/linux setup works fine...)

hth,
Regards,
Steve Blomeley Received on Sun Apr 22 2001 - 17:44:47 CDT