[Oracle Cloud] - Creating Sampleschema in Oracle Cloud

Creating Sample schemas in Oracle Cloud

Login to the compute node of the DBAAS instance and follow below command to create the sample schema in Oracle Cloud using dbaascli command line utility. You would need to provide password for each sample schemas, default permanent tablespace and default temporary tablespace names.

How to login to compute node using putty? - click here

 DBAAS>sampleschema create  
 Executing command sampleschema create  
 Enter SYSTEM password  
 Enter SYS password  
 Enter HR password  
 Enter OE password  
 Enter PM password  
 Enter IX password  
 Enter SH password  
 Enter BI password  
 Enter default tablespace users  
 Enter temporary tablespace temp  
 Log location /var/opt/oracle/log/sampleschema/ 

You can validate and review the logs for each sample schema/objects created.

 [root@RAJDB121 sampleschema]# pwd  
 /var/opt/oracle/log/sampleschema  

 [root@RAJDB121 sampleschema]# ls -ltr  
 total 1516  
 -rw-rw---- 1 oracle oinstall 358998 Feb 5 18:31 sampleschema_2018-02-05_18:28:26.log  
 -rw-rw---- 1 oracle oinstall 359035 Feb 5 18:34 sampleschema-cmd_2018-02-05_18:28:26.log  
 lrwxrwxrwx 1 oracle oinstall   73 Feb 5 18:42 sampleschema-cmd.log -> /var/opt/oracle/log/sampleschema/sampleschema-cmd_2018-02-05_18:42:36.log  
 lrwxrwxrwx 1 oracle oinstall   69 Feb 5 18:42 sampleschema.log -> /var/opt/oracle/log/sampleschema/sampleschema_2018-02-05_18:42:36.log  
 -rw-rw---- 1 oracle oinstall 360033 Feb 5 18:45 sampleschema_2018-02-05_18:42:36.log  
 -rw-r--r-- 1 oracle oinstall  6075 Feb 5 18:45 hr_main.log  
 -rw-r--r-- 1 oracle oinstall  8062 Feb 5 18:46 oe_oc_v3.log  
 -rw-r--r-- 1 oracle oinstall  5136 Feb 5 18:46 pm_p_lob.log  
 -rw-r--r-- 1 oracle oinstall  1305 Feb 5 18:46 pm_main.log  
 -rw-r--r-- 1 oracle oinstall 14904 Feb 5 18:46 ix_v3.log  
 -rw-r--r-- 1 oracle oinstall  4765 Feb 5 18:46 time_v3.log  
 -rw-r--r-- 1 oracle oinstall  2340 Feb 5 18:46 coun_v3.log  
 -rw-r--r-- 1 oracle oinstall  3580 Feb 5 18:46 cust1v3.log  
 -rw-r--r-- 1 oracle oinstall  3638 Feb 5 18:46 prod1v3.log  
 -rw-r--r-- 1 oracle oinstall  2689 Feb 5 18:46 prom1v3.log  
 -rw-r--r-- 1 oracle oinstall  2097 Feb 5 18:46 chan_v3.log  
 -rw-r--r-- 1 oracle oinstall  3126 Feb 5 18:47 sale1v3.log  
 -rw-r--r-- 1 oracle oinstall  2644 Feb 5 18:47 dmsal_v3.log  
 -rw-r--r-- 1 oracle oinstall  2773 Feb 5 18:47 dem1v3.log  
 -rw-r--r-- 1 oracle oinstall  7993 Feb 5 18:47 sh_v3.log  
 -rw-r--r-- 1 oracle oinstall  4927 Feb 5 18:48 bi_v3.log  
 -rw-rw---- 1 oracle oinstall 360070 Feb 5 18:48 sampleschema-cmd_2018-02-05_18:42:36.log  
 [root@RAJDB121 sampleschema]#  

Subscribe to this blog to stay updated on latest Oracle Cloud articles and announcements.

Twitter : @rajsoft8899
Linkedin : https://www.linkedin.com/in/raj-kumar-kushwaha-5a289219/