I am not an oracle DBA, but need to find the cause of high load avg, even after adding more CPU power the load avg is the same.
Old and new servers load avg is the same (between 6-10 peak hours and 3 to 5 during off-peak hours) no difference. I expected the laod to come down as we added more CPUs.Our DBA says queries are optimise.Can some Oracle DBA give some tips to find the cause.
there is any other way to make oracledb on CentOS 5.4 and HP Proliant DL360 G5 Server fast access from a vb application. modified, reconfigured all to make faster but no use
View 2 Replies View RelatedI'm completely new to oracle and need to install oracle 11g onto my Linux box. But my Linux box currently has no X Term (KDE or Gnome).
Is there a way in which I can install this without the GUI ?
There is a tool appeared in repository called ktune; The purpose is to adjust some sysctl.conf settings to improve server speed on servers with heavy load. What is this tool for if one can achieve the same with the configuration file added to system startup? Or ktune is just such file?
View 1 Replies View RelatedI got this type of messages:k journald starting. commit interval 5 seconds.EXT3.fs:mounted file system with ordered data modefreeing unused kernel memory : 212 k freed.Warning:unable to open an initial consoleAfter this Server is not hang state but stay at same Anybody can help me how to resloved this type of issue.
View 1 Replies View RelatedI'm trying to configure DNS on Oracle Enterprise Linux 5.4 - Kernel 2.6.18-128.el5. When I restart the named service, I'm not getting any errors. But service is showing Failed. What could be the reason?
View 3 Replies View RelatedI have an issue with few servers. All have OEL 5.5 and various versions of oracle (mainly 10g something).
I've noticed on one machine that amount of free memory is slowly decreasing. When it comes to less then 30M, application has problems. Ive tried adding mem on this machine (virtual), and it behaves the same.
The same is on physical machines I have simmilar, if not the same config. Variations are with physical memory installed, and it does not matter if servers have 2G, or 8G, free -m gives around 30 free
It does not swap, and does not make some big issues on other machines, but on this one, application that uses this DB timeouts the user. Is there some chance to check what is creating this issue?
P.S. I've tried with DB admin to check something related to oracle itself, bit when we shutdown instance, Oracle frees 1.5G allocated to him, but nothing else. Will try testimg a bit more, but any thought on this is usefull. This is production server, so no big issues can be done. Will try to copy it to other hardware and do some testing, but then no App server available to attack it.
I am running a 5 node 11g RAC cluster with cluster ready services. The hardware is HP BL460g6 with virtual connect modules on each chassis. The OS is RHEL5.5, 2 Qlogic 4G fibre cards, 2 Broadcom NICs bonded, and the backend disk is all Hitachi 15k. The issue that I'm seeing is periodically each day there are spikes in I/O waits for disk writes, and sometimes that will cause a node or 2 to reboot when CRS can't communicate with the other nodes. Both nodes that have been evicted, are on the same chassis. What I've checked is, the backend storage is not seeing ANY high utilization, in fact it's running at less than 10% all the time. The network is 10G, and is not showing errors on the switch, or on the blades themselves. The redo logs have a 10M buffer cache, and are running on ASM disk. What other information would be beneficial to check? I am seeing nothing in the logs as to any errors, or waits for disk writes. I believe it's a software issue, but am lost as to how to prove it. These aren't the only nodes experiencing periodic high I/O waits, and it happens at the exact same time on all systems, whether they run ASM or are part of a cluster.
View 1 Replies View RelatedI run a server with nginx at the front and apache at the background. Nginx serves as a reverse proxy in here. As there were lots of DOS attacks, I have implemented Deflate-DDOS, APF and Nginx anti-ddos features and the server runs without a problem. Once every month, the load on server increases upto 300 and I receive an email like this :
Subject : Cron <root@server> [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm
Content :
find: `/var/lib/php5/sess_0ca40520ac8ecb66090746f90da17516': No such file or directory
find: `/var/lib/php5/sess_3839b0cbf042934183d56ff682c948e0': No such file or directory
find: `/var/lib/php5/sess_dec1ed8ea1f62caf7a42a29b9f82c506': No such file or directory
[code]....
There's more that 100,000 ( I suppose ) lines on this email. I have no idea what the problem is. It seems there's something with the session, but I really don't know what it is.
I just found that PMON and SMON are running (i.e., showing in the output of ps -ef | grep -i [o]ra)but when I check MMAN (used for internal database tasks), nothing comes up:
Code:
ps -ef | grep -i [m]man
Is that okay or could there be some problem?
So, what are the essential processes of an Oracle Databse that we must check for their status to make sure that the Oracle Databse is up and running fine? What steps do you usually take to validate an Oracle Databse on a Unix / Linux (Production) Server (specifically immediately after a CR has been worked upon)?
I need to know that how to use my micromax MMX 352G (USB MODEM) in oracle linux. i am unable to detect my modem using wvdialconf.
View 2 Replies View RelatedThe Default Template for installing Oracle VM Server has 10GB, what are the factors to take into account when considering sizes. I have only seen one installation, and 2 sizes were changed to 23072 and 5000. How can I see these settings?
View 1 Replies View RelatedDoes the RHL 8.0 version supports the Installation of Oracle 10g
View 3 Replies View RelatedStartx by non-root user account in red hat linux kernel 2.6. How can I use the command "startx" by other user account such as "oracle"? I cannot startx by user account oracle?
Code:
[oracle@localhost ~]$ startx
Fatal server error:
PAM authentication failed, cannot start X server.
Perhaps you do not have console ownership?
Please consult the The X.Org Foundation support at [URL] for help.
[1]+ Stopped startx
[oracle@localhost ~]$
I have oracle installed on Linux I want to schedule a script "backup.sh" to run in oracle user.
oracle@linux1]crontab -e
*/2 * * * * /tmp/backup.sh
this script does not execute by cron.
But
oracle@linux1 tmp] ./backup.sh ------executes successfully
I don't know why the script is not being executed by cron.
We have a Wipro Net Power 8552 server on RAID 5 with Linux Advanced Server. The Databse is Oracle . Every time the reocovery is made the block corruption error gets changed. There are four hardisk in the Raid with 18 GB capacity of Quantum make. I want to make sure if any Utility is there in Linux to check the Harddisk if any Block corruption is there or Not.
View 1 Replies View RelatedI am going to install Oracle RAC on two Servers, With shared SAN storage (Servers and Storage is IBM) OS = RHEL 5u5 x64 bit
And we used multipathing mechanism and created multipathing devices. i.e. /dev/mapper/mpath1. Then I created raw device /dev/raw/raw1 of this /dev/mapper/mpath1 Block device as per pre-reqs for Oracle Cluster. Every thing looks good, But we faced the performance issue as under.
when we run command :
#dd if=/dev/zero of=/dev/mapper/mpath1 bs=1024 count=1000
the writing rate is approx. 34 MB/s
But If we run command
#dd if=/dev/zero of=/dev/raw/raw1 bs=1024 count=1000
the writing rate is very slow like 253 KB/s
Installing Oracle iPlanet Web Server
Installation Summary
Product Status Information
1. Oracle iPlanet Web Server Configuration Failed View log file
1. View log file
2. Done
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 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 RelatedMy Setup: Dell Laptop (BIOS allows boot from USB) - Vista 32 bit installed, 4 GB memory
External 500 GB HDD (iOmega) - Partitioned as follows:
NTFS: 50 GB
/boot: 1 GB
below two on one logical volume:
swap: 5 GB
/: rest ~ 440 GBI installed Oracle Enterprise Linux on the external HDD.
Did not install the Grub bootloader as I don't really want a startup boot option. The way I was planning to make it work was: When USB HDD connected and laptop powered up, it'll boot to the Oracle Linux. When the USB drive is not connected and laptop powered up, it'll boot to Vista. When I boot with the USB HDD connected, nothing happens. I get a blank screen with a blinking cursor. The USB HDD light comes on though. Is the above plan possible, or do I have to have a Boot loader installed?
If I have to have a boot loader installed, how can I just install the bootloader and not have to reinstall Linux on the HDD. The Linux drive is currently empty, so I'm open to any good suggestions to partitioning it. I want to keep a small amount of NTFS space on that drive to store some windows files and documents that I can carry around. The rest 450 GB is open for Linux. And I Plan to install Oracle Database and Apps on Linux (which takes about 350 GB of space).
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.
Could anyone give the steps for converting a logical volume to a raw disk to mount Oracle ASM Instance on it?
View 2 Replies View RelatedI want to setup a cron job to run a bash script which which calculates the server load and if the load is above certain value(say 15) then stores highest cpu eating users list in to a file for that instant. I have a small script which lists users according to cpu usage.. But i dont know how to check the server load and if and only if its above 15.
View 12 Replies View RelatedI have a CentOS 5 server running Apache & PHP. When I load 'Phpmyadmin' on the server it worked fine however there is a message at the bottom of the screen that says:Quote:Cannot load mcrypt extension. Please check your PHP configuration.I checked to make sure that the 'mcrypt' package is installed on the server:
Code:
[root@ideweb1 ~]# rpm -qa | grep -i mcrypt
php-mcrypt-5.1.6-15.el5.centos.1
[code]...
Having a problem on all of my Ubuntu machines when i goto this address: [URL]... i get a "server not found Firefox cant find the server [URL]... this is only happening on Linux i have a dual boot on an epc with vista and it loads the site. normally i wouldn't even care but my girlfriend will be taking on line classes here and i need to get this to load.
View 5 Replies View RelatedHaving been a long-time Linux supporter, it was a no-brainer for me to push Linux as the OS when it was time to move my company's website(s) from an external host to an internal server. My company ponied up the bucks for an HP Proliant DL180 G5 server (this was about a year ago) upon which I installed Slackware 12.1 (I kinda default to Slackware, although in the past I've also used RedHat on the server and openSUSE on the desktop).
Well, it's now time to upgrade the OS on the server. Perhaps I'm a little late to the game on this, but I just recently found out about Oracle Enterprise Linux 5.5. Bad Oracle ju-ju aside, it looked to be a very good and stable server distro, especially when you consider the availability of Oracle support for it. So I've since installed OEL to a non-production server and have been testing it out.It looks to be a good match for my needs.
However, since installing OEL on my test server I've installed Ubuntu Desktop 10.10 on my home desktop (a 1.86ghz Intel Core 2 Duo HP xw4400 workstation) and in a VirtualBox VM on my work desktop (a 3.2ghz Intel Core i3 iMac) and... holy crap, it's the best desktop Linux I've ever had the pleasure of using. It will certainly replace Slackware as my default "go-to" Linux distro. Which has made me wonder about the Ubuntu Server offering and if it might not be a better fit for my webserver in the same way that Ubuntu Desktop is a better fit for my workstation.
Unfortunately, I don't have the time to pull down another server distro, install it, and test it unless I'm reasonably certain that it's going to give OEL a run for its money. So I turn to the forums and the knowledge of the users who frequent them: is Ubuntu Server a strong enough contender to OEL that I should take a more serious look at it? Or, like I'm hearing about the latest Ubuntu Netbook edition, would it not be worth my time if I'm happy with OEL so far?
I have installed a linux server in my office to run 16 machines. Its main use will be a internal mail server but will be also running websites.
I have installed Ubuntu 9.10 server x64 and have got apache running.
I am looking for the simplest more robust solution for smtp, pop3 and imap. I have only ever used qmail before and found it a pain to configure and its getting old so I though I should probably try something new. I have not much experience with running pop3 or imap on linux so would love a suggestion on that.
how to load tun in RedHat
Code:
uname -a
Linux server 2.6.18-028stab067.4 #1 SMP Thu Jan 14 17:06:11 MSK 2010 x86_64 x86_64 x86_64 GNU/Linux