I have been ordered to transfer my database running on oracle 10g on linux 32 bit OS to linux 64 bit. I need to know the advantages of 64 bit over 32 bit. Besides i would like to know if would face any difficulty while i migrate the database from 32 bit to 64 bit.
View 3 RepliesI need to shift the positional parameters of a script inside a function, but any call to "shift 1" inside a function shifts only the parameters of that function. Is there some way of accomplishing that? I tried another approach using an alias. The problem is that I have to take the result of the alias. So I call in my script:
Code:
var=$(shiftalias)
At first time, it works correctly, but after that it does not shift the parameters anymore.
am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies View RelatedI am trying Lucid on my eeepc 701, regular , not the Net Book Remix because i like having a desktop, and am mostly satisfied,except...when using certain programs (rythmbox for one) and particularly after switching up or down the size of the windows (ie the little arrows and boxes in the top left of window) i cannot press buttons on the window or in some cases close the window. the window moves about, up or down, when i click on it. this means i cannot press play or pause or exit the window and am forced to switch desktops and eventually restart.
View 1 Replies View RelatedI am using ubuntu cli 10.04 for several different computers with different network cards, any time I plug in my persistent usb (ubuntu installed on usb) to computer the network would not work, when I find out what is up I see that it is up on next eth driver, I cant enter up to 50 or 100 or 500 entry there all the time and same thing with wireless since I use radius authentication its even makes it worse.
So to summarize:
sudo vi /etc/network interfaces
auto eth0 ifup dhcp
iface eth0 inet ...
...
...
auto eth100 ifup dhcp
iface eht100 inet ....
How to keep one entry for all those different computers (one for eth0 and one for wlan0)?
If I log out of my initial login session, the login w/ username+password screen is *sometimes* shifted to the right (so that the power icon on the bottom right is off-screen, and I have a black column on the left). When I log back into an account, the same shift *sometimes* happens, independent of whether or not the login screen was shifted. User switching *sometimes* results in the same behavior (it's not just logging in and out).
I have also logged in using a different desktop manager (openbox), and have had no issues (so far) with shifted graphics. Logging back out from openbox, the login screen still *sometimes* has the shift.
I am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies View RelatedI 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 RelatedSpecifically I'm looking for a native Linux program that is similar in functionality to Navicat or SQLYog. I.e. I need something good at editing data. Free would be best, but not essential.
View 9 Replies View RelatedI recently installed a portable WAMP server on my usb stick. Really nice, I can do some php programming on my girlfriend's windows7 laptop without installing anything on it.I also have a LAMP environnement on my linux computer.When I plug my usb stick on my linux box, I can easily mount -o bind /usbstick/wwwfolder ~/public_html and work on my php script from there.
But my question is, is there a way I could get the database from my usb stick's MySql server, to run on my linux MySql server? So I can modify data base schema from my Linux workstation, doing some INSERTS in some tables, and then plub my usb stick on the laptop and get my up-to-date database running from the portable environnement?I don't know where / how MySql stores its databases. Basically, I want to "mount" the database from the usb stick in my Linux' installed MySql server, without extracting and importing the data, so there is just ONE database used for BOTH environnement.
parsing the text file in perl.I have very large text file with plenty of columns and rows.how can i parse the file into Oracle database.
View 3 Replies View RelatedI would like 2 computers (same network) to use the same SQL database. How should I start?
View 2 Replies View RelatedI posted a thread regarding a CD Base Application. I can run the program, but for some reason It does not seem to work properly.
For some reason in exits the program back to the command prompt. I am using the code from Linux programming 4th edition which you can get it from here...and in the folder ch08/app you will find all you need to create the CD database application.
I'm trying to connect to a remote database but can't connect directly (I think due to security reasons). Here's the setup:
Computer A - my computer
Computer B - server, I can SSH to this from computer A
Computer C - server that runs database, I can SSH to this from B but can't from A
Any ideas how I can can connect to C directly from A? I think I need to setup a tunnel or something like that but I can't figure it out.
I am not having any knowledge of mysql database & in my present jobs i have to solve problem on mysql database. need some commands which are used regularily in database.
View 1 Replies View RelatedI want to migrate a mysql databases from a old server to a new server ( Redhat ) , can advise what I need to do ,is it just copy all .frm , .MYI & .MYD files to new server will do ? or I need to do export and inport data ?
View 12 Replies View RelatedI need to copy tables from abc5/abc5@pqrXYZ1 to jk8/jk8@pqrXYZ1. For this I am trying to create a link between the 2 databases but not wkng.I am pasting here what I ve tried.
sqlplus jk8/jk8@pqrXYZ1
[code]....
How to backup a particular Databases..through Bash script! For example i have 6 databases;
Anish
linux
Software
Questions
Rhce
Google
these are the databases i have from that i want to take "Anish" and "questions" database backup regularly.
I switched from Windows 7 to Linux and when I'm trying to import my database i get error 1044. It used to work when I was using Windows 7. I was able to export the database from my localhost. However, when I try to import it to the other server I get this:#1044 - Access denied for user ' '@'%' to database'.I have been trying for hours to upload my site from the localhost to another server without any luck..I'm using phpmyadmin to import it.
View 2 Replies View RelatedI m trying to store the output of vmstat 1 10 into a database.I have done the necessary homework to connect bash to interact with the database.Program logic.1)storing the output of vmstat 1 10 to a file named abc.txt2)I m applying a filter to vmstat to get desired output containing cpu(user),cpu(system),cpu(idle) values.3)
Code:
# cat abc.txt | grep -vE '(procs|free)'| awk '{print $13 " "$14 " " $15}'
0 1 97
[code]....
i need to update my mysql database from 5.0 for 5.1, i have several java application and php application running on that server, without disturbing the setup i need to upgrade the server can someone suggest a method of doing this
View 2 Replies View RelatedI was wondering if anyone knows of a good password database I can download for Redhat. It only needs to be basic with a few options such as 'hostname', 'userid', 'password' etc and will allow read access for everyone but only allow administrators to edit, create, delete entries.
Most of the downloadable Password Databases run on Windows but apart from Gringott's I am unable to find a suitable database which will run on Redhat.
I am running RHEL5 and I have just upgraded my RPM software manager from RPM version 4.4.2 to RPM version 4.9.0 (the latest version) by doing a clean install of v4.9.0. The version 4.4.2 came with the RHEL5 and at the moment is very old so I cannot install certain newer rpms. I followed the INSTALL instructions that comes with the tarball for V4.9.0. The problem is the new install (i.e. RPM V4.9.0) has no knowledge of my old RPM manager i.e. V4.4.2, hence it does not know of the rpm packages installed on my system.
I think the problem is that the V4.9.0 is a new install rather than an upgrade (There are no instructions on how to perform a 'real' upgrade). I have tried to rebuild the rpmdb for v4.9.0 but that does not help and I have no idea how to import the data from v4.4.2 database to v4.9.0 database. My question is, how do I import the database from RPM manager V4.2.2 into RPM manager V4.9.0 or how do I 'upgrade'properly from V4.4.2 to V4.9.0. I have trawled the internet for some guides but there does not seem to be anything regarding this.
Am using mandriva 2008 i developed one simple application using cross platform = Qt3 Database = PostgreSQL
I want to share my database over peer to peer network.
server ip = 192.168.1.5
client ip = 192.168.1.6
Now how to share data over those ip?
I'm having trouble ssh tunneling through two servers to get to my database. Server3 is restricted to all except from server2 and I'm at server1. So on server2 i do ssh -L1434:server2:1435 -l user server2 - this works i'm able to connect to the db on server3 from server2. But on server3 i'm trying to ssh -L1433:server2:1434 -l user server2
- and I get 'connection refused'. I tried telnet server2 1434 from server3 and i get 'connnection refused'. I checked the firewall is open on server 2 - firestarter confirms that port 1434 is open to everyone. I'm not sure what I'm doing wrong, but I have a hunch that maybe firestarter on server2 is not working correctly, because it also shows that port 22 is open to everyone and I can telnet server2 22 and I'm able to connect.
Ok so I need to Search for a postgres database File on a CentOs System. Is their a command i can run in the terminal to search for postgres files?
View 2 Replies View Relatedhow do I create a shell script that looks for connections running on a oracle database. e.g connection name is CONNECT and database name is DBTEST. I want to know what processes with the name CONNECT are running in database called DBTEST. Am creating the script on the server side. I know about the ps -ef | grep command but how to point to a particular database I don't know.
View 4 Replies View Relatedi want to write a program that need to know how much data has transmitted in network usage _how much send and how much received_which file , record or structure in which library i have to follow ?
View 2 Replies View Relatedi had installed alfresco 3.4 server .previously we are working with alfreso version 1 .how i can moved the database content of alfresco 1 version content in alfresco 3.4 content.whether i had to migrate mysql of 3.1 directly to 3.4 alfresco server are else i had to just put the content in alf_data content store and content deleted table alone is enough .
View 1 Replies View Relatedis it possible to authenticate users logins by a database (postgres, mysql)?for instance: -user types username, pasword, at login screen -OS then connects to server with database and checks if the user is valid. if so, is it feasible to add a time lock function for each user? in the sql, postgres table ? for instance user sandra can only log onto the computer for 1hr at 5pm
View 7 Replies View Related