Installation and Upgrade

Creating a 11g Database Manually by Scripts (3/3) – Configure local naming and password file for outside users

Posted on
Creating a 11g Database Manually by Scripts (2/3) – Create and check the new databaseEven though the database is created, but it has not been connected from outside. You should configure an entry of local naming for the new database on application servers or client machines.Add a service naming on a client machine.On Windows platform, use […]
Installation and Upgrade

Creating a 11g Database Manually by Scripts (2/3) – Create and check the new database

Posted on
Creating a 11g Database Manually by Scripts (1/3) – Prepare three files for creating the new databaseWhen the three files are ready, we can use them to create a new database “smalldb”.Set the environment profile.[oracle@primary01 ~]$ . smalldb_profile[oracle@primary01 ~]$ echo $ORACLE_SIDsmalldb[oracle@primary01 ~]$ echo $ORACLE_HOME/u01/app/oracle/product/11.2.0/db_1Do other preparation works and create pfile.[oracle@primary01 ~]$ ./create_init.sh[oracle@primary01 ~]$ cat $ORACLE_HOME/dbs/initsmalldb.oracontrol_files […]
Installation and Upgrade

Creating a 11g Database Manually by Scripts (1/3) – Prepare three files for creating the new database

Posted on
Go Back to Overview Page – Creating a 11g Database Manually by Scripts (0/3) – An overviewHere are the three files we prepared for facilitating the creation of the database.An environmental profile can set the environment vairables of the new database.[oracle@primary01 ~]$ vi smalldb_profileORACLE_SID=smalldb; export ORACLE_SIDORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1; export ORACLE_HOMEWe call the new database “smalldb” and keep […]