Setup ORACLE_SID name
SID is PODB.
export ORACLE_SID=PODB
Setup the parameter file: init$ORACLE_SID.ora
- DB_NAME
- DB_BLOCK_SIZE
- SGA_TARGET
- CONTROL_FILES
- UNDO_MANAGEMENT
The file is under $ORACLE_HOME/dbs
DB_NAME=PODB
DB_BLOCK_SIZE= 8192
SGA_TARGET = 300M
CONTROL_FILES=/home/oracle/app/oracle/oradata/podb/controlfile/PODB_controlfile.ctl
UNDO_MANAGEMENT = AUTO
Create all the directory and grant the permission
Create database
- Startup with nomount
- NO OMF: db_create_file_dest
startup nomount pfile=/home/oracle/app/oracle/product/11.2.0/dbhome_2/dbs/initPODB.ora
@/home/oracle/app/oracle/oradata/podb/createdb.sql
Run the createdb.sql. Here is my createdb.sql
create database PODB
user sys identified by oracle
user system identified by oracle
MAXLOGFILES 5
MAXLOGMEMBERS 5
LOGFILE GROUP 1 ( '/home/oracle/app/oracle/oradata/podb/logfile/redo01a.log','/home/oracle/app/oracle/oradata/podb/logfile/redo01b.log') SIZE 30M, GROUP 2 ('/home/oracle/app/oracle/oradata/podb/logfile/redo02a.log','/home/oracle/app/oracle/oradata/podb/logfile/redo02b.log') size 30M
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/home/oracle/app/oracle/oradata/podb/controlfile/system01.dbf' SIZE 300M
SYSAUX DATAFILE '/home/oracle/app/oracle/oradata/podb/controlfile/sysaux01.dbf' SIZE 300M
DEFAULT TABLESPACE users DATAFILE '/home/oracle/app/oracle/oradata/podb/controlfile/user01.dbf' SIZE 300M AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts TEMPFILE '/home/oracle/app/oracle/oradata/podb/controlfile/tempts01.dbf' SIZE 300M
UNDO TABLESPACE undots DATAFILE '/home/oracle/app/oracle/oradata/podb/controlfile/undots01.dbf' SIZE 300M AUTOEXTEND ON MAXSIZE UNLIMITED
Check database
select STATUS from V$INSTANCE;
select name from V$DATABASE;
select name from V$DATAFILE;
select name from V$TEMPFILE;
select name from V$CONTROLFILE;
select GROUP#,member from V$LOGFILE;
select NAME from V$TABLESPACE;
-- check the users / dba_users
select NAME from SYS.USER$ where TYPE#=1;
-- check the roles
select NAME from sys.user$ where type#=0;
Dictionary related tables are not usable because we are not yet create those tables.
Post DB creation
Please refer here for more detail.
-
Create the oracle password file to enable the remote login as sysdba
Please refer here for more detail.
-
Create Data Dictionary and Build-in Package
-
Create SQL PLUS related tables
orapwd file=$ORACLE_HOME/dbs/orapwPODB password=orcl
spool /tmp/PODB_POST.log
show user
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
connect system/oracle
@?/sqlplus/admin/pupbld.sql
spool off
Thanks for sharing this informative article to our vision.
ReplyDeleteRegards.
Oracle Apps Training in Chennai
Great Article Artificial Intelligence Projects
DeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
ReplyDeleteThanks for sharing with us that awesome article you have amazing blog.....
http://hadooptraininginhyderabad.co.in/salesforce-training-in-hyderabad/
Using the CREATE DATBASE SQL statement is a more manual approach to creating a database. If you use the CREATE DATABASE statement, you must complete additional actions before you have an operational database. These actions include building views on the data dictionary tables and installing standard PL/SQL packages. You perform these actions by running prepared scripts. If you have existing scripts for creating your database, consider editing those scripts to take advantage of new Oracle Database features.If anyone interested to take Oracle Apps Fusion Online Training, please reach us KBS Training located at Bangalore. Rated as best training institute in Bangalore.
ReplyDeleteThis tutorial explains how to create a database, tables, and insert row ... how to enter the values by using “&” in mysql table ..from command prompt? .... R Programming Training | DataStage Training | SQL Training | SAS Training | Android Training | SharePoint Training
ReplyDelete
ReplyDeletePleasant Post. It is truly intriguing to peruse from the earliest starting point and I might want to share your site to my circles, continue sharing more like this.
SAS Training in Chennai | SAS course in Chennai
Thanks for sharing in useful information
ReplyDeleteExtraordinary and the maximum interesting records. that is simply the form of statistics that i had
Been searching out, i'm already your rss reader now and i might often be careful with the present day posts.
oracle fusion procurement online training
oracle fusion procurement training
Thanks for sharing the useful information and good points were stated in the article and for the further information visit our site
ReplyDeleteOracle Fusion Financials Training
Hi,
ReplyDeletethanks for sharing such a nice topic.
oracle fusion SCM online training
HI,
ReplyDeleteTHIS IS VERY INTERESTING BLOG. thanks for sharing such a nice blog.
oracle fusion HCM training.
HI,
ReplyDeletethis is very interesting topic. Thanks for sharing such A NICE TOPIC.
oracle fusion HCM training.
Red Hat offers virtualization as an Operating system feature. Red Hat dropped support for Xen hypervisor with Red Hat Enterprise Linux 6.0 and Fedora 12 in favor of commercial KVM (Kernel Based Virtual Machine) x86 virtualization solution. salesforce custom dashboard
ReplyDeleteNeeded to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here"Oracle Training in Chennai".
ReplyDeleteNeeded to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here"Oracle Training in Chennai".
ReplyDeleteIt has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted "Oracle Training in Bangalore".
ReplyDeleteinformative blog thanks for providing such a great information.
ReplyDeleteSalesforce Online Training in Hyderabad
Salesforce Online Training in Kukatpally
Salesforce Online Training in Madhapur
Salesforce Training in Kukatpally
Salesforce Training in Madhapur
Really clear information that how to create a database using script.
ReplyDeleteThanks for posting.
Professional Salesforce Training in Hyderabad@ Techiemills. we offer both classroom & online training with realtime projects + placement assistance . ( for students & professionals)
salesforce training in Hyderabad
salesforce training in Kphb
Looks intresting.. thanks for sharing
ReplyDeleteNow-a-days slaesforce became an trending platform, looking to learn salesforce?
Contact us@Capitalinfosolutions
slaesforce online training
slaesforce Integration training
slaesforce online training
capitalinfosolutionsindia
Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.oracle training in chennai.
ReplyDeletedevops training in bangalore
devops training in bangalore
devops training in chennai
oracle training in bangalore
Thanks for sharing the valuable information with this site it will be useful for the people like beginners. Thank you and please keep updating like this information with this sites.
ReplyDeleteSAP S/4 HANA Simple Finance Training in Hyderabad
You are doing a great job. I would like to appreciate your work for good accuracy
ReplyDeleteRegards,
Best Devops Training in Chennai | Best Devops Training Institute in Chennai
I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
ReplyDeleteDevops Training in Chennai | Devops Training Institute in Chennai
Amazing Post Thanks for sharing
ReplyDeleteVMware Training in Chennai
DevOps Training in Chennai
DevOps Certification in Chennai
thnks for sharing to learn through sql online training
ReplyDeleteYou have provided a nice information ceh certification
ReplyDeleteYou might comment on the order system of the blog. You should chat it's splendid. Your blog audit would swell up your visitors. I was very pleased to find this site.I wanted to thank you for this great read!!
ReplyDeleteOracle Training | Online Course | Certification in chennai | Oracle Training | Online Course | Certification in bangalore | Oracle Training | Online Course | Certification in hyderabad | Oracle Training | Online Course | Certification in pune | Oracle Training | Online Course | Certification in coimbatore
Thank you for posting informative insights, I think we have got some more information to share with! Do check out Oracle Training In Chennai , Oracle PLSQL Training In Chennai , Oracle DBA Training In Chennai , AWS Training in Chennai and let us know your thoughts. Let’s have great learning!
ReplyDeleteWorth reading! Our experts also have given detailed inputs about these trainings & courses! Presenting here for your reference. Do checkout
ReplyDeleteaws training in chennai & enjoy learning more about it.