Restarting Oracle DB amd OEM

By -
Ever wanted to restart your oracle database instance?
Here are some basic steps that will help you restart your oracle db on linux.
Firstly, login to your database as oracle
You can keep a check on ora processes like this - >
ps - ef | grep ora
Check that ORACLE_HOME, ORACLE_SID is properly set.
Login as sysdba using sqlplus
sqlplus / as sysdba
>shutdown abort;
This will abort all the running processes and immediately shutdown your oracle db.
Once this is done,
>startup;
This will start and mount your db and your db is ready to use.
In case your listener is down, start it using the following commands:
Set the proper ORACLE_SID.
lsnrctl start
Db is ready to use.
Starting and stopping OEM
There is a very powerful oracle monitoring tool called the oracle enterprise manager.
I totally love using it. It gives entire performance matrix of your db and also make oracle administration easy. Use it to believe its power.
Start emctl.
Useful commands:
emctl start dbconsole
emctl stop dbconsole
To get the link of you oem dbconsole, and also the status just run the following command :
emctl status dbconsole

Comments

Post a Comment

Popular posts from this blog

Writing your own ejabberd Module

By -
Coming soon: What is ejabberd? What is erlang? Installation details. I will start with writing the ejabberd module first. Once you have done all the installations: sudo make sudo make install sudo ejabberdctl start sudo ejabberdctl stop You can check the status using: sudo ejabberdctl status You can locate logs at: (With default installation) /var/log/ejabberd All config related changes will be mainly done at: /etc/ejabberd/ejabberd.yml You will need a basic understanding of erlang. You can take a short crash course at: http://www.erlang.org/course/course.html This is a good reference. Go to your ejabberd-15.07/src directory. This is where you will write the hook for your ejabberd server. Create a file, say mod_changeBody.erl. Your module name and file name should be same. Add the following basic contents into your erl file: -module(mod_changeBody). -behavior(gen_mod). -include("ejabberd.hrl"). -include("logger.hrl"). -expo
Read more

npm ECONNREFUSED error

By -
If you face error which says ECONNREFUSED while doing npm install <<package name>>, you are probably behind a proxy which is not allowing you to connect to the server and download the packages required. Just follow the below steps: npm config set proxy  http://your_proxy_name:port npm config set https-proxy https://your_proxy_name:port And then try npm install How to get npm config? npm get proxy will do the work :)
Read more

Conditional Flow - Spring Batch Part 6

By -
Jump to Conditional Flow using Custom Status There can be muliple scenario where you want your jobs to proceed depending on the outcome of your steps. For example, in case of our Corporate gifts shop, in case the automatic packaging of the gifts fails, we want some manual intervention to be done i.e. somebody should manually package the item.  IF-ELSE IF loop for packaging:     if packageStep fails                              then manualPackageStep                         else if packageStep executes successfully                              then sendOutForDelivery Entire code available at git repo:   https://github.com/ricsr/spring-batch-demo/tree/exercise_06 Using SpringBatch you can achieve it as follows: Create you manualPackageStep, which is very similar to your packageStep, except that it does the packaging manually. @Bean public Step manualPackageStep () { return this . stepBuilderFactory .get( "manualPackageStep" ).tasklet( new Tasklet() { @Override pu
Read more