Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************Got the opportunity to pen a Book on Database Cloud Services.......More details to follow.***************

Title : Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2021

**********************************************************************************


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Azure Certified Architect Expert

Azure Certified Architect

Azure Certified Administrator

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Friday, November 3, 2017

Using dbaascli in - Oracle Cloud



[root@ERPDEV dbaascli]# ./dbaascli list
DBAAS CLI version 1.0.0


DBAAS>


Very Long Text, press q to quit
Available commands:
 cloud sync
 database bounce
 database changepassword
 database start
 database status
 database stop
 dataguard failover
 dataguard reinstate
 dataguard status
 dataguard switchover
 dbpatchm
 dv off
 dv off cdb
 dv off pdb
 dv on
 dv on cdb
 dv on pdb
 elogger list
 gg setup
 gg status
 glassfish start
 glassfish status
 glassfish stop
 listener bounce
 listener start
 listener status
 listener stop
 mrec
 netsec config
 netsec config encryption
 netsec config integrity
 netsec deconfig
 netsec deconfig encryption
 netsec deconfig integrity
 netsec status
 netsec status encryption
 netsec status integrity
 ore setup
 ore status
 orec
 sampleschema create
 sampleschema drop
 tde config
 tde deconfig
 tde rotate
 tde rotate masterkey
 tde status
 tfa install
 tfa uninstall





[root@ERPDEV dbaascli]# ./dbaascli list
DBAAS CLI version 1.0.0


DBAAS>
[root@ERPDEV dbaascli]# ./dbaascli database status
DBAAS CLI version 1.0.0
Executing command database status
Database Status:
Database is open
Database name: ERPDEV

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE    12.1.0.2.0      Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production


[root@ERPDEV dbaascli]# ./dbaascli database stop
DBAAS CLI version 1.0.0
Executing command database stop
Database stopped in immediate


[root@ERPDEV dbaascli]# ps -ef| grep smon
root     21779 19335  0 09:47 pts/0    00:00:00 grep smon



[root@ERPDEV dbaascli]# ./dbaascli database start
DBAAS CLI version 1.0.0
Executing command database start
Database started


[root@ERPDEV dbaascli]# ps -ef| grep smon
oracle   22231     1  0 09:48 ?        00:00:00 ora_smon_ERPDEV
oracle   22346     1  0 09:48 ?        00:00:00 /usr/bin/perl /var/opt/oracle/misc/dbcsmonitor.pl /var/opt/oracle/tfa/erpdev/tfa_home /var/opt/oracle/tfa/repository/suptools/erpdev/dbcsmon /var/opt/oracle/tfa/repository/suptools/erpdev/dbcsmon/oracle
root     22948 19335  0 09:49 pts/0    00:00:00 grep smon


[root@ERPDEV dbaascli]# ./dbaascli database status
DBAAS CLI version 1.0.0
Executing command database status
Database Status:
Database is open
Database name: ERPDEV

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE    12.1.0.2.0      Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production



[root@ERPDEV dbaascli]# ./dbaascli database bounce
DBAAS CLI version 1.0.0
Executing command database bounce
Database stopped in immediate
Database started


[root@ERPDEV dbaascli]# ./dbaascli database status
DBAAS CLI version 1.0.0
Executing command database status
Database Status:
Database is open
Database name: ERPDEV

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE    12.1.0.2.0      Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production



[root@ERPDEV dbaascli]# ./dbaascli listener status
DBAAS CLI version 1.0.0
Executing command listener status
Starting listener

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 02-NOV-2017 09:55:26

Copyright (c) 1991, 2017, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ERPDEV.compute-586447955.oraclecloud.internal)(PORT=1623)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                01-NOV-2017 11:26:55
Uptime                    0 days 22 hr. 28 min. 30 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ERPDEV/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ERPDEV.compute-586447955.oraclecloud.internal)(PORT=1623)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1623)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ERPDEV.compute-586447955.oraclecloud.internal)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/ERPDEV/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "ERPDEV.586447955.oraclecloud.internal" has 1 instance(s).
  Instance "ERPDEV", status READY, has 1 handler(s) for this service...
Service "ERPDEV.586447955.oraclecloud.internalXDB" has 1 instance(s).
  Instance "ERPDEV", status READY, has 1 handler(s) for this service...
Service "demos.586447955.oraclecloud.internal" has 1 instance(s).
  Instance "ERPDEV", status READY, has 1 handler(s) for this service...
Service "erpdevpdb1.586447955.oraclecloud.internal" has 1 instance(s).
  Instance "ERPDEV", status READY, has 1 handler(s) for this service...
The command completed successfully

[root@ERPDEV dbaascli]#


[root@ERPDEV dbaascli]# ./dbaascli netsec status
DBAAS CLI version 1.0.0
Executing command netsec status

Displaying configuration for network encryption:

server encryption status: [enabled]
type    = required
methods = AES256,AES192,AES128

client encryption status: [disabled]

Displaying configuration for network integrity:

server integrity status: [enabled]
checksum_level = required
methods        = SHA1

client integrity status: [disabled]





[root@ERPDEV dbaascli]# ./dbaascli  sampleschema create
DBAAS CLI version 1.0.0
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/



30 comments:

Unknown said...

I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
dot-net training in chennai

Unknown said...

Existing without the answers to the difficulties you’ve sorted out through this guide is a critical case, as well as the kind which could have badly affected my entire career if I had not discovered your website."Oracle Training in Chennai"

online training said...

Good Post.Thank you so much for sharing this worth able content with us. The concept taken here will be useful.
Oracle Training
Oracle Online Training

Unknown said...

Marvelous information Regarding Oracle. Thanks for sharing .
UI Technologies Training
UI Technologies Online Training

Unknown said...

Great blog.you put Good stuff.All the topics were explained briefly.so quickly understand for me.I am waiting for your next fantastic blog.Thanks for sharing. Full Stack Training in Hyderabad

Rohil said...

I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site Anexas

nancy said...

nice blog.
http://www.sunilgulabani.com/2014/02/nosql-and-apache-solr-cloud-presentation.html?showComment=1536732444188#c3385426080493312265

nancy said...

GOOD BLOG


RPA Training in Hyderabad

rohil said...

Very interesting blog which helps me to get the in depth knowledge about the technology, Thanks for sharing such a nice blog..
Good discussion.
Six Sigma Training in Abu Dhabi
Six Sigma Training in Dammam
Six Sigma Training in Riyadh

alex said...

Want to have fun and get paid for it? we have bonus slot machines .Come to us and have fun getting money for it.

Sanvi said...

It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time.

CEH Training In Hyderbad

Belago said...

Качественная светодиодная лента купить которую вы можете только на сайте Ekodio

Muralidhara Raju Indukuri said...

Nice.
aws training in hyderabad

nash b said...

Nice..
bitwise aptitude questions

how to hack flipkart legally

zenq interview questions

count ways to n'th stair(order does not matter)

zeus learning subjective test

ajax success redirect to another page with data

l&t type 2 coordination chart

html rollover image

hack android phone using cmd

how to hack internet speed upto 100mbps

nash b said...

Good..
internships in chennai

winter internship mechanical engineering

internship for aeronautical engineering students in india 2019

kaashiv

list of architectural firms in chennai for internship

paid internships in pune for computer science students

diploma final year project topics for information technology

internship

data science internship report

inplant training

shri said...

Awesome nice post...
internship report on python
free internship in chennai for ece students
free internship for bca
internship for computer science engineering students in india
internships in hyderabad for cse students 2018
electrical companies in hyderabad for internship
internships in chennai for cse students 2019
internships for ece students
inplant training in tcs chennai
internship at chennai

Muthu said...

Nice Infromation....
internship in chennai for ece students with stipend
internship for mechanical engineering students in chennai
inplant training in chennai
free internship in pune for computer engineering students
internship in chennai for mca
iot internships
internships for cse students in hyderabad
implant training in chennai
internship for aeronautical engineering students in bangalore
inplant training certificate

sugan said...

very nice post.........
r programming training in chennai
internship in bangalore for ece students
inplant training for mechanical engineering students
summer internships in hyderabad for cse students 2019
final year project ideas for information technology
bba internship certificate
internship in bangalore for ece
internship for cse students in hyderabad
summer training for ece students after second year
robotics courses in chennai

Muthu said...

Nice post...
3d-modeler-resume-samples
3d modeler resume samples
accounting-assistant-resume-sample
accounting-clerk-resume-sample
accounting-manager-resume-samples
account-manager-resume-examples
accounts-payable-resume-sample
admin-manager-resume-samples
advocate-resume-sample
advocate-resume-sample

sibiselvan said...

it is good blogs!!!

paid internships in pune for computer science students
machine learning training in chennai
data science internship in chennai
dot net training in chennai
kaashiv infotech chennai
internship for aeronautical engineering students in india
internship in automobile industry
big data internship in chennai
machine learning internship in chennai
internship in chennai for it students

reena said...

branch-operations-manager-resume-samples
business-executive-resume-samples
business-owner-resume-samples
business-to-business-sales-resume-sample-sales-resumes
cad-design-engineer-resume-samples
call-centre-jobs-resume-sample
ca-resume-samples-chartered-accountant-resume-format
cassandra-database-administrator-resume
category/accountant-resume
category/admin-resume

shalini said...

good....nice
category/advocate-resume
category/agriculture-forestry-fishing
category/android-developer-resume
category/assistant-professor-resume
category/chartered-accountant-resume
category/database-resume
category/design-engineer-resume
category/developer-resume
category/engineer-resume
category/entrepreneur-and-financial-services-resume

Praisy Margret said...

good..nice..
assistant-director-resume-format
assistant-director-resume-sample
assistant-professor-resume-sample
back-office-executive-resume-samples
bank-branch-manager-resume-samples
basketball-coach-resume-sample-coach-resumes
bca-fresher-resume-sample
best-general-manager-resume-example
bpo-resume-freshers-sample
bpo-resume-samples-for-freshers

reena said...

good ....nice...
resume/category/software-testing-resume
resume/category/sslc-resume
resume/category/storekeeper-resume
resume/category/stylist-resume
resume/category/teachers-resume
resume/category/technical-architect-resume
resume/category/web-developer-resume
cics-system-programmer-resume-example
resume/cisco-network-engineer-resume
resume/cisco-network-engineer-resume-sample

Praisy Margret said...

good... nice... very useful..
assistant-director-resume-format
director-resume-sample
assistant-professor-resume-sample
back-office-executive-resume-samples
bank-branch-manager-resume-samples
basketball-coach-resume-sample-coach-resumes
bca-fresher-resume-sample
best-general-manager-resume-example
bpo-resume-freshers-sample
bpo-resume-samples-for-freshers

shalini said...

good.....nice..
category/maintenance-resume
category/manager-resume
category/mechanical-engineering-resume
category/network-engineer-resume
category/officer-resume
category/operations-resume
category/process-associate-resume
category/quality-control-resumes
category/software-engineer-resume

reena said...



film-director-resume
finance-and-accounting-manager-resume-samples
finance-director-resume-examples
fire-safety-officer-resume-sample
fleet-maintenance-manager-resume-samples
format-for-resume-writing
fresher-computer-engineers-resume-sample
fresher-hr-resume-sample
fresher-hr-resume-sample-2
fresher-lecturer-resume


Janu said...

Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post.


Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery


anish said...

Really nice way to present your blog and information is also too good. Thanks for sharing it. If you are searching for more courses than visit here:-
Oracle 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

vijay said...

After reading this web site I am very satisfied simply because this site is providing comprehensive knowledge for you to audience.
Salesforce Training in Chennai

Salesforce Online Training in Chennai

Salesforce Training in Bangalore

Salesforce Training in Hyderabad

Salesforce training in ameerpet

Salesforce Training in Pune

Salesforce Online Training

Salesforce Training