LEARN TO DO MANUAL INSTALLATION OF THE DATABASE IN JUST 6 STEPS
As oracle users I fired the following commands to make changes in oracle bashprofile.
echo "alias sid='echo "'$ORACLE_SID'"'" >> /home/oracle/.bash_profile
echo "alias bash='vi /home/oracle/.bash_profile'" >> /home/oracle/.bash_profile
echo "alias ebash='. /home/oracle/.bash_profile'" >> /home/oracle/.bash_profile
echo "alias pmon='ps -ef|grep pmon'" >> /home/oracle/.bash_profile
echo "alias conn='sqlplus "/ as sysdba"'" >> /home/oracle/.bash_profile
echo "alias cl='clear'" >> /home/oracle/.bash_profile
in my vmmachine i have the pre created database with name ORCL
and i will create a new database with name as “newdb”
1. First we will make the required necesaary folders.
we will copy all the folders present in the orcl folder to the new folder "newdb" at the same location and and empty all the folders except the pfile folder with the init file.
[oracle@localhost ~]$ cd /u01/app/oracle/admin/
]$ cp -R orcl/ newdb/
]$ cd newdb/
]$ cd udump/
]$ rm -rf *
]$ cd ../dpdump/
]$ rm -rf *
]$ cd ../cdump/
]$ rm -rf *
]$ cd ../bdump/
]$ rm -rf *
]$ cd ../adump/
]$ rm -rf * 2.
we will make the changes in the pfile. Replace the orcl word with newdb in the complete file.
[oracle@localhost ~]$ vi /u01/app/oracle/admin/newdb/pfile/init.ora.4252011152834 3.
inside the oradata folder i created the new folder "newdb" where all my CDR files will be built.
[oracle@localhost ~]$ cd /u01/app/oracle/oradata/ mkdir newdb
4. we have just created the password file in the dbs folder.
[oracle@localhost ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs/ orapwd file=orapwnewdb password=shoaib entries=5 force=y 5.
now we will create the database with the create database command.
]$ export ORACLE_SID=newdb
]$ sqlplus / as sysdba startup nomount pfile=/u01/app/oracle/admin/newdb/pfile/init.ora.4252011152834
The create database script:
create database newdb
logfile group 1 ('/u01/app/oracle/oradata/newdb/redo1.log') size 100M,
group 2 ('/u01/app/oracle/oradata/newdb/redo2.log') size 100M
character set WE8ISO8859P1
national character set utf8
datafile '/u01/app/oracle/oradata/newdb/system.dbf' size 500M autoextend on next 10M maxsize unlimited extent management local
sysaux datafile '/u01/app/oracle/oradata/newdb/sysaux.dbf' size 100M autoextend on next 10M maxsize unlimited
undo tablespace undotbs1 datafile '/u01/app/oracle/oradata/newdb/undotbs1.dbf' size 100M default temporary tablespace temp tempfile '/u01/app/oracle/oradata/newdb/temp01.dbf' size 100M
6. here the database will be created, now we will execuete the catalog and catproc scripts.
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
hence the manual installation is complete.
© shoaibansari73@gmail.com
As oracle users I fired the following commands to make changes in oracle bashprofile.
echo "alias sid='echo "'$ORACLE_SID'"'" >> /home/oracle/.bash_profile
echo "alias bash='vi /home/oracle/.bash_profile'" >> /home/oracle/.bash_profile
echo "alias ebash='. /home/oracle/.bash_profile'" >> /home/oracle/.bash_profile
echo "alias pmon='ps -ef|grep pmon'" >> /home/oracle/.bash_profile
echo "alias conn='sqlplus "/ as sysdba"'" >> /home/oracle/.bash_profile
echo "alias cl='clear'" >> /home/oracle/.bash_profile
in my vmmachine i have the pre created database with name ORCL
and i will create a new database with name as “newdb”
1. First we will make the required necesaary folders.
we will copy all the folders present in the orcl folder to the new folder "newdb" at the same location and and empty all the folders except the pfile folder with the init file.
[oracle@localhost ~]$ cd /u01/app/oracle/admin/
]$ cp -R orcl/ newdb/
]$ cd newdb/
]$ cd udump/
]$ rm -rf *
]$ cd ../dpdump/
]$ rm -rf *
]$ cd ../cdump/
]$ rm -rf *
]$ cd ../bdump/
]$ rm -rf *
]$ cd ../adump/
]$ rm -rf * 2.
we will make the changes in the pfile. Replace the orcl word with newdb in the complete file.
[oracle@localhost ~]$ vi /u01/app/oracle/admin/newdb/pfile/init.ora.4252011152834 3.
inside the oradata folder i created the new folder "newdb" where all my CDR files will be built.
[oracle@localhost ~]$ cd /u01/app/oracle/oradata/ mkdir newdb
4. we have just created the password file in the dbs folder.
[oracle@localhost ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs/ orapwd file=orapwnewdb password=shoaib entries=5 force=y 5.
now we will create the database with the create database command.
]$ export ORACLE_SID=newdb
]$ sqlplus / as sysdba startup nomount pfile=/u01/app/oracle/admin/newdb/pfile/init.ora.4252011152834
The create database script:
create database newdb
logfile group 1 ('/u01/app/oracle/oradata/newdb/redo1.log') size 100M,
group 2 ('/u01/app/oracle/oradata/newdb/redo2.log') size 100M
character set WE8ISO8859P1
national character set utf8
datafile '/u01/app/oracle/oradata/newdb/system.dbf' size 500M autoextend on next 10M maxsize unlimited extent management local
sysaux datafile '/u01/app/oracle/oradata/newdb/sysaux.dbf' size 100M autoextend on next 10M maxsize unlimited
undo tablespace undotbs1 datafile '/u01/app/oracle/oradata/newdb/undotbs1.dbf' size 100M default temporary tablespace temp tempfile '/u01/app/oracle/oradata/newdb/temp01.dbf' size 100M
6. here the database will be created, now we will execuete the catalog and catproc scripts.
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
hence the manual installation is complete.
© shoaibansari73@gmail.com
No comments:
Post a Comment