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 RepliesI 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 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]...
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 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'
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 RelatedI 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'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.
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?
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'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.
When i was in Windows, i had absolutely no problem creating and running basic terminal C++ programs. I came to Ubuntu, and now I've got a big problem: I can't run any program that i make. I have tried making programs in Code::Blocks, CodeLight, MonoDevelop, and NetBeans. All 4 four are free IDE's from the ubuntu installer. I've created 4 programs, 1 on each, and they're all the EXACT same program. When i build it, they build just fine and run. When i release and compile it so it becomes an .exe program, i can't open it. I find the thing, double click, and nothing happens. I rightclick and choose Run, and nothing happens. I made a basic Hello World program, and i couldn't even run that. Is there an extra thing im supposed to install to allow me to run .exe or something?
View 9 Replies View RelatedI am trying to Install Open Suse 11.3 (burned as an ISO DVD) along with existing Win 2008 R2 OS. When I try to boot from the DVD it just logs in to Win2008 though boot from CD/DVD is enabled in the boot sequence. So i tried to mount the ISO and run from Windows ! BUT I get an error before installation starts telling that Win2008 R2 is not supported in open suse installer! Is there anything I can do to overcome this and install/retain both OS? In fact I am even trying to c hange my win2008 from R2 to Enterprise to see if I can overcome the problem!
View 9 Replies View RelatedI'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)
On ubuntu i just compiled my first program using lazarus and i can open it in terminal fine but if i double click the file simply marked 'hello' nothing happens.
Here is the source:
PHP Code:
program Hello;
I need to connect a Server CentOS 5.6 with DB MySQL with a DB SQL Server 2008 on Windows Server 2008 R2 64bit, but i don't know how to do this.
So that MySQL DB has to import data from SQL Server on Windows Server.
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.
I'm using kubuntu 10.04 LTS and i need to open a wdb or a mdb (database file) and then save in one of those formats for a computing course I'm doing.
View 2 Replies View RelatedI have successfully installed endnote x3 running under wine to this document: [URL]..and thanks to winetricks to complete the dll requirement that endnote was asking on startup.
Nos i have two problems: 1/ i am not able to open pdf document linked into the database, i have this error:
Code:
This URL (\Z:mediasda5path oJPP.dataPDFauthor2008-1341524334author2008.pdf) could not be launched
2/I have some issues with the left panel : all text are big black line instead of words (see attachment)
I used Brasero to make a video CD (VCD) for my friend who wanted a disk of some vids I'd shot of his recently-deceased dog. When I select the CD, Ubuntu asks if I want to start "Movie Player". I click yes, totem starts... then I get the message:
Code:
An error occurred. Could not open location; you might not have permission to open the file I've looked at my permissions, under System > Administration > Users and Groups and I can't see where I'm missing a relevant permission. What am I doing wrong?
EDIT: What is up with me today???? It's meant to be 10.04, 10.04, not 8.04.
RE-EDIT: Please disregard the above EDIT - some kind mod/admin edited the thread title for me. (I guess it's pretty daft of me to ask you all to disregard an EDIT that you've already read. But I've done it anyway. So disregard, disregard, disregard... you are feeling sleepy..
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 RelatedI'm experiencing a problem running Banshee 2.0 on my Ubuntu 11.04 system. Basically, I'm getting the following fatal error, the code of which is quoted hereunder. Of note is that uninstalling and reinstalling Banshee (through Ubuntu Software Centre) doesn't fix this problem. Incidentally or not, I also seem to have a problem with my other (and preferred) media player, Amarok. This is the error code:
Code:
Si verificata un eccezione non gestita: Sqlite error 14: unable to open database file (SQL: UPDATE CorePrimarySources SET CachedCount = 1568 WHERE PrimarySourceID = 1)
at Hyena.Data.Sqlite.Connection.CheckError (Int32 errorCode, System.String sql) [0x00000] in <filename unknown>:0
at Hyena.Data.Sqlite.Connection.Execute (System.String sql) [0x00000] in <filename unknown>:0
at Hyena.Data.Sqlite.HyenaSqliteCommand.Execute (Hyena.Data.Sqlite.HyenaSqliteConnection hconnection, Hyena.Data.Sqlite.Connection connection) [0x00000] in <filename unknown>:0
Exception has been thrown by the target of an invocation.
I met this problem when I was installing MaterialStudio4.4 .
error: db4 error(13) from dbenv->open: Permission denied
error: cannot open Packages index using db3 - Permission denied (13)
error: cannot open Packages database in /var/lib/rpm