Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [oracle-11g]

Oracle is an RDBMS product and Oracle 11g is a specific version.

169 questions
13
votes
5 answers

Installing Oracle 32bit and 64bit client on the same machine

So I need to have both the 32bit and 64bit clients for Oracle 11g coexist on the same machine. I have installed both together before, but there are many issues where applications that need to use the 32bit client seem to reference the 64bit client…
Brandon
  • 133
  • 1
  • 1
  • 6
8
votes
4 answers

How to restore/import an Oracle database from dmp file?

I've recently received the dump file of the soon to be migrated Oracle Database. I've installed Oracle 10g and now I need to restore the original database. Can anyone give me a step by step procedure for how to restore it from the *.dmp file ?
Paul
  • 714
  • 2
  • 6
  • 19
7
votes
5 answers

Are there any disadvantages of using UTF8 in an oracle database?

We are installing ordering a configured oracle database and they are asking us what character encoding we would like to have. The application (in Java) is in English only but users are from different parts of the world. Are there any motivations…
user22463
7
votes
5 answers

Oracle database is very slow - Where to start and how to find the cause?

Our Oracle database(11g) is very slow all of a sudden. I donno where to start the debugging process to find what actually is the problem? I tried generating table stats and looked for locks..but i can't find any information that points me directly…
sam
6
votes
5 answers

How do I know to which node of my Oracle RAC I am connected?

Is there an easy way to determine to which RAC node of an Oracle 11g R2 system I am connected? I am trying to perform some failover tests and I want to make sure my application is correctly connected to one node and upon the shutdown of this node…
Stephan
  • 417
  • 1
  • 5
  • 13
5
votes
4 answers

Can I run an Oracle server without swap?

Official Oracle docs say that for a machine with more than 16GiB of RAM we need to allocate 16GiB of swap. Our servers are RHEL 7 and have 256GiB of RAM. DBAs do not want to see the system swap, so they want us to monitor the 16GiB of swap very…
chutz
  • 7,888
  • 1
  • 29
  • 59
5
votes
3 answers

Initialization error while trying to connect to Oracle using SQLDeveloper

I've installed Oracle 11.2.0 and Allround Automations' SQLDeveloper on Windows 7 64-bit. When I run SQLDeveloper and and try to connect to Oracle, I get the below error: Initialization error Could not load…
Gali
5
votes
5 answers

Setting up array of SSDs for Oracle Database, recommendations?

I am configuring a server for a small, but read I/O intensive database. It serves as a master index for public access to a larger Oracle RAC database. When looking at the requirements for I/O, it was determined that an array of SSDs would provide…
John
  • 93
  • 1
  • 7
5
votes
1 answer

Apache apachectl/httpd hangs

Oracle HTTP Server (OHS), RHEL 5.3, Dell hardware Oracle has a modified version of Apache2 for use with web-enabled components in its product suite. The apachectl start command just hangs, even configtest hangs! Not sure what it is waiting for. How…
partlycloudy
  • 205
  • 3
  • 8
4
votes
0 answers

mod_ssl client certificates on a reverse proxy

I am trying to add client certificate authentication on a reverse proxy that proxies an oracle application. Before adding, and if i remove the subsequent code, the oracle application is able to start java, load, and function properly. When I add the…
Rory McDonald
  • 61
  • 3
4
votes
3 answers

Granting Read-Only access to an existing Oracle Schema

we've got an Oracle 11g Schema that our application uses to select, insert and update, but we've had a request from one of our customers to provide read-only access to the same base tables and views owned by the application. Other than synonym'ing…
Andrew
  • 185
  • 2
  • 3
  • 10
4
votes
3 answers

When RAID 10 is SLOWER than RAID 1, why?

We have a new Dell 2950 with PERC 6/e and 14 external SAS 15K 73GB drives. An Oracle 11g database job takes 3 hours to run with the drives set as hardware RAID 10 (striped across 7 mirrored pairs). The database size is about 26GB. The same job…
Paul
  • 779
  • 1
  • 9
  • 18
3
votes
1 answer

What better way to configure memory for an Oracle RAC 11g R2?

I'm setting up a new environment in Oracle RAC 11g but I'm wondering how best to use the memory feature. Today I have two servers with 128GB of RAM 1 core CPU with 16 cores. I deployed 64GB of SSD to Swap, as much as possible to be able to install…
Bruno Farias
  • 31
  • 2
3
votes
1 answer

zpool disappears whenever solaris cluster reboot or power cycle

I have following setup Oracle Solaris 10 -> 5.10 Generic_147147-26 sun4v sparc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit production Oracle Solaris Cluster 3.3u2 for Solaris 10 sparc Oracle Solaris Cluster Geographic Edition…
Halit Sakca
  • 61
  • 6
3
votes
2 answers

prevent ORA-28001?

Using Oracle 11g, is there a way to prevent my user's passwords from needing to be updated (ORA-28001)?
user13859
1
2 3
…
11 12