Oracle is an RDBMS product and Oracle 11g is a specific version. Questions tagged **oracle11g** are assumed to be specific to this version or features introduced in this version.

learn more… | top users | synonyms

1
vote
1answer
662 views

Problems with connecting to ASM instance

I have Oracle11 with RAC installed on RedHat 5. I have two servers with two instances one on each one. In each server I succeed connect to appropriate instance of database but not to instance of ASM. ...
2
votes
2answers
5k views

Fixed expired accounts in Oracle 11g

I have an Oracle 11g server that's used for PHP development. Recently, I had a problem logging into the Enterprise Manager due to expired passwords. I've already changed settings so passwords no ...
1
vote
3answers
14k views

Cannot log into Oracle Enterprise Manager 11g: ORA-28001

I can no longer log into Oracle Enterprise Manager 11g. I get this error message: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin) I could log into the server using SQL*Plus. I ...
0
votes
2answers
6k views

Oracle 11gR2: NLS_CHARACTERSET accidentally removed with an UPDATE-Query

I have a fresh installation of Oracle 11gr2_x64 on CentOS. After the installation I wanted to get productive and started to import my dumps. One of the dumps caused characterset error so I tried to ...
2
votes
1answer
579 views

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 ...
0
votes
1answer
418 views

Oracle 11g RDBMS Enterprise Edition download?

I am looking for a URL where i can download the Enterprise Edition of Oracle 11g. I know that i can download the Standard Edition of 11g at Oracle's technet, but as i would like to use some of those ...
2
votes
1answer
133 views

What is the correct way to back up an Oracle 11g database with 190GB of data

Right now we are doing the following: Generating a DMP file to a windows server, this takes about 14hrs Copy the DMP file to tape, this takes about 10 hrs Archive it..... In total this takes about ...
1
vote
1answer
769 views

Oracle OLE DB provider for Windows Server 2008 R2

I have installed 11G Oracle OLE db provider on Windows Server 2008 Release 2. I can find it in the registry but I can't see it in "create a new ODBC connections" wizard. Any help please? Regards
1
vote
1answer
2k views

Standard Oracle Fusion Middleware Installation fails on SOA ManagedServer start due to classpath problems

Trying to install Oracle Fusion Middleware 11gR2 on windows (same thing happens on Linux). I have followed the guidelines provided in the ...
1
vote
2answers
20k views

Can't start managed server in Oracle Weblogic 10.3.2

I installed Oracle SOA Suite 11g. I start the NodeManager successfully. I start the AdminServer successfully. When I go to start the soa serve (soa_server1) I get this output: NMProcess: <Mar ...
2
votes
1answer
620 views

When Installing Oracle Client 11.1.0.7 can I use a common directory for Oracle Base?

I am trying to install Oracle Client 11.1.0.7 on a Windows Server 2008 64-bit. To some this might not be rocket science but I can't understand what the options under the install screen "Specify Home ...
1
vote
1answer
170 views

Oracle Ordcom and Wallet Coexistence Problem

We use Oracle's ORDCOM infrastructure on our 11.1.0.7 database to interact with a COM object. The COM object doesn't do anything with the database. This process has been working fine for several ...
1
vote
2answers
21k views

Create user in Oracle 11g with same priviledges as in Oracle 10g XE

I'm a PHP developer (not a DBA) and I've been working with Oracle 10g XE for a while. I'm used to XE's simplified user management: Go to Administration/ Users/ Create user Assign user name and ...
0
votes
1answer
207 views

Oracle with Terminal Services

We have a Windows Server 2008 that is running Oracle 11g. The server was configured for terminal services for administration. This only allowed 2 people to remote to the server at a time. Today I ...
0
votes
2answers
539 views

Why doesn't my oracle asm disks show up under dbca?

I am running into a problem where I have created some ASM disks under linux, they show up when I run oracleasm listdisks, but they are invisible when I use dbca and try to Configure Automatic Storage ...
1
vote
4answers
6k views

Running Oracle 10g and 11g side-by-side

I recently tried installing Oracle 11g on a server already running 10g. Each would run independently with no problem, but 10g refused to run simultaneously with 11g. Can this be done? I don't need a ...
1
vote
2answers
1k views

How to fix corrupt indexes blocks in SYSAUX tablespace

we had power failure that left corruption in data files. It was recovered from RMAN backup including logs and all is OK, the DB is working.. except that I noticed this: RMAN> BACKUP VALIDATE CHECK ...
1
vote
1answer
3k views

Oracle Embedded LDAP Error

I just installed the Oracle Weblogic Server. The server start fines and I can get to the admin console and use it, but once I deploy the console I begin to get exceptions on the server and it pegs the ...
4
votes
5answers
3k views

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 ...
2
votes
1answer
869 views

Oracle: Can Weblogic 11G run PL/SQL code like App Server 10G?

This is probably a silly question, but I'm not an oracle admin so I'm not sure. Our client currently runs a website written in PL/SQL and HTML on a Oracle 10G system. As everything is moving in the ...
1
vote
1answer
1k views

Rolling Upgrade of Oracle 11g from 32 bit to 64 bit?

I have an Oracle 11.1.0.7 database running on windows 32 bit. I would like to upgrade to 64 bit (same version of oracle) and would like to use a standby database for a rolling upgrade. Is this ...
0
votes
2answers
821 views

How do i verify Oracle 11g standby database is updating

We have recently set up a DR site for our Oracle 11g database server at a remote location as a standby database. How do I verify that the archive logs are being applied to the standby database and ...
1
vote
3answers
4k views

Oracle 11g server rename issue

So we set up an Oracle server out of production (11g on Server 2008 x64) and our plan was to just rename the server's hostname to move it into production. Well, the database itself is functioning but ...
2
votes
1answer
2k views

prevent ORA-28001?

Using Oracle 11g, is there a way to prevent my user's passwords from needing to be updated (ORA-28001)?
1
vote
2answers
9k views

Disconnecting an Oracle Session from a Logon Trigger

I'm trying to construct an Oracle 11g logon trigger that restricts access for a specific user to a known list of applications. For example, user SCOTT can only connect with MYAPP.EXE. I believe I ...
0
votes
1answer
130 views

SQL Area Unexpected Expansion

We are using Automatic Memory Management on Oracle 11.1.0.7. Last week Friday the Shared Pool unexpectedly increased from ~600MB to ~850MB. The memory came from the buffer cache which went from ~400 ...
1
vote
3answers
11k views

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 ...
2
votes
3answers
266 views

Move Data on Oracle 11g

I am doing migration to move data from Ms SQL Server 2000 to Oracle 11g on HP Server machine. I don't know why it is very slow when I load data from file xxx.dat into table in oracle 11g. Do anyone ...
3
votes
3answers
18k views

How can I uninstall Oracle 11g from Windows?

When I try to uninstall Oracle 11g from Windows, I get the following error message: Checking swap space: 0 MB available, 500 MB required. How can I fix this to completely uninstall Oracle 11g?
1
vote
10answers
4k views

What is the best OS platform for Oracle 10g?

I want to know the best choices for OS to run Oracle 11g on my sand box. Also, I would like to know good combination for Dev environments in 50-100 user environments. Any other information about ...
1
vote
1answer
201 views

Data Guard Oracle 11g

I want to do the disaster recovery in oracle 11g using data guard. But I don't the procedure or the way how to do it. I want all of someone that show me the document or the way to do it. Can anyone ...
0
votes
3answers
910 views

Converting an Oracle 11g Database from 32bits to 64bits

I have moved a database from a 32bit version of Oracle 11g under Linux to a 64 bit environment. However, i have experienced problems in the new Environment (also Linux). Is there any method of ...
2
votes
1answer
3k views

Oracle 11g silent install on Linux CentOS 5.2 x86-32 fails on database creation

After reading the Linux installation guide for Oracle 11g, taking particular note of the pre-installation requirements; I have been able to record a response file for a silent installation based off a ...
1
vote
2answers
1k views

Oracle DBV File Parameter

For our 10g Oracle database I had a script that would periodically create batch files to run DBVerify on all our datafiles. This way if I needed to check for corruption I would just have to run the ...
2
votes
1answer
133 views

Restore and Recovery scenario

I want to restore and recover my oracle database to the current state. For example, I have a full backup on Sunday and I have all archive logs from Sunday to Wednesday. If I restore and recover from ...
0
votes
5answers
3k views

archive log backups in oracle

I am a SQL Server DBA and recently been given responsibility for an Oracle environment. (11g) Now i do timed backups of my transaction logs on SQL Server and then migrate them to a different server. ...
0
votes
2answers
966 views

What is TIRHService.exe?

What is this process? It on a fresh install of Windows Server 2008 with an Oracle 11g database installed on it. The process is in c:\windows\ and according to Sophos Anti-virus it is trying to ...
0
votes
2answers
228 views

Oracle disaster recovery on Linux

My Oracle database is stored on a Linux system. That Linux system is down. So I want to restore my Oracle database as soon as I set up the Linux system. I don't know how to restore it. Can anyone help ...