Oracle is a relational DBMS (Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java.

learn more… | top users | synonyms

3
votes
1answer
3k views

logfile deleted on Oracle database how to re-create it?

For my database assignment we were looking into 'database corruption' and I was asked to delete the second redo log file which I have done with the command: rm log02a.rdo this was in the ...
2
votes
0answers
272 views

Oracle concurrent programming execution methods

I created a package and a stored procedure under it to test a concurrent program. When I run it as an Oracle report executable method it works fine. But when I change it to PL/SQL stored procedure ...
-5
votes
1answer
107 views

What is the stability level of Oracle 11g? Is it suitable for production? [closed]

We are using both Express edition and Commercial edition to power up a Distributed application. Is Oracle 11g a good candidate for this application since we need data synchronization? Or is Oracle 10G ...
1
vote
2answers
3k views

Running SQL*Plus with bash causes wrong encoding

I have a problem with running SQL*Plus in the bash. Here is my code #!/bin/bash #curl http://192.168.168.165:8080/api_test/xsql/f_exp_order_1016.xsql > script.sql wget -O script.sql ...
2
votes
3answers
736 views

Sunfire v100 Reinstall Problems

I own two Sunfire v100 servers, and I use hyperterminal to connect to them. I am trying to re-install Solaris on one of them, so I put in the LOM cable and unplugged the harddrives. Here's the ...
5
votes
1answer
29k views

How to execute datapump commands as sysdba from remote machine

I would like to know the syntax to call datapump commands (expdp/impdp) logged as 'sys as sysdba' from a remote machine. I know that when logged on the machine which runs the database, I can use : ...
2
votes
3answers
368 views

Change local admin password. Impacts on Oracle and Citrix?

I need to change the local admin password on some Citrix and Oracle servers. These servers are in production. Then we will start using a secure password procedure, and change them every X month. ...
0
votes
2answers
118 views

Configuring swapfile error

I installed oracle linux 6 on my desktop but I forgot to configure the swapfile, I want to install oracle 11gr2 on it and it requires 2gig or ram, if I type the following commands on the terminal I ...
1
vote
2answers
605 views

Oracle only starts with autostart, doesn't when trying manually

I have installed oracle on my ubuntu system a few months ago and its been working pretty well. I have it setup to start on system boot and I run the following commands to stop/start the service sudo ...
0
votes
2answers
506 views

MS Project Server 2010 and Oracle Database Backend?

After searching far and wide across the internet for an answer I have come here in hope of help. I am aware that MS Project Server 2010 requires a SharePoint server, but does anyone know if it is ...
0
votes
1answer
109 views

DB2 to Oracle Migration

I am migrating a very large and complex database from DB2 to Oracle 11g. Can someone suggest any tools / processes to do this very quickly. My database is about 500 GB and it cannot have downtime ...
1
vote
1answer
729 views

How to enable Oracle-Managed Files on Oracle Express for Windows XP

I'm trying to enable Oracle-Managed Files on Oracle Express for Windows XP. From everything I've read, I need to set db_create_file_dest to an existing directory in the file system. I've tried ...
2
votes
2answers
675 views

How to keep filesystem layout identical in every RedHat Installation?

I want to keep the following layout same in every installation on the identical servers: dm-0 /dev/VolGroup00/LogVol00 dm-1 /dev/VolGroup00/LogVol01 dm-2 /dev/VolGroup00/LogVol02 dm-3 ...
-3
votes
1answer
83 views

Oracle 11g on a hard disk [closed]

Can I install Oracle 11g on a hard drive. Can I use this hard drive in another computer where 11 g is not installed and just play a bit with Oracle?
2
votes
1answer
2k views

Installation ORACLE 11g in an external hardrive

I am working on a project in which i have to deal with oracle 11g. My project manager wants me to install Oracle 11g in an external hard drive. I already installed it in the hard drive, though when ...
0
votes
3answers
135 views

where does Tomcat and application logic sit on 2-server system (database server or webserver)?

I have an application depending on BlazeDS and Oracle Application Express, which both require the use of Tomcat or equivalent. I have the following two Linux servers: (1) Oracle database 11G (2) ...
3
votes
2answers
14k views

oracle lsnrctl TNS-12545: Connect failed because target host or object does not exist

I am trying to connect to my oracle database. I can't get the listener started. Here is what I have tried. $ lsnrctl start LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 20-JAN-2012 ...
1
vote
1answer
2k views

ORA-12514: Message 12514 not found with two Oracle clients

A user is getting the following error when attempting to connect to an Oracle database through an Oracle Forms app. I also get the same error when I try to connect from their computer using sqlplus. ...
1
vote
1answer
458 views

One Way Replication of Oracle 11g to MSSQL 2008R2

We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS. What is a good method to automate a one-way, read-only ...
0
votes
2answers
3k views

Howto enable remote login for a Oracle db user?

Stupid question: I've successfully installed Oracle 11g on my Linux box. I can connect to it and retrieve the countries table via C#/mono just fine, with the below connectionstring, which uses the ...
1
vote
1answer
3k views

Can't fix “ORA-00990: missing or invalid privilege” on a sequence

I'm getting "ORA-00990: missing or invalid privilege" on this kind of statement: GRANT USAGE ON SEQUENCE SOME_SEQUENCE TO SOME_USER; I've researched this all over the Internet and AFAICT, this ...
1
vote
1answer
2k views

Oracle 11. Updating BLOB field. Db file sequential read inappropriately slow?

I've and Oracle (11 Enterprise) schema with a table CREATE TABLE USER.WSP_BUNDLE ( NODE_ID RAW(16) NOT NULL, BUNDLE_DATA BLOB NOT NULL ); CREATE UNIQUE INDEX USER.WSP_BUNDLE_IDX ...
3
votes
2answers
17k views

How can I resolve Oracle 11g XE connection failure straight after installation?

I have just installed Oracle 11g XE on a Windows 7 VirtualBox VM, using all the default options. "Getting Started" fails When I click on Getting Started I get taken to ...
0
votes
1answer
82 views

Jmeter gets Apache lost db connection

I have a web app that makes to many ajax requests (update data with a grid). When I use JMeter to make a stress test with 20 threads and 10 loops, my web application canno't connect to the database ...
0
votes
1answer
249 views

Where to create directory for importing over network link?

While using data pump import over network link in Oracle: impdp test/test@db10g tables=SCOTT.EMP network_link=REMOTE_SCOTT directory=TEST_DIR remap_schema=SCOTT:TEST Where are we creating ...
1
vote
1answer
6k views

Use LDAP to authenticate oracle database users

I have Oracle Database 11g set up in few locations in either pure Linux/OpenLDAP, Samba/OpenLDAP environment and a full-blown Windows/AD environment. The applications that will be using those ...
0
votes
1answer
699 views

Recieving ORA-12560: TNS:protocol adapter error on classic ASP same connection in .net works

I have 2 different application installed on a windows 2008 one is .net the other is classic ASP. They would be connecting two different databases however to help trouble shoot the issue I have both ...
0
votes
1answer
263 views

Remote Desktop Services and Oracle 9i

I have an Oracle 9i forms application installed on clients. I am looking at moving this to RDS. Is this possible?
0
votes
1answer
102 views

oracle RAC server addition at DR site after DR occurs

DB: Oracle Server: Physical OS: Linux 5.5 The production site contains 3 server nodes and will be clustered using Oracle RAC, database replication will be done with the help of Oracle Data guard. ...
1
vote
1answer
260 views

How to generate test data from an sql query and a result set?

I am using an oracle database and want to generate test data from a live database, but I do not want to copy the whole database content. Given a database DB(S, D) consisting of the database schema S ...
0
votes
1answer
815 views

oracle enterprise manager agent unreachable (windows)

Since yesterday, the oracle enterprise manager tool on my windows 7 machine is saying that the agent is unreachable. I didn't do anything unusual before this appeared, if I remember correctly I only ...
0
votes
2answers
99 views

how many servers and in what configuration for web application by small company? [duplicate]

Possible Duplicate: Can you help me with my capacity planning? My question is from a startup company providing a web application for the first time. It consists of an Oracle database (11G), ...
1
vote
1answer
2k views

oracle - grant all privileges to schema

i've used mysql before and i'm now switching to oracle. I've already created a user in oracle. Now i want to give it "all privileges" for a schema. In mysql i can give all privileges (DML/DDL) for a ...
4
votes
3answers
9k views

How to install Oracle's exp / imp binaries

I was browsing the net to find a solution, but I had no luck. :( How can I install Oracle's imp / exp binaries to my CentOS box without installing an Oracle Server? I'm accessing an existing Oracle ...
0
votes
1answer
309 views

Installation of Oracle 10.2.0.4 in windows server 2003 [closed]

I have a problem in installingthe oracle database 10.2.0.4 in windows server 2003 environment, when I clicked the installer it always says "...\setup.exe isa valid, but is for a machine type other ...
-3
votes
1answer
264 views

install vncserver without yum on Oracle Linux

can anybody describe me how to install vncserver on Oracle Linux without yum? (yum does not work because it is a pre-built appliance - timeouts all the time)
2
votes
1answer
943 views

Sparc v440 unable 2 boot after recommended patch install

After installing the October 2011 recommended patch bundle on a Solaris 10 the host fails to boot. The output is {0} ok boot SC Alert: Host System has Reset screen not found. keyboard not found. ...
0
votes
1answer
1k views

Trying to install pdo_oci via PECL fails asking for PDO extension

I'm using Linux Mint 11 (based on Ubuntu 11.04) and I need to use PHP with Oracle through PDO, a requirement of the framework we will work with. I've installed various PDO extensions using the normal ...
0
votes
3answers
427 views

XP IIS no longer listen to port 80 or 443 after installing Oracle 9i HTTP Server

I have installed Oracle 9i HTTP Server together with the database. After restarting the PC, even though i restarted the IIS and stopped the Oracle HTTP Server. When I go to http://localhost/ The ...
3
votes
1answer
69 views

Oracle SOA repository migration

Does anybody know whether it is possible to migrate Oracle SOA repository from a simple Oracle database to Oracle RAC?
1
vote
0answers
1k views

Oracle 11gR2 error while installing on RHEL6_x64

Whenever I attempt to install Oracle it gives me this error in the install wizard on the group configuration screen. I am using group oinstall and user oracle has also been created. INS-30060] Check ...
1
vote
2answers
101 views

Is it possible that I can change Port Number in Oracle 10g for remote connections

I am creating a project in Oracle Is it possible that I can change Port Number in Oracle 10g for remote connections ?
0
votes
1answer
574 views

Setup VirtualBox to see Oracle on a Local guest

I have a Ubuntu machine and I have a Linux instance running in a Virtual-box on this machine. I need to connect to the oracle instance (through the oracle extension in php) . The extension is running. ...
0
votes
1answer
371 views

Does DBMS_ALERT work correctly on an oracle RAC cluster?

Can anyone confirm whether the oracle DBMS_ALERT package works correctly in a RAC envirnoment. That is, if I have a DBMS_ALERT.WAITONE() on all instances, then I do a DBMS_ALERT.SIGNAL(), will all ...
2
votes
2answers
513 views

Is there a way to dump an Oracle db as SQL statements, à la pg_dump?

I'm very new to Oracle. It looks like all the Oracle DBA use binary only dumps. This sometimes cause problems, and seems rather useless to me (performance gain is bound to be negligible), but what do ...
1
vote
2answers
2k views

Oracle import fails due to NLS_DATE_LANGUAGE setting

I have an Oracle 10 database server and a dump created on another Oracle 10 server. When using the imp command to import the dump to the database: imp 'sys/*** as sysdba' file=c:\[...]\strukt.dmp ...
1
vote
1answer
755 views

Oracle on Solaris 10 : 15min TCP Timeout

I have Oracle10g running on Solaris 10. The configuration of the OS is standard, and there is a packet filter firewall running on the server. When I run a long query using sqldeveloper, the server ...
0
votes
1answer
431 views

Oracle EM detect a disk full, but the system has plenty of free space

My enterprise manager instance on Oracle 10.2.0.4 throws the following alert on a regular basis: Name=db4 Type=Host Host=db4 Metric=Disk Utilization (%) Disk Device=sd1 Timestamp=Oct 4, 2011 2:15:50 ...
1
vote
0answers
613 views

Intermittent java.sql.SQLException: ORA-03120: two-taskconversion routine: integer overflow exception

I get the following error intermittently when my spring app starts up. I am using oracle with dbcp pooling as my datasource bean in spring. Caused by: org.apache.commons.dbcp.SQLNestedException: ...
2
votes
1answer
335 views

What are the best practice for monitoring Oracle's rollback segment?

Occasionally, we run out of rollback segment space causing the query/update to fail. What are the best practices that I can expect from an Oracle DBA to ensure that this is monitored pro-actively and ...