Steps To Create Oracle 12c Database For New Projects

[Elmothana]

السلام عليكم

الملف المرفق يحتوي على خطوات انشاء قاعدة بيانات جديدة من البداية الى النهاية في 13 خطوة

خطوة خطوة

مع توضيح المتغيرات الرئيسية  (كإسم قاعدة البيانات ومسارها ...) في الكود في بداية الكود

هذه الاكواد لــ (12c) (Multitanent)

استخدمها عادة عند البادية في مشروع جديد

وهي هنا لتقديم المساعدة لمن يحتاجها ولتبادل الخبرات فأرجوا من اصحاب الخبرة ابداء اضافتهم عليها 

وللجميع التحية 

 

 

Steps To Create Oracle Database For New Project.rar

/*
- DB NAME                    : PDB20180102
- DB Path                    : D:\Smart Solutions\tmp pro\2018-01-02 Test\DB
- DB ADMIN USER              : admin 
- DB ADMIN USER Password     : admin 
- DB TABLESPACE Name         : PDB20180102_TblSpc
- DB Data File               : DBFile_perm_01.dat
- DB Test Table Name         : TestTbl
*/




-- Step >>> (( 1 ))
--  Dropping DB IF Exist
ALTER SESSION SET CONTAINER=cdb$root;
drop pluggable database PDB20180102 including datafiles;


-- Step >>> (( 2 ))
-- alter session and Create the database with the admin user
ALTER SESSION SET CONTAINER=cdb$root;


CREATE pluggable DATABASE PDB20180102 ADMIN USER Sys_admin IDENTIFIED BY admin
file_name_convert = ('pdbseed', 'PDB20180102');
--------------------------------------------------------------------------------
-- Step >>> (( 3 ))
-- insure db created
select pdb_name from cdb_pdbs;
--------------------------------------------------------------------------------
-- Step >>> (( 4 ))  
-- Open database
 ALTER pluggable DATABASE PDB20180102 OPEN;
-------------------------------------------------------------------------------- 
-- Step >>> (( 5 ))
-- insure db open
 SELECT NAME, Open_Mode, Inst_ID FROM gv$PDBs;
-------------------------------------------------------------------------------- 
-- Step >>> (( 6 ))
-- Save database state
 ALTER SESSION SET CONTAINER=cdb$root; 
 ALTER pluggable DATABASE PDB20180102 save state;
--------------------------------------------------------------------------------
-- Step >>> (( 7 ))
-- Creating TABLESPACE for db
ALTER SESSION SET CONTAINER = PDB20180102;
/*
 DROP TABLESPACE PDB20180102_TblSpc INCLUDING CONTENTS AND DATAFILES;  
*/ 
ALTER SESSION SET CONTAINER = PDB20180102;
CREATE BIGFILE TABLESPACE PDB20180102_TblSpc
  DATAFILE 'D:\Smart Solutions\tmp pro\2018-01-02 Test\DB\DBFile_perm_01.dat'
    SIZE 10M
    AUTOEXTEND ON;
--------------------------------------------------------------------------------
-- Step >>> (( 8 ))
-- insure table space created
SELECT tablespace_name, con_id FROM cdb_tablespaces;
SELECT TABLESPACE_NAME, STATUS, CONTENTS
FROM USER_TABLESPACES;
--------------------------------------------------------------------------------
-- Step >>> (( 9 ))
-- insure user exist
-- admin user that was created in step (1-2)
SELECT * FROM ALL_USERS;
--------------------------------------------------------------------------------
-- Step >>> (( 10 ))
-- grant user DBA permissions
ALTER SESSION SET CONTAINER = PDB20180102;
GRANT "CDB_DBA" TO Sys_Admin ;
GRANT "RESOURCE" TO Sys_Admin ;
GRANT "CONNECT" TO Sys_Admin ;
GRANT "DBA" TO Sys_Admin ;
GRANT CREATE SESSION TO Sys_Admin ;
--------------------------------------------------------------------------------
-- Step >>> (( 11 ))
-- Assign the table space to the admin user
-- tablespace was created in Step (7)
ALTER SESSION SET CONTAINER = PDB20180102;


ALTER USER Sys_Admin
DEFAULT TABLESPACE PDB20180102_TblSpc  ---- ********
TEMPORARY TABLESPACE "TEMP";
--------------------------------------------------------------------------------
-- Step >>> (( 12 ))
-- check DB Connection
conn Sys_Admin/ADMIN@PDB20180102;
--------------------------------------------------------------------------------


-- Step >>> (( 13 ))
-- Add To TNS Names
-- TNS NAME doc Path: C:\app\kgl\product\12.1.0\dbhome_1\NETWORK\ADMIN
-- Add the following entry to tnsnames.txt
/*
PDB20180102 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PDB20180102)
    )
  )
*/
--------------------------------------------------------------------------------


-- Step >>> (( 14 ))
-- Create Sql Developer New Connection For the New DB
--------------------------------------------------------------------------------






--*****************************************************************************
-- >>> Creating Test table
ALTER SESSION SET CONTAINER = PDB20180102;
CREATE TABLE TestTbl 
(
  NOA NUMBER NOT NULL 
, DSCRPT NVARCHAR2(100) NOT NULL 
) 
-- >>> Inserting Into Test table
INSERT INTO TESTTBL(NOA, DSCRPT) VALUES(100,'Hellow All');


-- >>> Select Data From Test table
Select * From TESTTBL;


-- >>> Dropping Test table
Drop Table TestTbl;