\nMy first trial<\/a> was not very good because I had access to Schema as a Service only. Which is not new.
\nBut Oracle Cloud Services is becoming now a reality, available for trial and available for general availability.
\nLet’s see now how to use Database as a Service.
\n<\/p>\n
Creation<\/h1>\n
My goal here is to see what is the default configuration, so I want a VM with storage and database already configured.<\/p>\n
12c of course.<\/p>\n I use minimum storage requirements (given that I’ve chose to install the demo pdb). Here is the summary<\/p>\n and my ‘dbi-cdb’ creation is in progress:<\/p>\n The following volumes have been created:<\/p>\n They use ext4 filesystem:<\/p>\n I’ve defined two OCPU in the configuration above. What is it? OCPU is defined as the CPU capacity equivalent of one physical core of an Intel Xeon processor with hyper threading enabled. Each OCPU corresponds to two hardware execution threads, known as vCPUs<\/p><\/blockquote>\n However, from the system it looks like one socket with one core and 4 threads:<\/p>\n Here is what it looks like from \/proc\/cpuinfo. There are 4 entries like that:<\/p>\n Good to see SSE4 features. They are used by In-Memory and are not always implemented by visualization.<\/p>\n The configuration is still in progress:<\/p>\n and I can see it with ‘top’:<\/p>\n This ‘dbda’ assistant is something interesting, very interesting, but that’s for another post.<\/p>\n The configuration is completed.<\/p>\n Let’s see the version:<\/p>\n It’s the PSA from april, and 4 interim paches.<\/p>\n Here are my services:<\/p>\n I can connect:<\/p>\n If I want to connect though internet, I have to tunnel the 1521 port because only ssh is open. But that, again, is for a future post.<\/p>\n Don’t hesitate to follow the dbi-services blog By Franck Pachot . My first trial was not very good because I had access to Schema as a Service only. Which is not new. But Oracle Cloud Services is becoming now a reality, available for trial and available for general availability. Let’s see now how to use Database as a Service.<\/p>\n","protected":false},"author":27,"featured_media":5271,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198,59],"tags":[135,612,613,96],"type_dbi":[],"class_list":["post-5262","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","category-oracle","tag-cloud","tag-dbaas","tag-ocpu","tag-oracle"],"acf":[],"yoast_head":"\n![\"fpadb0001\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fpadb0001.jpg\")
<\/a><\/p>\n![\"fpadb0003\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fpadb0003.jpg\")
<\/a><\/p>\n
\nI’ve allocated two ‘OCPU’, we’ll see what it means later.<\/p>\n![\"fpadb0004\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fpadb0004.jpg\")
<\/a><\/p>\n![\"fpadb0006\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fpadb0006.jpg\")
<\/a><\/p>\n![\"fpadb0007\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fpadb0007.jpg\")
<\/a><\/p>\nStorage<\/h1>\n
![\"fpadb0008\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fpadb0008.jpg\")
<\/a><\/p>\n\n[oracle@dbi-cdb ~]$ mount\n\/dev\/xvdb2 on \/ type ext4 (rw,barrier=0)\nproc on \/proc type proc (rw)\nsysfs on \/sys type sysfs (rw)\ndevpts on \/dev\/pts type devpts (rw,gid=5,mode=620)\ntmpfs on \/dev\/shm type tmpfs (rw)\n\/dev\/xvdb1 on \/boot type ext4 (rw)\n\/tmp on \/var\/tmp type none (rw,bind)\nnone on \/proc\/sys\/fs\/binfmt_misc type binfmt_misc (rw)\n\/dev\/xvdc1 on \/u01 type ext4 (rw)\n\/dev\/mapper\/dataVolGroup-lvol0 on \/u02 type ext4 (rw)\n\/dev\/mapper\/fraVolGroup-lvol0 on \/u03 type ext4 (rw)\n\/dev\/mapper\/redoVolGroup-lvol0 on \/u04 type ext4 (rw)\n<\/code><\/pre>\n\n[oracle@dbi-cdb ~]$ df -h\nFilesystem Size Used Avail Use% Mounted on\n\/dev\/xvdb2 16G 7.2G 7.6G 49% \/\ntmpfs 7.4G 3.6G 3.9G 49% \/dev\/shm\n\/dev\/xvdb1 194M 91M 94M 49% \/boot\n\/dev\/xvdc1 30G 8.5G 20G 31% \/u01\n\/dev\/mapper\/dataVolGroup-lvol0\n 25G 7.2G 17G 31% \/u02\n\/dev\/mapper\/fraVolGroup-lvol0\n 42G 2.2G 38G 6% \/u03\n\/dev\/mapper\/redoVolGroup-lvol0\n 9.9G 151M 9.2G 2% \/u04\n<\/code><\/pre>\nOCPU<\/h1>\n
\nDefinition from Oracle is:<\/p>\n\n[oracle@dbi-cdb ~]$ lscpu\nArchitecture: x86_64\nCPU op-mode(s): 32-bit, 64-bit\nByte Order: Little Endian\nCPU(s): 4\nOn-line CPU(s) list: 0-3\nThread(s) per core: 4\nCore(s) per socket: 1\nSocket(s): 1\nNUMA node(s): 1\nVendor ID: GenuineIntel\nCPU family: 6\nModel: 62\nStepping: 4\nCPU MHz: 2992.844\nBogoMIPS: 5985.68\nHypervisor vendor: Xen\nVirtualization type: full\nL1d cache: 32K\nL1i cache: 32K\nL2 cache: 256K\nL3 cache: 25600K\nNUMA node0 CPU(s): 0-3\n<\/code><\/pre>\n\nprocessor : 3\nvendor_id : GenuineIntel\ncpu family : 6\nmodel : 62\nmodel name : Intel(R) Xeon(R) CPU E5-2690 v2 @ 3.00GHz\nstepping : 4\ncpu MHz : 2992.844\ncache size : 25600 KB\nphysical id : 0\nsiblings : 4\ncore id : 1\ncpu cores : 1\napicid : 3\ninitial apicid : 3\nfpu : yes\nfpu_exception : yes\ncpuid level : 13\nwp : yes\nflags : fpu de tsc msr pae cx8 sep cmov pat clflush mmx fxsr sse sse2 ss ht syscall nx lm constant_tsc rep_good nopl pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 x2apic popcnt aes xsave avx f16c rdrand hypervisor lahf_lm ida arat epb xsaveopt pln pts dts fsgsbase erms\nbogomips : 5985.68\nclflush size : 64\ncache_alignment : 64\naddress sizes : 46 bits physical, 48 bits virtual\npower management:\n<\/code><\/pre>\nInstall<\/h1>\n
![\"fpadb0009\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fpadb0009.jpg\")
<\/a><\/p>\n\ntop - 20:37:09 up 31 min, 1 user, load average: 1.28, 1.27, 1.13\nTasks: 136 total, 4 running, 110 sleeping, 0 stopped, 22 zombie\nCpu(s): 4.3%us, 28.2%sy, 0.0%ni, 67.4%id, 0.1%wa, 0.0%hi, 0.0%si, 0.0%st\nMem: 15435892k total, 14293320k used, 1142572k free, 72448k buffers\nSwap: 4194300k total, 852k used, 4193448k free, 13577748k cached\n \n PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND\n13676 oracle 20 0 6379m 2.5g 2.5g R 99.4 16.9 0:03.10 ora_sa00_CDB\n13672 oracle 20 0 6379m 121m 119m R 14.6 0.8 0:00.45 ora_mman_CDB\n13662 oracle -2 0 6379m 18m 16m S 1.0 0.1 0:00.06 ora_vktm_CDB\n13696 oracle 20 0 6385m 25m 16m S 0.7 0.2 0:00.02 ora_dbw0_CDB\n13724 oracle 20 0 6382m 19m 17m S 0.7 0.1 0:00.02 ora_lreg_CDB\n13747 oracle 20 0 6383m 26m 23m S 0.7 0.2 0:00.02 oracleCDB (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))\n12499 oracle 20 0 140m 8680 1340 S 0.3 0.1 0:00.13 \/usr\/bin\/perl \/var\/opt\/oracle\/ocde\/assistants\/dbda\/dbda -out \/var\/opt\/o\n13654 oracle 20 0 6379m 21m 19m S 0.3 0.1 0:00.03 ora_pmon_CDB\n<\/code><\/pre>\nConnect<\/h1>\n
![\"fpadb0010\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fpadb0010.jpg\")
<\/a><\/p>\n\n[oracle@dbi-cdb ~]$ $ORACLE_HOME\/OPatch\/opatch lsinventory\n...\nOracle Database 12c 12.1.0.2.0\nThere are 1 products installed in this Oracle Home.\n\nInterim patches (4) :\n\nPatch 19665921 : applied on Wed Jun 17 04:19:25 UTC 2015\nUnique Patch ID: 18730325\n Created on 8 Apr 2015, 22:12:39 hrs PST8PDT\n Bugs fixed:\n 19665921\n This patch overlays patches:\n 20299023\n This patch needs patches:\n 20299023\n as prerequisites\n\nPatch 20415564 : applied on Wed Apr 22 18:40:56 UTC 2015\nUnique Patch ID: 18617752\nPatch description: \"Database PSU 12.1.0.2.3, Oracle JavaVM Component (Apr2015)\"\n Created on 31 Mar 2015, 05:37:43 hrs PST8PDT\n Bugs fixed:\n 19699946, 19909862, 19223010, 19877336, 19895326, 20408829, 19153980\n 20415564, 19855285, 19895362, 19231857, 19245191, 20408866\n\nPatch 20281121 : applied on Wed Apr 22 18:39:17 UTC 2015\nUnique Patch ID: 18730317\n Created on 25 Mar 2015, 17:19:22 hrs PST8PDT\n Bugs fixed:\n 20281121\n This patch overlays patches:\n 20299023\n This patch needs patches:\n 20299023\n as prerequisites\n\nPatch 20299023 : applied on Wed Apr 22 18:37:30 UTC 2015\nUnique Patch ID: 18703022\nPatch description: \"Database Patch Set Update : 12.1.0.2.3 (20299023)\"\n Created on 16 Mar 2015, 22:21:54 hrs PST8PDT\nSub-patch 19769480; \"Database Patch Set Update : 12.1.0.2.2 (19769480)\"\n<\/code><\/pre>\n\n[oracle@dbi-cdb ~]$ lsnrctl status\n\nLSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-AUG-2015 21:10:02\n\nCopyright (c) 1991, 2014, Oracle. All rights reserved.\n\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbi-cdb.compute-dbitrial1.oraclecloud.internal)(PORT=1521)))\nSTATUS of the LISTENER\n------------------------\nAlias LISTENER\nVersion TNSLSNR for Linux: Version 12.1.0.2.0 - Production\nStart Date 25-AUG-2015 20:13:38\nUptime 0 days 0 hr. 56 min. 23 sec\nTrace Level off\nSecurity ON: Local OS Authentication\nSNMP OFF\nListener Parameter File \/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\/network\/admin\/listener.ora\nListener Log File \/u01\/app\/oracle\/diag\/tnslsnr\/dbi-cdb\/listener\/alert\/log.xml\nListening Endpoints Summary...\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbi-cdb.compute-dbitrial1.oraclecloud.internal)(PORT=1521)))\n (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=dbi-cdb.compute-dbitrial1.oraclecloud.internal)(PORT=5500))(Security=(my_wallet_directory=\/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\/admin\/CDB\/xdb_wallet))(Presentation=HTTP)(Session=RAW))\nServices Summary...\nService \"CDB.dbitrial1.oraclecloud.internal\" has 1 instance(s).\n Instance \"CDB\", status READY, has 1 handler(s) for this service...\nService \"CDBXDB.dbitrial1.oraclecloud.internal\" has 1 instance(s).\n Instance \"CDB\", status READY, has 1 handler(s) for this service...\nService \"demos.dbitrial1.oraclecloud.internal\" has 1 instance(s).\n Instance \"CDB\", status READY, has 1 handler(s) for this service...\nService \"pdb1.dbitrial1.oraclecloud.internal\" has 1 instance(s).\n Instance \"CDB\", status READY, has 1 handler(s) for this service...\nThe command completed successfully\n<\/code><\/pre>\n\n[oracle@dbi-cdb ~]$ sqlplus sys\/Ach1z0#d@\/\/dbi-cdb\/PDB1.dbitrial1.oraclecloud.internal as sysdba\n\nSQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 25 21:13:05 2015\n\nCopyright (c) 1982, 2014, Oracle. All rights reserved.\n\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Oracle Label Security option\n\nSQL> show con_name\n\nCON_NAME\n------------------------------\nPDB1\n<\/code><\/pre>\n![\"RSS\"](\"http:\/\/dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2015\/08\/feed-icon.png\"){kind=icon}
<\/a> to be up-to-date on new technologies. Also on twitter: https:\/\/twitter.com\/dbiservices<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"