Dbca
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Dbca as PDF for free.
More details
- Words: 154
- Pages: 1
DATABASE CONFIGURATION ASSISTANT
We can create the multiple databases with Database configuration assistant and manual method first we have to see the D.B.C.A, in this we have two types of process one is existing user and next one is Different user. Existing user • • • •
First we have to create the new Sid name in the env file. If have any another Sid exist in env file comment that Sid. Check x-window display is working or not. Next run the Database configuration assistant command (dbca).
Different user • • • • • • •
Create a new user by logging in as root user. Change the permissions of new user as user itself. Check for the permissions and ownership of /etc/oratab and /etc/oratab If If those are available Change the permissions of $ORACLE_HOME/dbs. Change the permissions of $ORACLE_BASE/admin. Change the permissions of $ORACLE_BASE/oradata. Comment the remote_login_password =’EXCLUSIVE’ in parameter file if Necessary.
We can create the multiple databases with Database configuration assistant and manual method first we have to see the D.B.C.A, in this we have two types of process one is existing user and next one is Different user. Existing user • • • •
First we have to create the new Sid name in the env file. If have any another Sid exist in env file comment that Sid. Check x-window display is working or not. Next run the Database configuration assistant command (dbca).
Different user • • • • • • •
Create a new user by logging in as root user. Change the permissions of new user as user itself. Check for the permissions and ownership of /etc/oratab and /etc/oratab If If those are available Change the permissions of $ORACLE_HOME/dbs. Change the permissions of $ORACLE_BASE/admin. Change the permissions of $ORACLE_BASE/oradata. Comment the remote_login_password =’EXCLUSIVE’ in parameter file if Necessary.
