Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g creates virtual private directory RMAN-06004 ORA-00942 error handling     - MySQL bulk insert data script (Database)

- php security study (Linux)

- MyCAT log analysis (Database)

- Boost-- time and date - (1) timer library introduction (Programming)

- To establish a secure and reliable Linux operating system (Linux)

- Java in several ways of using MongoDB (Programming)

- There are three ways to run a Linux operating system from a USB stick (Linux)

- Ubuntu PPA install SMPlayer 14.9 (Linux)

- Linux commands to access the cheat sheet (Linux)

- Ambari and Hadoop configuration, management and monitoring of the project Getting (Server)

- Install VLC player on Ubuntu 14.10 (Linux)

- build Android environment on Ubuntu 12.04 (Server)

- How to force Linux users to change the initial password the first time you log in (Linux)

- Python class of operator overloading (Programming)

- Java environment to build a number of issues (Linux)

- MongoDB3.0.x version of the user authorization profile (stand-alone environment) (Database)

- C ++ free store and heap (Programming)

- Why do you need close contact Rust 1.0 (Programming)

- Delegate in C # (Programming)

- Proficient in C / C ++ can also find a very good job (Programming)

 
         
  Oracle 11g creates virtual private directory RMAN-06004 ORA-00942 error handling
     
  Add Date : 2017-08-31      
         
         
         
  A user in Linux under 11.2.0.4 to create RMAN virtual private directory error:
[Oracle @ jb ~] $ rman

Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:23:25 2015

Copyright (c) 1982, 2011, Oracle and / or its affiliates. All rights reserved.

RMAN> connect catalog vpc1 / vpc1 @ cs

Connected to recovery catalog database

RMAN> create virtual catalog

Found eligible base catalog owned by RMAN
RMAN-00571: ============================================== =============
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ============================================== =============
RMAN-06004: ORACLE error from recovery catalog database: ORA-00942: table or view does not exist


From the above information you can see the list of qualified base catalog owned by RMAN, that has found a qualified basic recovery directory users, because the use of the basic recovery directory user rman has registered the database, then create a basic recovery directory user cat1, virtual private directory User virtcat

1. Create a basic recovery directory user cat1, a virtual private directory user virtcat
SQL> create user cat1 identified by cat1
  2 default tablespace sysaux
  3 quota unlimited on sysaux;

User created.

SQL> grant recovery_catalog_owner to cat1;

Grant succeeded.

SQL> create user virtcat identified by virtcat
  2 default tablespace sysaux
  3 quota unlimited on sysaux;

User created.

SQL> grant recovery_catalog_owner to virtcat;

Grant succeeded.


2. Create a basic recovery catalog
[Oracle @ jb ~] $ rman catalog cat1 / cat1 @ cs

Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:24:50 2015

Copyright (c) 1982, 2011, Oracle and / or its affiliates. All rights reserved.

Connected to recovery catalog database

RMAN> create catalog;

Recovery catalog created

RMAN> grant register database to virtcat;

Grant succeeded.

3. Create a virtual private recovery directory
[Oracle @ jb cs] $ rman catalog virtcat / virtcat @ cs

Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:25:40 2015

Copyright (c) 1982, 2011, Oracle and / or its affiliates. All rights reserved.

Connected to recovery catalog database

RMAN> create virtual catalog

Found ineligible base catalog owned by RMAN
Found eligible base catalog owned by CAT1
Created virtual catalog against base catalog owned by CAT1


4. Register the target database in the virtual private directory
[Oracle @ jb cs] $ rman target sys / system @ db catalog virtcat / virtcat @ cs

Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:46:51 2015

Copyright (c) 1982, 2011, Oracle and / or its affiliates. All rights reserved.

Connected to target database: DB (DBID = 1640573015)
Connected to recovery catalog database

RMAN> register database;

Database registered in recovery catalog
Starting full resync of recovery catalog
Full resync complete


Summary: When creating and using a virtual private recovery directory, the target database can not be registered in the basic recovery catalog, or the RMAN-06004, ORA-00942 error messages occur.
     
         
         
         
  More:      
 
- CentOS yum configuration under local sources (Linux)
- To learn linux security (Linux)
- Security Features Linux and Unix operating system, programming (Linux)
- Nginx DHCP TFTP Kickstart set up automatic installation system (Server)
- Generators and iterators in Python (Programming)
- Docker deployment practices in Ubuntu (Server)
- How to manage KVM virtual environments with command-line tools in Linux (Server)
- Kickstart automated installation and deployment RHEL 7.0 (Linux)
- Oracle rebuild index script (Database)
- After CentOS configure SSH password Free, still prompted for a password (Linux)
- Install multiple Linux distributions and Fedora 21 first experience on the same hard disk (Linux)
- How to use SVN to manage our source code (Server)
- CentOS card fails to start at boot progress bar certmonger solve (Linux)
- HTML5 postMessage cross-domain data exchange (Programming)
- Transfer files to Windows and Linux (Linux)
- Linux raw socket (Programming)
- MySQL flip-flop (Database)
- To help you easily protect the Linux System (Linux)
- Gentoo: startx problem appears Failed to load module (Linux)
- Linux network cut package is not fully defragment (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.