The oracle tag has no wiki summary.
0
votes
0answers
15 views
Hanging between Oracle client and Shadow Process
We are having an occasional (ie non-reproducible) issue where the Oracle client process (EnterpriseOne kernel process) and the Oracle shadow process seem to get out of sync. I perform a stack dump of ...
2
votes
0answers
87 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 ...
-2
votes
1answer
36 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?
0
votes
0answers
28 views
TNS-12532: TNS:invalid argument
I am trying to set up an Oracle 11g database server on windows 2008 R2. The server runs in VMWare Player which runs on Windows 7 Enterprise edition. The host and virtual pcs are connected with a ...
2
votes
1answer
38 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
37 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) ...
0
votes
0answers
27 views
Oracle 11g production database copy to USB drive [migrated]
What is the correct commands for backing up a production Oracle 11g database (while still running) to an external USB drive or different directory.
I am new to Oracle and but have experience with SQL ...
0
votes
2answers
59 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
0answers
67 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
17 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
44 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 ...
0
votes
1answer
46 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 ...
0
votes
0answers
47 views
Java JSP project not getting deployed properly on tomcat , Broken Pipe error reported
Tomcat Version: 5.5
Database: Oracle 10g
Server OS: Linux
I am trying to deploy one of my JAVA/JSP web projects on Tomcat 5.5 server, the project is not getting deployed properly the Java(Sevlets, ...
1
vote
1answer
170 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 ...
0
votes
0answers
273 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
0answers
22 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
99 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
47 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 ...
-1
votes
1answer
36 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
0answers
35 views
Oracle Streams ORA-26787
I have two DB with configured Oracle Streams:
1. Oracle DB 10.2.0.4 EE RAC (local capture, propagation queue to queue, DML and DDL captured). FORCE LOGGING enable.
2. Oracle DB 11.2.0.2 SE RAC ...
0
votes
1answer
44 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
0answers
44 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
70 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
69 views
how many servers and in what configuration for web application by small company?
My question is from a startup company providing a web application for the first time. It consists of an Oracle database (11G), an Apache web server, and a small Java middle tier, connecting to a ...
1
vote
1answer
59 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 ...
1
vote
2answers
155 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 ...
-1
votes
1answer
46 views
Installation of Oracle 10.2.0.4 in windows server 2003
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
55 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
162 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
0answers
147 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
46 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 ...
1
vote
0answers
24 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?
Thanks
1
vote
0answers
119 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 ...
0
votes
2answers
61 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
35 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
64 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
114 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
73 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
97 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
63 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 ...
0
votes
0answers
23 views
Bridge issue communication Oracle VM on ESX
I am trying to install Oracle VM Server 2.2 on and ESX VM host. The installationw as OK. But when I created the server pool and later the 2 virtual nodes to install Oracle RAC, I could not able to ...
1
vote
0answers
133 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
44 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 ...
5
votes
4answers
353 views
Why “Begin Transaction” before “Insert Query” locks the entire table?
I wrote a stored procedure to insert a record. I added "Begin Transaction" just above the Insert Query and execute the query. I noticed that another application that was showing a web page with ...
2
votes
3answers
220 views
How do I make imp use right charachter set?
I am trying to import a dmp file from one database to another. The problem is that some special danish characters are not imported right because some character map conversion is done during import.
...
32
votes
7answers
1k views
Database server: Small quick RAM or large slow RAM?
We are currently designing our new database servers, and have come up with a trade off I'm not entirely sure of how to answer.
These are our options: 48GB 1333MHz, or 96GB 1066MHz.
My thinking is ...
1
vote
0answers
30 views
Oracle SGD 4.61.915 not closing Windows 2003 application sessions
I'm using a Windows 2003 Application Server and I have followed this article: http://download.oracle.com/docs/cd/E19351-01/821-1926/z40000df1311155.html#bbjiefec but still.. when i close a application ...
1
vote
0answers
22 views
OracleXEService is not installed
I've downloaded Oracle 11g release 2 express edition. I want to install Oracle on my computer in order to prepare for an Oracle certificate exam. The installation goes normally, it askes me to ...
2
votes
1answer
54 views
Oracle Backup Strategy
I have recently inherited a smallish Oracle database running on a SPARC Solaris 10 Server. I have been asked to implement a sensible backup strategy. The database has about 3000 odd tables and is ...
2
votes
1answer
41 views
How can I tell how my oracle databases configurations' differ?
I have two databases with the same data, running on the same physical server.
They are performing differently (one is twice as fast as the other).
I've compared the Initialization Parameters and ...
