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 (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.
View 1 Replies
ADVERTISEMENT
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
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
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/libreadline.so.3: undefined symbol: PC
I have searched on Google.com for 2 days but I can't resolve the problem.
View 3 Replies
View Related
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 (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]...
View 4 Replies
View Related
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
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. (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).
View 2 Replies
View Related
Oct 12, 2010
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.
View 2 Replies
View Related
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
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
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.
[code]...
View 1 Replies
View Related
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
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
Dec 26, 2010
How to compare oracle database table contains using (Perl/Shell)scripts.
View 4 Replies
View Related
Jan 27, 2010
How to connect to remote oracle database using perl?
This is what I tried.
Code:
But I am unable to connect.
View 4 Replies
View Related
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
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
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
Mar 1, 2011
How to copy a Read-Only file in Linux and make the copy writable with a single cp command in Linux (Ubuntu 10.04)? The --no-preserve and --preserve seemed to be good candidates, except that they should "and" the mode flags, while what I am looking for is something that will "or" them (add +w mode).
More details: I have to import a repository from GIT to Perforce. I want that all Perforce depot files are Read-Only (that is how Perforce was designed), while all other files that were derived/copied from depot files are writable. Currently if a Makefile tries to copy a Read-Only file then the derived file will also be Read-only. This leads to build-errors when cp tries to overwrite Read-Only file second time. Of course the --force is a workaround here but then the derived file is also Read-Only. Also I do not want to mess with "chmod" after each "cp" command - I will do that only as the last resort.
View 1 Replies
View Related
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 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)
View 9 Replies
View Related
Jan 21, 2011
This is my first time working with NFS but I fail to see what the issue is since everything works properly.
View 13 Replies
View Related
Mar 21, 2009
This situation after a mains power failure took server down.Log oonto server with root, go to Admin > users and get this message:" The user database cannot be read. This problem is most likely caused by mismatch between /etx/password and /etc/shadow or /etc/group and /etc/gshadow. The program will exit now."
View 2 Replies
View Related
Jan 21, 2011
My website, IsleDiscount.com, is hosted on a virtual server with pair.com. Pair.com offers only one SFTP account on regular shared server and to set up mutltiple SFTP accounts, Pair.com moved me to a virtual server (VQS1), which I believe is not a shared server solution, but Pair representatives were able to create multiple SFTP accounts on this VQS server.
However, when I asked the representative to restrict access of this additional SFTP accounts to a sub-folder, I got the following warning email: confirm you understand this will make your entire web directory world-writeable. This will increase the chances of a security attack. If you do understand this, you can go ahead and execute the command yourself. The command below will accomplish both commands in one.
[Code]...
View 1 Replies
View Related
Apr 14, 2010
This may come across as a bit of an isolated and complex problem, but I haven't been able to get my iPod Nano 5th Generation to have any sort of compatibility with any iPod management programs (except with using Nautilus I guess). This includes gtkpod, Banshee and Rhythmbox.With Rythmbox, my iPod shows up in the pane, but I cannot interact in anyway except ejecting it. There aren't any msgbox errors.Banshee cannot read the iTunes database or something and insists that I rebuild the database on the ipod so I can use it with banshee. I did and gained full access to Banshee's iPod management with all the features it carries. I moved my music library on to the ipod but the thing states that I have zero songs whilst banshee states otherwise.
iTunes on my Windows PC will show that I have x number of GB of "other" information after using Banshee to move music. It seems that it is transferring data sufficiently but is not recognising it as "audio" gtkpod wont let me manage the iPod before or after Banshee's tampering.
View 4 Replies
View Related
Jan 31, 2010
I am trying to get write access to a share on xp machine via automatically mounting
the share via the following /etc/fstab entry .... after doing a sudo mount -a ... I can view the files on the 'C-share' but can not write them back to the server
//WINBLOWS/C-share /media/C-share cifs,rw
This used to work and allow share files to be read and writable before some ubuntu updates.
I am currently running ubuntu 9.10.
PS: if I connect via places->network ... the files are readable and writable ... but I need this setup to be automatic with a mount for someone else.
What needs to be added to the above fstab entry
View 1 Replies
View Related
Jun 7, 2010
I had my server going pretty good. Two sites being hosted. Wilmingtoncoc and Mikealrhughes. Last night we had Thunderstorms and Tornadoes come through. While I was out Tornado chasing. We lost power here for an instant and back on. When I came in the server was off. So I booted it back up. The mikealrhughes site is still working good. The Wilmingtoncoc site is giving me a Database read error, it is a WordPress site. Also I can't log into the Server using SSH. Where do I start to repair the problem? Do I reinstall SSH if so what is the command I use? Then how do I solve the WordPRess Database problem? Also when I try and issue a command from the Server with sudo in front of it I get an error message that says - sudo: must be setuid root - whatever that means. I couldn't find that in any of the books I have.
View 6 Replies
View Related
Oct 13, 2010
I built the indexes, but when I search I get this: Top-Level Documentation Application Manuals
openSUSE Documentation (en)
Htdig error: Unable to read word database file '/home/philip/.kde4/share/apps/khelpcenter/index//opensuse-manuals_en.words.db'
[code]...
the UNIX manual pages work, the Application Manuals show nothing, and the openSUSE Documentation shows the same error. This is the same no matter what I search for.
View 9 Replies
View Related
Sep 8, 2010
I would like to make a script which reads a POP3 mailbox on another server and saves the items in the mailbox to a MySQL database. Is this possible? I have to make this script to create monitoringen scripts which has to use the messages in the mailbox.
View 2 Replies
View Related
Oct 11, 2010
Unless your distro has taken care of it Centos 5.5, you'll need to create a user with a password and read/write privileges for program database. You can do this using the MySQL command line client if you are familiar with it. Well I am not familiar with it, so I wam wondering how to do it. As well when I run
mysql - p program </usr/share/program/mysql.sql>
It asks for a password. how do i find out this password.
View 1 Replies
View Related
Jul 8, 2011
I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?
View 2 Replies
View Related