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 Repliestranslationables,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 RelatedHow to compare oracle database table contains using (Perl/Shell)scripts.
View 4 Replies View RelatedI 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 RelatedI 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 RelatedI'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/libreadline.so.3: undefined symbol: PC
I have searched on Google.com for 2 days but I can't resolve the problem.
i am installing oracle database 10g2 in my fedora12 with the help of this link ORACLE-BASE - Oracle Database 10g Release 2 (10.2.0.1) Installation On Fedora 7 (F7)Now i am start my Database using sqlplus:[oraclelocalhost ~]$ sqlplusSQL*Plus: Release 10.2.0.1.0 - 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
[code]...
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. (database.organization.es)
Port: 1521
- Oracle JDBC Driver:
oracle.jdbc.driver.OracleDriver
But I press the test button, I receive an error: JDBC Driver can't be loaded (really, the message is in spanish).
I've just installed the Oracle Instant client using this: https://help.ubuntu.com/community/PHPOracle
The phpinfo() show me that oci8 is enable, but when I try to query that database I've got the following message:
PHP Code:
Code:
How to troubleshoot.
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'
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 RelatedI 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.
[code]...
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 RelatedHow to connect to remote oracle database using perl?
This is what I tried.
Code:
But I am unable to connect.
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 RelatedI'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?
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 (11.1.0.6). 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.
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 RelatedI 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
Code:
#!/bin/sh
# chkconfig: 345 99 10
ORA_HOME=/oracle/app/oracle/product/11.1.0/db_1
[code]....
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 RelatedI'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 127.0.0.1:1234"
(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)
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 RelatedHow 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 Relatedin 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 RelatedI 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.
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 RelatedLaptop : 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 :
acpitz-virtual-0
Adapter: Virtual device
temp1: +46.5°C (crit = +126.0°C)
* 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.
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?
[URL]
/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.
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 RelatedI 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.