DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RMAN and the listener

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    Question RMAN and the listener

    I have Oracle 9.2 on my machine at home. I created a test database and a RMAN catalog. I am able to do a backup using the controlfile with no problem. When I try to do a backup using the catalog I have problems with the listener. I think I am doing it wrong. Here are the steps:

    SET ORACLE_SID=TESTDB
    rman target testdba/testdba
    **gives message that I am connected to TESTDB**
    rman> connect catalog rcatuser/rcatuser@rcat
    **gives message that I am connected to catalog***
    rman>shutdown immediate
    **shuts down **
    rman>startup mount
    **Here is where I get my error that ir cannot resolve service name**


    It seems before I shutdown the database and do a lsnrctl status the TESTDB is in there. Once I shut down the database the listener stops looking for that database. If I stop and start the listener when the database is down it does not show up under lsnrctl status. I did not think that the listener was dependent on the database being up. I thought as long as it is in the listener.ora file I was set. Do I have my listener configured wrong or am I doing the wrong thing in RMAN?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Your catalog is in the same DB you are trying to backup?
    Jeff Hunter

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    No

    The catalog is in a database called RCAT and the database that I am trying to backup is TESTDB.

  4. #4
    Join Date
    Jan 2001
    Posts
    515

    Registering Automatically

    I did some more research on Metalink and it seems like my databases are registering with the listener when they startup and unregistering when they shutdown. I think it has something to do with my init.ora parameter instance_name. It is explained in doc 69546.1. How would I stop this behaviour from happening. Can't I have my listener just use the listener.ora file???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width