Sunday, January 26, 2014

IOUG’s 2014 Exadata Virtual Conference

IOUG is organizing a two-day virtual Exadata Conference on 29-30 Jan, 2014. More importantly the virtual conference is FREE. Following is the agenda as per the IOUG's website:

29-Jan-2014 (Wednesday)

10-11am CST
Minimizing Risks with Database Consolidation on Exadata using I/O Resource Manager (IORM)
Speaker: Sameer Malik, Exadata Technical Architect, Accenture
11am-12pm CST           
Introduction to the New Oracle Database In-Memory Option
Speaker: Kevin Jernigan, Senior Director, Oracle
12-1pm CST
Understand the Flash storage and Dynamic Tiering Solution for Traditional Database in Comparison of Exadata Flash Solution.
Speaker: Amit Das, Database Engineering Architect, Paypal

30-Jan-2014 (Thursday)

10-11am CST
Oracle Exadata Technical Deep Dive Session
Speaker: Yenugula Venkata RaviKumar, Senior Sales Consultant, Oracle India Pvt. Limited
11am-12pm CST        
Exadata X4: What’s New
Speaker: Mahesh Subramaniam, Director of Product Management, Oracle
12-1pm CST
Exadata for Oracle DBAs
Speaker: Arup Nanda, Director, Starwood Hotels & Resorts

For more information and registration click on the below link:

http://www.ioug.org/exavirtual2014


I have registered myself for the two-day conference and hope to see you all there !!!


Tuesday, January 14, 2014

Oracle Database Security Assessment

Data Security has taken a front seat in terms of IT Security lately. Database security is an area of information security that is concerned with the use of security controls to protect databases. Organizations are trying to protect their databases from both internal and external threats. 

In this regard, Oracle has put up an online Database Security Assessment on their website. You may now check how secure your database is by answering few simple questions. 

Below is the link for Oracle's Database Security Assessment:

http://www.oracle.com/us/media/survey/index-191234.html


I am also sharing top ten most common database security vulnerabilities by ZDNet. Below is the link for the same:


http://www.zdnet.com/the-top-ten-most-common-database-security-vulnerabilities-7000017320/


Wishing you a secure database !!!

Monday, September 23, 2013

Forgot SYSMAN Password? Here's How to Regain Access to EMCC-12c

I installed Oracle Enterprise Manager Cloud Control 12c soon after it's release in a virtual environment for the purpose of testing. I normally save passwords, ip-address, ports, and other details in a text file. But unfortunately, I was not able to locate the file for this particular VM.

However, it was easy to reset the password following these steps:

1) Stop OMS (leaving the Admin Server up)
2) Modify SYSMAN password
3) Stop all OMS components
4) Start OMS
5) Login to Oracle EMCC-12c with the new password



1) Stop OMS (leaving the Admin Server up)

Stop the OMS without "-all" as shown below:

[oracle@emcc bin]$ ./emctl stop oms
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
[oracle@emcc bin]$


2) Modify SYSMAN password

[oracle@emcc bin]$
[oracle@emcc bin]$ ./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd XXXXX -new_pwd mynewpassword
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.

Changing passwords in backend ...
Passwords changed in backend successfully.
Updating repository password in Credential Store...
Successfully updated Repository password in Credential Store.
Restart all the OMSs using 'emctl stop oms -all' and 'emctl start oms'.
Successfully changed repository password.
[oracle@emcc bin]$

3) Stop all OMS components

[oracle@emcc bin]$ ./emctl stop oms -all
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Already Stopped
AdminServer Successfully Stopped
Oracle Management Server is Down
[oracle@emcc bin]$
[oracle@emcc bin]$

4) Start OMS

[oracle@emcc bin]$ ./emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...
Starting WebTier...
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
[oracle@emcc bin]$


5) Login to EMCC-12c

I was able to login to the EMCC-12c console with the new password without any issues.

For more information refer to MOS - 1365930.1