Red Hat / Fedora :: Unable To Stop Oracle Database Services

May 23, 2009

Currently using oracle 9i with 3 database(maindb,arist,samp) in redhat 5.3 server .I want to stop 2 database "maindb" and "samp" manually ( in XP or Vista we can stop service oraclemaindb and oraclesamp ), but in redhat i dont know how to stop services and how to see currently running oracle services.

View 1 Replies


Red Hat / Fedora :: Unable To Start Oracle Database?

Sep 16, 2010

i am installing oracle database 10g2 in my fedora12 with the help of this link ORACLE-BASE - Oracle Database 10g Release 2 ( Installation On Fedora 7 (F7)Now i am start my Database using sqlplus:[oraclelocalhost ~]$ sqlplusSQL*Plus: Release - Production on Thu Sep 16 10:53:47 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.Enter user-name: /as sysdbaConnected to an idle instance.

SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes


View 4 Replies View Related

Red Hat / Fedora :: Starting Oracle Database Via Dbora Failing?

Jun 21, 2011

I have a dbora script that i've been having fits with. Running RH EL 5.

#!/bin/sh -x
# chkconfig: 345 95 10
# description: Oracle auto start-stop script.


View 1 Replies View Related

Fedora :: Automatic Start Stop Script For Oracle 11g?

Aug 28, 2010

i finished installing oracle 11g r2 with EM but i cant find any good script that will close the database completely before rebooting they all start it correctly but for the shutdown they don't wait and the database restart in recovery mode

View 3 Replies View Related

Red Hat / Fedora :: Services Start Then Stop After Few Minutes

May 7, 2009

I have several services set to start in init 3 on a cloud provider. The init scripts appear to be in the correct folder but the services are never started after a reboot. I finally watched the console and all the services start correctly then shutdown after a few moments.

View 9 Replies View Related

Red Hat / Fedora :: Restart / Start / Stop All Services At The Same Time Without Rebooting?

Jan 7, 2010

is it possible to restart /start/stop all services at the same time without rebooting?

View 3 Replies View Related

General :: Copying Tables From One Database To Another In Oracle?

Apr 8, 2011

translationables,i.e,camp_generic_transcamp_generic_trans_defcamp_generic_trans_epcthese tables exist in cntr1/cntr1@camABC1I have to copy these tables from here to staging environment.I need to first check if any of the tables exist in staging.If yes,then delete and create new.There are 4 staging env from 5 to 8.I have to pass the staging environment as parameter to ask the user which environment does he want the tables to be copied

View 1 Replies View Related

Software :: How To Connect OpenOffice 3 To Oracle Database?

Mar 14, 2009

I'm using Kubuntu 8.04 and now I've installed OpenOffice 3, both in Spanish.I have oracle client installed and can connect to Oracle databases with clients like tora.What I try:

- Open Database and select connect to an existing database.
- Select Oracle JDBC.
- Next
- DatabaseName: I put the sid of the database of oracle. (orcl)
Server URL: The name of the server containing the database. It's resolved by a ping. (
Port: 1521
- Oracle JDBC Driver:
But I press the test button, I receive an error: JDBC Driver can't be loaded (really, the message is in spanish).

View 2 Replies View Related

Programming :: Error Connecting To Oracle Database From PHP

Oct 12, 2010

I've just installed the Oracle Instant client using this:

The phpinfo() show me that oci8 is enable, but when I try to query that database I've got the following message:

PHP Code:


How to troubleshoot.

View 2 Replies View Related

Programming :: Unix Script For Oracle Database?

Apr 7, 2011

creating the below unix script to run in oracle database .I need a script which should do the following things.

1. The script should insert row count of a table from one database(A) into table (AB) in another database(B).

2. The script should update tow count of the similar table and tablespace from database (B) in to a table AB.

3. The script should update the status column of the table AB as: 'Y' if the rowcount of the table@A and rowcount of the table@B matching. or else it should update 'N'

View 4 Replies View Related

Networking :: Iptables Or Reverse Proxy For Oracle Database?

Feb 15, 2010

I'm trying to access my oracle database (port 1521) from the outside.What I have:Outside -----> Proxy ----> DatabaseWhat I try is to configure a reverse proxy or iptables for accepting connections on port 1521 and transfer them to database. Only one computer of the outside will have access to the database.I suppose than this can be done with iptables or another way.In the real environment proxy will have two nicut for test purposes my computer will have only one (for test purposes, the tree computer will be in the same net)

View 11 Replies View Related

General :: Cannot Run Auto Shutdown Script For Oracle Database

Mar 18, 2010

in order to do full backup system, i have to shutdown the oracle database. My backup software can stop the services by running the shutdown script. But in order to shutdown the oracle database, the script must be run under oracle privilege. The conflict is our backup system which is reside under root privilege cannot run the oracle shutdown script which is needed to triggered by oracle privilege.

View 1 Replies View Related

General :: Compare Oracle Database Table Contains Using Scripts?

Dec 26, 2010

How to compare oracle database table contains using (Perl/Shell)scripts.

View 4 Replies View Related

Programming :: Connecting To Remote Oracle Database Using Perl?

Jan 27, 2010

How to connect to remote oracle database using perl?

This is what I tried.


But I am unable to connect.

View 4 Replies View Related

Ubuntu Installation :: Can SQL 2008 Open Database Made From Oracle

Feb 17, 2010

My DataBase Teacher wants us to install SQL 2008 cause on 3 days i gotta practice for the big test But the requirements are a ton "Visual Basic 2008 with service pack 1 & IIS" but thats just a tiny part of the problem.! My Windows 7 crashed.! So iam thinking can linux oracle be the answer of my ugly problems.?!Can SQL 2008 open database made from linux Oracle?

View 3 Replies View Related

Networking :: Configure A Reverse Proxy For Oracle Database Connections?

Mar 4, 2010

I'm trying to configure a reverse proxy for Oracle Database connections. What I have:

Host outside --> Reverse proxy --> Oracle Database

The "Revese proxy" has two IP, one for local and another for outside.I've tried with iptables, but unable.Now I'm trying with "redir".When I do a tnsping database, it works and says OK. But executing sqlplus user/pass@database, it tries to connect but time later I receive a timeout. What i do is a redir from port 1521 in "Reverse proxy" to 1521 in "Oracle database" why this doesn't work or any other way to do it?

View 1 Replies View Related

General :: Check With Nagios An Oracle Database That Is Located On A Server?

May 4, 2011

I need to check with nagios an oracle database that is located on a server. There are a lot of plugins that are provided, the problem is that the database is located on a remote server (i have an hostaddress) and then i need to log on the database (i have username and pass)So i only need to have a plugin that connects to that hostaddress and logs on, but i can't find any plugin which does that

View 14 Replies View Related

General :: Configure Autostart Of Oracle Database / Soa Suite On Bootup?

Jan 24, 2011

I need to configure autostart of oracle database 11g & oracle soa suite 11g after successful OS startup. Linux: Redhat version 5. I have commands needed for startup, but not sure on where to keep the file.

View 2 Replies View Related

Server :: Oracle Database - Mountpoint Read And Writable After Reboot

Jan 7, 2010

We have a Dell PE6600 with a QLA2460 FC HBA in it. Server is running RedHat AS 4.7 (kernel 2.6.9-78), FC driver used is the file qlafc-linux-8.02.23-3-install.tar downloaded from the QLogic website. On this server is an Oracle database running ( Files for the Oracle database are located in mountpoint /u02. The SAN is an iQStor 2880. Since several weeks we suddenly have problems with the Oracle database after a reboot of the server. After a reboot the mountpoint /u02 is readable and writable (tested by creating, opening and removing files).

However, when we try to start the database we get an error which give you the idea that the database is corrupt. The Oracle error is quite a general error. After doing a lot of testing we found out that if we unmount /u02 and mount it again (using mount -a so it reads the /etc/fstab), the database can be started after all. So the database is not corrupt but for some weird reason we have to remount /u02 first before the Oracle database can use it. We don't know if it's a linux issue, fibre issue, san issue or an oracle issue.

View 1 Replies View Related

Red Hat :: Oracle 10g Database Installation Procedures In Redhat Enterprise Server 5?

Jan 13, 2011

I have installed Redhat Enterprise Linux Server 5 on my laptop. I want to install Oracle 10g database on RHEL5 server. I want to know whether any additional rpm's need to install before installing the Oracle 10g.

View 1 Replies View Related

Fedora Security :: User Access To Start And Stop Tomcat But Also Gives User Access To Start And Stop Other Services "/etc/sudoers"

Mar 13, 2009

I am trying to give access to ONE single user to start and shutdown tomcat server. The problem being, when I enter syntax: username ALL= /etc/init.d/tomcat5, /usr/local/tomcat/webapps, PASSWD:ALL This gives the user access to start and stop tomcat but also gives user access to start and stop other services within /etc/init.d - such as httpd etc... What is the proper way to give user access to start and stop service, and limiting that power to only one service....

View 2 Replies View Related

General :: Configure UnixODBC On Rehat EL 5 32 Bit To Connect To An Oracle 10g Database Server?

Mar 28, 2010

I'm trying to configure unixODBC on Linux rehat EL 5 32 bit to connect to an Oracle 10g database server. But when I retest the connection after the configuration then The error occurs:

# isql -v oralab4_dns vonphot vonphoto
isql: symbol lookup error: /usr/lib/ undefined symbol: PC

I have searched on for 2 days but I can't resolve the problem.

View 3 Replies View Related

Ubuntu :: Stop Services Without Sudo?

Sep 12, 2010

I am working on a notebook which has both gnome and wmii. I am trying to find a way to script stopping various services when booting into wmii however the "service xxx stop" requires sudo..Is there a way to allow a user to manage services without the need for sudo (aside from password-less sudo)? I assume there are permissions complications with writing the PIDs, etc. Is there a 'simple' solution? Even possible passwordless sudo just for the 'service' command?

View 2 Replies View Related

Fedora Servers :: Unable To Reach Web Services Through Domain Name

Jan 29, 2011

i have installed apache and bind on my server and i've also registered a dynamic domain through dyndns as i am able to successfully host my own webpages using this method.

then i registered a domain name (lets call it "") through and have registered my nameserver to my ip address. after reconfiguring the my external zones in bind and restarted my services, i am unable to reach my webpages through the new domain name.. and would lead me to a page but interestingly loads my webpages successfully.

View 8 Replies View Related

Fedora :: Network Gone Down - Unable To Ping Nor Able To Restart The Services

Sep 20, 2010

I m not able to ping nor able to restart the services.....i dont know wht happened.its giving the error.........

Error,some other host already uses having 3 ethernet cards...this is my main server of company.

View 14 Replies View Related

Ubuntu :: Can't Find App To Stop And Start Services

Jun 27, 2010

I thought it was in the System>administration menu somewhere, but I just can't see it. What is it called, and where do I find it please?

View 9 Replies View Related

CentOS 5 :: PC / Desktop What Services To Stop And Uncheck?

Jul 29, 2009

Just installed 5.3/gnome.I am on pc/desktop with only wired internet connection via routerto dsl-modem. The OS sets-up the "eth0" automatically.For just this type of setup what services can I disable and uncheck ? In System>Admin.>Services I unchecked and disabled bluetooth,isdn,pcscd and sshd. Should I disable sendmail, avahi-daemon, portmap,rpcidmapd,rpcgssd and.apmd(no laptop)? Goal is to minimize unneeded services and improve security. The wiki article on securing CentOS did not cover this.Under System>Security Level Configuration I allow ftp,Mail(smtp), and WWW(HTTP). Is the ftp allowed ok for my pc/desktop?

View 3 Replies View Related

Ubuntu Networking :: Stop & Restart Wireless Services

Apr 1, 2010

Xubuntu 9.10 on a DELL Inspiron 1150.I have a problem with intermittent dropping of my wireless connection ( see Belkin 7010 thread).Once dropped, the wireless will NOT reconnect (It just sits there saying "connecting" but never does) Same happens if I manually disconnect - I can never re-connect. On rebooting it will reconnect fine & all is well for sometimes 4 hrs.How can I kill all wireless services & restart them without having to reboot the laptop?

View 3 Replies View Related

Ubuntu :: 10.04 Correct Way To Start Stop Disable Services?

Aug 25, 2010

With the advent of Ubuntu 10.04 Lucid Lynx LTS People are migrating servers to the latest LTS. One fundamental thing that has changed is the move to Upstart. In the old days to stop multidaemon service such as Samba, one would simply type /etc/init.d/samba stop and to disable it from starting on boot one would simply type update-rcd samba disable.

Now its the year 2010 and in 10.04 it seems on has to edit a bunch of files, etc. Is there not an easy tool to correctly and properly disable services on startup in 10.04 consistently? in Redhat/Mandrake 10 years ago it was simply

service smb off
In Ubuntu 10.04 its
1) edit /etc/init/smbd.conf and modify the line that says
stop on runlevel [!2345]
and change it to


And one has to remember all these changes when the get ready to enable the samba service in the future? This can't be right.I know I must be missing something here. or maybe overlooked something in the upstart documentation.Which seems quite sparse by the way. So the question remains. How does one simply disable a multidaemon service starting on boot such as samba. Any tool to do this ? Is the above the correct method recommended by Canonical to disable services? and enable them?

View 2 Replies View Related

Ubuntu :: Method To Start / Stop Services Under Upstart

Jan 22, 2011

I installed MySQL and Apache2 to develop & test out the site I'm writing. However since I'll be using them purely for internal use (not exposed to the Net), I don't want them to start with every boot-up, but would like to start them manually when I desire, and stop them after use.With previous Ubuntu (Jaunty) I'd used chkconfig to configure services, but since the current version (Maverick) uses Upstart, is chkconfig still applicable?

I also installed 'bum' (Boot-Up Manager), but strangely, it displays the MySQL server as "unchecked" even though it's running (and starts at boot-up), so I cant see how I can prevent it from starting at boot-up through bum. chkconfig also displays MySQL as not active at runlevel 5, when in fact, it is.

I'd like to know what's the recommended (official) way to configure boot-up services with the Upstart system? I don't suppose directly editing the *.conf files in /etc/init is the best (or even correct) way?

View 3 Replies View Related

Copyrights 2005-15, All rights reserved