General :: Validating Oracle Databases On Server
Mar 4, 2011
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)?
View 1 Replies
ADVERTISEMENT
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
Jan 20, 2010
I've got several servers running RedHat4 ES, alongside several Windows 2003 servers with MS SQL on them.
Is there a MS SQL Client for Linux so I can connect to the SQL Server databases?
I'ev got Oracle running as well, and I can back these up from my linux boxes easily as there is a Linux ORacle client. I'd like to do the same with MS SQL, so I have one central location doing my database backups .
View 4 Replies
View Related
Mar 25, 2010
I need to move mysql databases from my hard drive which is currently in external box. I can't boot the drive since the laptop is down. Nothing of the distribution on the drive is missing. I just need to know which files/folders copy to my new computer to have all databases running. Old computer ran on Dreamlinux (Debian-based). I'm currently running Ubuntu 9.10.
View 5 Replies
View Related
Mar 9, 2010
I have a system with opensuse 11.0 and mysql
After changing the administrator password only information_schema and test databases are shown in GUI tools (webmin or mysql administrator GUI tool). After the error I restored the password to the old used
if I use mysql in terminal, and use show databases; I can see the 7 databases that I have.
I aslo cannot access to any field using GUI tools (cannot acces to database permissions, or MySQL Server Configuration, host permissions or MySQL system variables). The error is:
DBI connect failed : Access denied for user ''@'localhost' to database 'mysql'
Do you know how to restore the view/access to databases?
View 1 Replies
View Related
Apr 28, 2011
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 Related
Jul 20, 2011
The 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 Related
Aug 2, 2011
Rebooted my server after some funky stuff started happening with mysql. Turns out the drive that stores the mysql databases has gone missing. I did an fdisk, and the partition table is gone. I used gpart to see if there were any partitions available & there were -- two + one swap. Can you help me put this back together I know very little about reconstructing a table to use... Here is the output of what I've talked about...
b14:~# fdisk -l
Disk /dev/sda: 164.6 GB, 164696555520 bytes
255 heads, 63 sectors/track, 20023 cylinders
[code]....
View 1 Replies
View Related
Aug 7, 2010
how can I display all databases and their size using command lines (linux) in a mysql server?
View 3 Replies
View Related
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
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
Jan 27, 2010
I was trying to install ns2 under xubuntu 9.10.but after validating tcl,just while starting validating tk,it stops the process of installation then & there & shows some messages like
autoconf not found,makefile not found etc. & at the last shows that visit [URL].. it is my final year project. Further,can any1 guide me in creation of "MAKE" file for
View 6 Replies
View Related
Apr 3, 2011
I'm writing a script to read user input for a computername.I need a check that a given userinput is valid.Right now I use grep like this (for sure not optimal):Quote:
if echo "$name" | grep -q '[^a-z][^A-Z][^0-9]'; then
echo error
else
[code]....
View 12 Replies
View Related
Jun 22, 2011
My /var/database/ directory is filled..!
Is there any way to redirect some databases to another directory .
View 4 Replies
View Related
May 23, 2010
I have some big sqlite3 databases in ~/.mozilla/firefox/profilename Notably places.sqlite (12 MB) and urlclassifier3.sqlite (33 MB). Is it possible to truncate them and wipe out the oldest records in them? Of course I could just wipe them completely, but that's not my goal - I just want to minimize the size of those files while keeping the newest records.
View 2 Replies
View Related
Feb 15, 2011
Starting mysqld daemon with databases from /var/lib/mysqli m installed mysql-5.0.77-4.el5_5.4
[root@serv ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@serv ~]# /etc/init.d/mysqld stop
[code]....
View 6 Replies
View Related
Jul 24, 2011
I've AMD64 system with Ubuntu 11.04 installed. It's been rough ride for me to install oracle-xe-universal. I've already spent more than 2 days on this. Still unsuccessful.
1) First I downloaded the packages libaio_0.3.104-1_i386.deb and oracle-xe-universal_10.2.0.1-1.1_i386.deb
2) Then I ran
sudo apt-get install bc (ran fine)
sudo dpkg -i --force-architecture libaio_0.3.104-1_i386.deb (ran fine)
sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb
(gave me dependency error for libc6 (>= 2.3.2), I modified the control file to remove dependency and rebuilt the package) (now worked fine) Oracle xe is now installed. Then I tried to start the DB it started but it's HTTP client never started. So I decided to uninstall the oracle-xe=universal. None of the sudo apt-get remove oracle-xe-universal command's didn't worked for me. So i went for manual uninstallation directions as per oracle link.
I ran the following command-
--Manually uninstalling Oracle 10g--
sudo rm -rf /usr/lib/oracle /etc/oratab /etc/init.d/oracle-xe /etc/sysconfig/oracle-xe /usr/share/doc/oracle_xe /usr/share/doc/oracle_xe_client
Then I again ran the following command to install oracle-xe
sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.0_i386.deb
See below what I got as the output-
rocky@ubuntu:~/git/mygit/edas2/libaio$ sudo dpkg -i --force-architecture oracle-xe-universal_10.2.0.1-1.1_i386.deb
dpkg: warning: overriding problem because --force enabled:
package architecture (i386) does not match system (amd64)
[code]....
Even in applications menu I don't see the if oracle has been installed. So i conclude first time installation was ok but somehow http client didn't worked. After manual uninstallation, second installation didn't even loaded/installed the oracle-xe in init.d directory.
View 1 Replies
View Related
Oct 25, 2010
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 Related
Jun 18, 2010
I was having issues with MySQL Server and uninstalled it. I still have my databases at /lib/var/mysql.
My question: if I install MySQL Server (same version, 5.1) again, will it delete my databases, or will they still work?
View 1 Replies
View Related
Jun 10, 2011
Relational databases usually have their data over in /var/lib/something. Users are in /home (with data in /var/www). How can I apply a single total disk space quota across all of these independent software systems (file systems, RDBMS, etc.)?
P.S. There's a bet going on around me as to just how awesome SU is. Let's see what you've got.
View 1 Replies
View Related
Aug 18, 2010
I'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 ?
View 3 Replies
View Related
Apr 20, 2010
I'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 Related
May 13, 2011
I 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.
View 4 Replies
View Related
Nov 2, 2010
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 Related
Nov 30, 2010
Does the RHL 8.0 version supports the Installation of Oracle 10g
View 3 Replies
View Related
Feb 3, 2010
Startx 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 ~]$
View 1 Replies
View Related
May 8, 2011
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.
View 11 Replies
View Related
Mar 5, 2010
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.
View 1 Replies
View Related
Jul 31, 2010
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 Related
Feb 16, 2011
I 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
View 1 Replies
View Related
