Tag: Become Oracle DBA

failed to associate the token : AWS

Posted on by Osama Mustafa in Cloud
Once you create AWS you should activate “Activate MFA on your root account” 

and do that you should use your phone (Iphone, Android) download google authenticator app from the app store/Google Play once the installation is done Scan the QR and Enter the code, the code will be change automatically, if the first try not working and you receive this error ” failed to associate the token” uninstall the app and try again.

Thank you
Osama

ODI-1545: Missing odi supervisor credentials in credential store map

Posted on by Osama Mustafa in Fusion Middleware
This Error appear because missing SuperVisor User Credentials, and you need to create it using wls.sh command, And Since we are working On Oracle_ODI So you have to use WLST.sh from there.

cd /u01/app/fmw/Oracle_ODI1/common/bin
./wlst.sh

and do the below

Jython scans all the jar files it can find at first startup. Depending on the system, this process may take a few minutes to complete, and WLST may not return a prompt right away.

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

wls:/offline> connect (‘weblogic’,’welcome1′,’t3://localhost:7001′)

 Connecting to t3://10.40.74.210:7001 with userid weblogic …
Successfully connected to Admin Server ‘AdminServer’ that belongs to domain ‘IDDomains’.

Warning: An insecure protocol was used to connect to the
server. To ensure on-the-wire security, the SSL port or
Admin port should be used instead.

wls:/IDDomains/serverConfig> createCred(map=”oracle.odi.credmap”, key=”SUPERVISOR”, user=”SUPERVISOR”, password=”sysadmin1″, desc=”Key for Supervisor”)
Location changed to domainRuntime tree. This is a read-only tree with DomainMBean as the root.
For more help, use help(domainRuntime)

wls:/IDDomains/serverConfig> createCred(map=”oracle.odi.credmap”, key=”odi11g”, user=”weblogic”, password=”welcome1″, desc=”WLS SUPERVISOR Credential”)

wls:/IDDomains/serverConfig> disconnect()
Disconnected from weblogic server: AdminServer
wls:/offline>
wls:/offline>
wls:/offline>
wls:/offline> exit()

The Red Line for to define 3 command you will use.

Some Link :
1- How To Configure The ODI JavaEE Agent and ODI Console On WebLogic Server (Doc ID 1300550.1)
2- Working with ODI Here

Thank you
Osama Mustafa

Failed to create secure socket for OPMN at LocalHost:9501

Posted on by Osama Mustafa in Fusion Middleware
The Below Error Appear when you enter to the following URL :  http://LocalHost:9704/analytics

oracle.as.management.opmn.optic.OpticBadConnectException: Failed to create secure socket for OPMN

Change Directory to the to BI instance/Bin Folder and :

[oracle@exalytic bin]$ ./opmnctl stopall
opmnctl stopall: opmn is not running.

[oracle@exalytic bin]$ ./opmnctl startall
opmnctl startall: starting opmn and all managed processes…

[oracle@exalytic bin]$ ./opmnctl status
Processes in Instance: obiee1
———————————+——————–+———+———
ias-component                    | process-type       |     pid | status
———————————+——————–+———+———
coreapplication_obiccs1          | OracleBIClusterCo~ |   19837 | Alive  
coreapplication_obisch1          | OracleBIScheduler~ |       0 | NONE  
coreapplication_obijh1           | OracleBIJavaHostC~ |   19836 | Alive  
coreapplication_obips1           | OracleBIPresentat~ |   19840 | Alive  
coreapplication_obis1            | OracleBIServerCom~ |   19838 | Alive  

Thank you
Osama Mustafa 

How to Become Oracle DBA

Posted on by Osama Mustafa in Others
How to become Oracle DBA ?

This question asked on lot of blogs for Guru People , Before start thinking about that question you need to ask yourself some question.

Do you love to work with pressure, Do you Love working for long hours ?  Do you use your free time to devour the latest in technology from internet and reports? Do you love to work during weekend ? Last question is Are you able to deal with Sensitive & critical data with no mistake ? If all you answer is Yes,then welcome to Oracle DBA World where the human becoming theory.

Oracle is not easy world and it’s not that hard but you need to know it’s Complex, Just as note Don’t expect to be rich also make your rule is “love what you do and do what you love”.

 Recently i saw Threads On OTN Forum where the poster was asking for information about starting his Career as Oracle DBA, I will advice about that and hope it will be useful, if you have any programming language skills it will make your job easier it’s very useful to understand what you see as DBA you work with Development team and negotiate them about performance and their requirement and understand them is the best, On the other hand if you don’t have any Experience you can’t stop here and saying to yourself i can’t become Oracle DBA Start learning and it’s not bad idea to take courses such as SQL-Fundemtals I & II.

Don’t forget another thing start working on your Oracle training and education Reading is not enough it’s only give you concept and the idea behind that thing, Learning operating system administration skills, and what i mean by Operating system not just windows you need to learn about Linux, Unix …. Etc and how to manage them and using command line, learn batch & Shell Scripting is very useful, Don’t forget to take look at Oracle Documentation everytime you can is the first and the best reference all the time, You need to learn about something read from the source don’t start with others articles, and don’t understand me wrong with that everyone has his point but stat with source and see other point to create yours.

There’s also oracle magazine latest technology and Some tips/trick to do something you can subscribe with it,Maybe you don’t understand something so you need someone to explain it to you Oracle OTN Forum is available to you for free, experts and guru will answer you, Books will increase your knowledge and proof your point.

Create your own Vmware and test don’t make something passed without testing, Practical way will proof and increase your knowledge, then let’s make all the above as point :

  • Attend training courses
  • Read Books
  • Read Magazine.
  • Visit Oracle Documentation site and blogs.
  • Check OTN Forum
  • Talk with DBA

Bookmark this website,
Very Useful & Good Starting Point to become Oracle DBA.

long topic to discuss and need of you lot of working, If you want to be a DBA, find one or two methods of acquiring knowledge that you are comfortable with. Take training courses, read books, whatever. and i will update this topic also to become Comprehensive.

Thank you
Osama Mustafa