{"id":581,"date":"2023-11-21T22:03:35","date_gmt":"2023-11-21T22:03:35","guid":{"rendered":"https:\/\/test.samplewebsitelink.com\/ordba\/?p=581"},"modified":"2023-11-21T22:03:37","modified_gmt":"2023-11-21T22:03:37","slug":"create-data-base","status":"publish","type":"post","link":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/","title":{"rendered":"CREATE DATA BASE"},"content":{"rendered":"\n
\"\"\/<\/figure>\n\n\n\n

CREATE DATA BASE<\/p>\n\n\n\n

(1) you must be logged in as SYS with SYSDBA privilege invoked.<\/p>\n\n\n\n

(2) you must have edited initmynewdb.ora file to spawn an oracle instance<\/p>\n\n\n\n

(3) and you started the oracle instance in nomount mode.<\/p>\n\n\n\n

(4) after the database is created you are also to create the medata and plsql packages<\/p>\n\n\n\n

Example<\/p>\n\n\n\n

connect \/ as sysdba<\/p>\n\n\n\n

startup nomount pfile=$ORACLE_HOME\/dbs\/initmynewdb.ora<\/p>\n\n\n\n

CREATE DATABASE mynewdb<\/p>\n\n\n\n

USER SYS IDENTIFIED BY pz6r58<\/p>\n\n\n\n

USER SYSTEM IDENTIFIED BY y1tz5p<\/p>\n\n\n\n

LOGFILE GROUP 1 (‘\/u01\/oracle\/oradata\/mynewdb\/redo01.log’) SIZE 100M,<\/p>\n\n\n\n

GROUP 2 (‘\/u01\/oracle\/oradata\/mynewdb\/redo02.log’) SIZE 100M,<\/p>\n\n\n\n

GROUP 3 (‘\/u01\/oracle\/oradata\/mynewdb\/redo03.log’) SIZE 100M<\/p>\n\n\n\n

MAXLOGFILES 5<\/p>\n\n\n\n

MAXLOGMEMBERS 5<\/p>\n\n\n\n

MAXLOGHISTORY 1<\/p>\n\n\n\n

MAXDATAFILES 100<\/p>\n\n\n\n

MAXINSTANCES 1<\/p>\n\n\n\n

CHARACTER SET US7ASCII<\/p>\n\n\n\n

NATIONAL CHARACTER SET AL16UTF16<\/p>\n\n\n\n

DATAFILE ‘\/u01\/oracle\/oradata\/mynewdb\/system01.dbf’ SIZE 325M REUSE<\/p>\n\n\n\n

EXTENT MANAGEMENT LOCAL<\/p>\n\n\n\n

SYSAUX DATAFILE ‘\/u01\/oracle\/oradata\/mynewdb\/sysaux01.dbf’ SIZE 325M REUSE<\/p>\n\n\n\n

DEFAULT TABLESPACE tbs_1 datafile ‘\/u01\/oracle\/oradata\/mynewdb\/tbs_1_01.dbf’ SIZE 325M REUSE<\/p>\n\n\n\n

DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE ‘\/u01\/oracle\/oradata\/mynewdb\/temp01.dbf’ SIZE 20M REUSE<\/p>\n\n\n\n

UNDO TABLESPACE undotbs DATAFILE ‘\/u01\/oracle\/oradata\/mynewdb\/undotbs01.dbf’SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;<\/p>\n\n\n\n

@?\/rdbms\/admin\/catalog.sql<\/p>\n\n\n\n

@?\/rdbms\/admin\/catproc.sql<\/p>\n\n\n\n

— then create the required tablespaces<\/p>\n\n\n\n

— then create users and assign quotas on the tablespaces to all those users.<\/p>\n","protected":false},"excerpt":{"rendered":"

CREATE DATA BASE (1) you must be logged in as SYS with SYSDBA privilege invoked. (2) you must have edited initmynewdb.ora file to spawn an oracle instance (3) and you started the oracle instance in nomount mode. (4) after the database is created you are also to create the medata and plsql packages Example connect …<\/p>\n

CREATE DATA BASE<\/span> Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":567,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-581","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle"],"yoast_head":"\nCREATE DATA BASE - Ordba<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CREATE DATA BASE - Ordba\" \/>\n<meta property=\"og:description\" content=\"CREATE DATA BASE (1) you must be logged in as SYS with SYSDBA privilege invoked. (2) you must have edited initmynewdb.ora file to spawn an oracle instance (3) and you started the oracle instance in nomount mode. (4) after the database is created you are also to create the medata and plsql packages Example connect … CREATE DATA BASE Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/\" \/>\n<meta property=\"og:site_name\" content=\"Ordba\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-21T22:03:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-21T22:03:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/oracle-img2-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"499\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"ordba\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ordba\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/\",\"name\":\"CREATE DATA BASE - Ordba\",\"isPartOf\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\"},\"datePublished\":\"2023-11-21T22:03:35+00:00\",\"dateModified\":\"2023-11-21T22:03:37+00:00\",\"author\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\"},\"breadcrumb\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CREATE DATA BASE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\",\"name\":\"Ordba\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\",\"name\":\"ordba\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"caption\":\"ordba\"},\"sameAs\":[\"https:\/\/test.samplewebsitelink.com\/ordba\"],\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CREATE DATA BASE - Ordba","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/","og_locale":"en_US","og_type":"article","og_title":"CREATE DATA BASE - Ordba","og_description":"CREATE DATA BASE (1) you must be logged in as SYS with SYSDBA privilege invoked. (2) you must have edited initmynewdb.ora file to spawn an oracle instance (3) and you started the oracle instance in nomount mode. (4) after the database is created you are also to create the medata and plsql packages Example connect … CREATE DATA BASE Read More »","og_url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/","og_site_name":"Ordba","article_published_time":"2023-11-21T22:03:35+00:00","article_modified_time":"2023-11-21T22:03:37+00:00","og_image":[{"width":499,"height":400,"url":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/oracle-img2-1.jpg","type":"image\/jpeg"}],"author":"ordba","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ordba","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/","url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/","name":"CREATE DATA BASE - Ordba","isPartOf":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website"},"datePublished":"2023-11-21T22:03:35+00:00","dateModified":"2023-11-21T22:03:37+00:00","author":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f"},"breadcrumb":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/21\/create-data-base\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.samplewebsitelink.com\/ordba\/"},{"@type":"ListItem","position":2,"name":"CREATE DATA BASE"}]},{"@type":"WebSite","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website","url":"https:\/\/test.samplewebsitelink.com\/ordba\/","name":"Ordba","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f","name":"ordba","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","caption":"ordba"},"sameAs":["https:\/\/test.samplewebsitelink.com\/ordba"],"url":"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/"}]}},"_links":{"self":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/581","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/comments?post=581"}],"version-history":[{"count":1,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/581\/revisions"}],"predecessor-version":[{"id":582,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/581\/revisions\/582"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media\/567"}],"wp:attachment":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media?parent=581"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/categories?post=581"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/tags?post=581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}