4/16/08

Running Oracle DBCA(Database Confguration Assistance) remotely

There are two ways to create a new database on existing oracle db server. One is using 'CREATE DATABASE' sql statement[this is too long,hard for me]. Another is using DBCA(Database Confguration Assistance), GUI Base Program. This way is more easy and I choose this way:). One note here is DBCA need X to run and I want to remote login to db server and run dbca from ssh, so ssh need '-X' for X11 forward[assume that DISPLAY variable on server is set, if not try 'export DISPLAY=localhost:0.0' on the server].

[poj@fedev ~]$ ssh -X -l oracle 192.168.1.59
oracle@192.168.1.59's password:
Last login: Wed Apr 16 15:11:14 2008 from 192.168.1.122
/usr/X11R6/bin/xauth: creating new authority file /home/oracle/.Xauthority
[oracle@k8n ~]$ cd /u01/app/oracle/product/10.1.0/db_1/bin
[oracle@k8n bin]$ dbca

0 comments: