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


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

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

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

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

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

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

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 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

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

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

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

Programming :: START And STOP Oracle Automatically On System Startup And Shutdown?

Aug 17, 2009

I have installed Oracle 11g on 5.3. Now, I am trying to START and STOP oracle automatically on system startup and shutdown. I am following this link To have this effect, I have created /etc/init.d/dbora


# chkconfig: 345 99 10


View 4 Replies View Related

General :: User For Oracle,tried To Install Oracle 10g On Redhat 5 But Gettinh The Same Error Message?

Nov 27, 2010

I'm a new user for oracle,tried to install oracle 10g on redhat linux 5 but gettinh the same error message.response/ runInstaller[oracle2@localhost database_10201]$ sh runInstaller _runInstaller: line 54:/tmp/database_10201/install/.oui: Permission denied_Doany one plz help me how to give full set of permisions to an user in linux to access a folder??

View 2 Replies View Related

Ubuntu :: ORACLE - Nothing Happens When Clicking On "Start Database"

Jan 14, 2011

I've installed Oracle XE yesterday (forcing architecture, cause i am using amd64), it was working fine until i reboot my computer.

At the beginning i wasn't able to start because i was getting an error:

- "Operation failed. my_user is not a member of 'dba' group."

So, i went to System -> Administration -> Users and Groups -> Manage Groups -> (selected 'dba') -> Properties, and checked my user.

But now, when i click on "Start Database", the cursor stay 'waiting' and after some time it goes back to the pointer and nothing happens. On "Run SQL Command Line" i get "SP2-0640: Not connected" and in "Go To Database Homepage": - "Firefox can't establish a connection to the server at"

(When installing i chose port 1234)

Now i cant uninstall it (I've installed it through dpkg for forcing architecture, and opening the .deb package i don't get the "uninstall" button)

View 9 Replies View Related

Server :: Script To Run At Boot For Auto Mysql Database Check?

Oct 27, 2010

I'm running zoneminder on Ubuntu 9.10 Even with a UPS the power quite often fails enough that I need to drive over bring home the computer and run ( mysqlcheck --all-databases --auto-repair -p ) Then enter my user PW then my Mysql PW. Both are the same. How ever if it were possible to create a script that could run at start up I could get anyone to cycle the power and let it fix it's self.

View 6 Replies View Related

Ubuntu :: How To Schedule Auto Shutdown

Feb 4, 2010

How to Schedule auto shutdown in Ubuntu? I am a newbie. Last night I have some downloads in progress while at the same time I really wanted to go asleep. So I wondered if there's a way to schedule auto shutdown the system after a set period of time. I heared its possible using command line but dont know the usage.

View 9 Replies View Related

Ubuntu :: Auto-shutdown After A Process Stops?

Jan 12, 2010

in windows I have this little program called "poweroff". I use it to shut down my pc after vlc stops playing a movie. I set vlc to shut itself down after playing, and then the program starts a countdown to shutdown the pc. is there a similar program for ubuntu? could this be achieved through the command line? I'd like it to give me little warning period though, where I still have the option to cancel.

View 2 Replies View Related

Ubuntu :: (auto) Saving Files Before Shutdown?

Jan 15, 2011

I am wondering if there is already a feature, and if not, then a way to save any open files before a shutdown occurs?

I use xfce4 battery plugin and there is the option to invoke a shutdown whn the batt. hits critical percentage, but I would like to be able to run something at the low percentage stage to save any open files in case the critical stage is reached. I have had no luck googling any solutions or potential solutions.

View 3 Replies View Related

Ubuntu :: Application For Auto Power On & Shutdown?

May 10, 2011

I found an application AUTO POWER ON & SHUTDOWN in windows which is really very useful to those who have night unlimited broadband connection. I searched for similar application in UBUNTU as I am slowly shifting to UBUNTU from 10.04 (maveric) version. Whenever I search for application or for other options, so many have written failed attempts only.

View 5 Replies View Related

Debian Hardware :: Laptop Auto Shutdown Just After 5 Minutes?

Jun 22, 2011

Laptop : Dell Latitude D620 - Intel Core2Duo T5500 1.66GHz - Intel 945GM graphic - 2GB DDR2 667 RAM - Samsung 400GB SATA 5400rpm Harddisk. OS : Debian Squeeze amd64 - Gnome. I browse the web with this laptop,with ethernet connection,with Icewesel running 2 tab,just after 5 minutes,it auto turn off itself. Never happen before,I don't know what happen. This laptop only support 2D,there's no 3D graphic driver,so no visual effect apply. I start the laptop after 10 minutes,type sensors and get this output :

Adapter: Virtual device
temp1: +46.5C (crit = +126.0C)

* Before it auto shutdown,I place my laptop on desk with a simple rack to lift the rear from desk about 5cm,without cooling pad,and no direct wind flow from my desk fan as I always did.

View 1 Replies View Related

Ubuntu :: Disable Auto Eject When Live CD Shutdown

Aug 27, 2010

Is there some file I can alter on the Live CD image that will make Ubuntu not automatically eject the drive tray when I shut down from a live CD session?


/etc/rc0.d/S89casper is a link though, so I just edited the file it points to (/etc/init.d/casper) -- seems to be working. I merge a modified "casper" at every boot, next time I build a Remastersys, I'll try to make it permanent.

View 9 Replies View Related

OpenSUSE :: How To Configure For Computer Auto Shutdown After A Period Of Time

May 2, 2011

I install Opensuse 11.4 on KDE environment then I changed to XFCE. I don't know how to configure for computer auto shutdown after a period of time don't use it.

View 6 Replies View Related

OpenSUSE Install :: 11.2 / Gnome Flakey Auto Bootup & Shutdown

Mar 29, 2010

I didn't notice any relevant complaints regarding 11.2 in the archives. The bootup & shutdow may be different problems. Randomly my recent install boots up fine or hangs with a blank black screen. A Ctl Alt F2 gets me to a prompt. Startx returns a lockfile comment that X is already running.

From here I can shut 11.2 down and restart it OK. There must be a bootlog kept in /var somewhere. I haven't tried the non-automatic bootup. The shutdown randomly drops back to the logout screen. Usually a shutdown command from there will shut it down. Sometimes shutdown doesn't work, but restart will finish the shutdown.

View 9 Replies View Related

Copyrights 2005-15, All rights reserved