Skip to main content

Starting up and stopping Oracle Listener and iSqlPlus

Starting up and stopping Oracle's Listner Service and httpd service for iSqlPlus.
I know it's a lame, but what the heck. Someone may be benefitted.
In the last post I installed Oracle 9i on RHEL5. But my Oracle agent dint startup. Which mean I have to startup and stop aforementioned services manually till I could configure the Agent. 
Well the commands are quite simple.

To startup Oracle's Listner Service -
$lsnrctl start
To Stop the listner-
$lsnrctl stop

To start the httpd server for iSqlPlus - 
$ORACLE_HOME/Apache/Apache/bin/apachectl start
To stop the httpd server for iSqlPlus - 
$ORACLE_HOME/Apache/Apache/bin/apachectl stop

I have made two shell-script for these operation, just to ease my finger from over-typing. These files and their contents are:
isqlplusstart.sh
#[Content]
lsnrctl start
ORACLE_HOME/Apache/Apache/bin/apachectl start
#[End Content]

and

isqlplusstop.sh
#[Content]
lsnrctl stop
ORACLE_HOME/Apache/Apache/bin/apachectl stop
#[End Content]

I made them executable by running the command chmod - 
$chmod +x isqlplusstart.sh
$chmod +x isqlplusstop.sh

Now I can run them anytime to start and stop my services.

3 comments

Popular posts from this blog

Datatables and Wordpress Integration problem solved.

Note: Download a working demo plugin from this project's github repository.

Like other wordpress developers, I had also faced the problem of integrating datatable(server side processing) with wordpress. I tried every tips, tricks and multiple ways to solve the problem, but couldn't do it. My ajaxified functions of the wordpress simple dint work. I din't have much time and had to finish a small project on time. So, I decided to skip it and go through the developer's way : the plugin developer had suggested and implemented.

I dropped the required php file with some related modifications and called the url of the php file in the datatable options in my project. It worked after few small hiccups. I wasn't satisfied though, as i wanted the wordpress centric solution, instead of using some drop-in file to complement the functionality. I had vowed to look after this problem whenever I could get some time.




(You may visit the url http://www.bearinghouse.net/order-now/ to …

Installing Oracle 9i on RHEL5. (x86)

I must warn you that this article is as it is. It worked when I was installing the combo - a long time ago. I am not sure about the links available in this article. I am not maintaining this article anymore, (other than sprucing it up a bit for better reading). I am completely out of touch with RHEL or Oracle for that matter. Still, dont lose your heart yet. I am sure, with proper searching using the big brother - Google, you will find lots of more information relating to your work to help you finish what you are doing.
Foreword
Recently I joined Sqlstar International for my Oracle DBA course. Everything was going smooth. I completed my SQL Fundamentals with Oracle installed on Windows in my pc. But when classes started for DBA Fundamentals 1 I was at loss, as in my institute oracle was installed on Redhat Linux platform. I could have done all the solution of the text on windows but I decided to configure my own Linux box and install oracle on it to simulate the class environment. So I…

Web Development Dilemma - Part 2

Recently, I got a Job to build an ERP Application (More like Accounting Package with CRM). I started planning for the Application. I had some experience with Tally.ERP 9 and knew a bit about Accounting too. Once again I chose Wordpress Platform for the application development, as I was more comfortable with it. Application was to have multiple advanced features along with some of smart automated data sensing and processing, and selective data push (Semi-Automated) to Tally for Accounting Purpose. The application was to run in a LAN Environment and was connected with the Customer's Website to retrieve Customer Order submitted on the website (Customized Shopping Cart) for further processing. 
I could develop fast in Wordpress, I was familiar with the system and environment. But due to multiple distractions, and tedious job (I hadn't anticipated lengthy coding and timing involved), the project had to be scrapped by the customer. The customer was gracious enough to forgive me, bu…