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.
3
votes
3answers
1k views
Oracle Instant Client installation woes - “HTTP proxy setting has incorrect value”
When I run sqlplus I get the following error:
#sqlplus
Error 46 initializing SQL*Plus
HTTP proxy setting has incorrect value
SP2-1502: The HTTP proxy server specified by http_proxy is not ...
1
vote
1answer
268 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 ...
11
votes
2answers
1k views
Best practices for settings for Oracle database creation
When installing an Oracle Database, what non-default settings would you normally apply (or consider applying) ?
I'm not after hardware dependent setting (eg memory allocation) or file locations, but ...
7
votes
11answers
1k views
Linux or Windows 2003 (64 bit) for hosting an Oracle database?
Copied from StackOverflow
Are there any overwhelming reasons to pick one over the other?
I'm in the middle. Our database administrator says that Oracle on Linux is better, but cannot present proof. ...
0
votes
1answer
1k views
Oracle on NFS vmdk beats native NFS?
my colleagues are pursuing this with Netapp and Oracle - but I thought I'd post here on the off chance someone else has seen this
We have a RedHat 5 VM (fully up to date) running Oracle 11i with data ...
2
votes
1answer
469 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 ...
-3
votes
1answer
76 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?
1
vote
1answer
716 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
3answers
110 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) ...
2
votes
3answers
5k 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.
...
0
votes
3answers
934 views
Migrating from Oracle to Netezza and trying to see what datatype differences there are
I am going to be working on a migration of Oracle DW to Netezza, and I need to understand if there are any major "gotchas" with data types, etc.
0
votes
2answers
4k 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 ...
2
votes
2answers
8k views
Oracle throwing this error: could not open registry key SOFTWARE\Oracle\ocr
I have an oracle installation that runs fine 95% percent of the time. But for some reason every day at a random time early in the morning (between 4:00am and 9:00am) I get the following error:
[ ...
1
vote
1answer
169 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 ...
2
votes
2answers
415 views
Oracle: 32bit vs. 64bit with respect to memory usage
To help us decide whether to install a 32bit or 64bit flavour of Oracle, I need to find out the advantages and disadvantages of the two choices. Yes, I do know that the 32bit option restricts us to ...
5
votes
1answer
120 views
How to prevent remote login for SYS
Is it possible to prevent the remote logins for the SYS user? Oracle 10g.
0
votes
1answer
259 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
2answers
1k 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
821 views
Large amount of cursors causing slow response and massive CPU usage - cursor: mutex s
We have a problem with our Oracle server. It was upgraded to 11g a couple of months ago and is running a third-party system. The system has been running for years (and has had several other issues), ...
0
votes
1answer
836 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
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 ...
15
votes
2answers
34k views
How do I turn off Oracle password expiration?
I'm using Oracle for development on my local machine. The password for a bootstrap account that I always use to rebuild my database has expired.
How do I turn off password expiration for this user ...
0
votes
2answers
736 views
Microsoft Cluster or Oracle Fail Safe error
Trying to get Oracle Database 10g to work on Microsoft cluster (using Oracle Fail Safe, not RAC). Everything installed, but when trying to verify group or add database to group I get following error:
...
0
votes
1answer
154 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
75 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. ...
3
votes
2answers
205 views
Oracle RAC failover backup procedure
We have Oracle 11gR2 RAC database on two nodes. We also have a RMAN backup script that works fine, using a recovery catalog database
which is located in a town 20km from the data center. The script ...
0
votes
1answer
334 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 ...
1
vote
0answers
146 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 ...
1
vote
1answer
1k 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 ...
0
votes
2answers
94 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), ...
2
votes
2answers
2k 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 ...
2
votes
1answer
478 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
131 views
Oracle Unbreakable Enterprise Kernel compatible with CentOS?
I'm installing Oracle 11.2. Anyone know if Oracle Unbreakable Enterprise Kernel ...
(1) is required to be installed for CentOS 5.5?
(2) may optionally be installed on CentOS 5.5?
I'm following the ...
3
votes
6answers
462 views
How to achieve zero down time
For an application we want to achieve zero database and application down time using Active Active configuration. Our dB is Oracle
Following are my questions:
How can we achieve active active ...
0
votes
1answer
148 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 ...
5
votes
5answers
43k views
How can I start Oracle Enterprise manager after restarting the Red Hat Server?
I installed Oracle 11g on Red Hat Enterprise server 5.0. First time everything worked well.
After creating dbora script file in /etc/init.d/ and setting all the oracle environmental variables I just ...
-3
votes
1answer
228 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)
0
votes
3answers
160 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 ...
2
votes
2answers
217 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 ...
3
votes
3answers
743 views
Authenticating AIX Users Against OID (Oracle Internet Directory)
We have a need to authenticate local users on an AIX server against OID using LDAP. We have a branch within OID where we've placed and synchronized Active Directory users. We've also configured ...
1
vote
2answers
91 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 ?
1
vote
0answers
604 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 ...
3
votes
2answers
2k views
Oracle 11g R2 Install Guide
I have a need to install Oracle 11g R2 on Windows Server 2008 R2. I have downloaded the two files from Oracle (win64_11gR2_database) and the client (win64_11gR2_client). Does anyone have a guide or ...
5
votes
4answers
2k 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 ...
0
votes
1answer
182 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
187 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 ...
1
vote
1answer
301 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
241 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
1answer
51 views
iSCSI and WAL for database (oracle 11g) performance
I am thinking about building a database system with iSCSI. But now I am thinking about the WAL. WAL shouldn't lag.
WAL is implemented with a ring buffer, isn't it? So if I only care about the ...
2
votes
1answer
143 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 ...
