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 Repliesi 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 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 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 RelatedI 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 Relatedis it possible to restart /start/stop all services at the same time without rebooting?
View 3 Replies View Relatedtranslationables,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 RelatedI'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'
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 Relatedin 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 RelatedHow to compare oracle database table contains using (Perl/Shell)scripts.
View 4 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?
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 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 RelatedWe 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 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 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 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 Relatedi have installed apache and bind on my server and i've also registered a dynamic domain through dyndns as jan27.dyndns.biz. i am able to successfully host my own webpages using this method.
then i registered a domain name (lets call it "blah.com") through namescheap.com 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.. www.blah.com and blah.com would lead me to a opendns.com page but interestingly ns1.blah.com loads my webpages successfully.
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 address.im having 3 ethernet cards...this is my main server of company.
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 RelatedJust 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 RelatedXubuntu 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 RelatedWith 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
Code:
service smb off
In Ubuntu 10.04 its
1) edit /etc/init/smbd.conf and modify the line that says
Code:
stop on runlevel [!2345]
and change it to
[Code]...
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?
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?