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

0
votes
3answers
352 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
2answers
296 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 ...
2
votes
2answers
75 views

Linux OEL 6x - Compatibility with ACL

Will the ACL [ Access control lists like getfacl, setfacl ] utility work fine with OEL 6x? It works great with Solaris 5.9 but not sure OEL 6x will support ACL utilities
1
vote
2answers
764 views

Oracle: Getting ORA-01195 and ORA-01110 when attempting resetlogs

I am trying to get our database to startup. When I login to sqlplus and do a startup, I get the message: Total System Global Area 534462464 bytes Fixed Size 2215064 bytes Variable ...
0
votes
2answers
218 views

Oracle Advanced Security Options is Blank

I just installed Oracle DB 10gR2 with Oracle Advanced Security, but cannot see the algorithms. [user@db-1] adapters Installed Oracle Net transport protocols are: IPC BEQ ...
0
votes
2answers
488 views

Importing oracle dump file, getting error on stored procedures

I export an oracle "schema" using exp userid=/ file=pt.dmp log=pt.log owner=FOO buffer=10000000 statistics=NONE direct=Y and then import it into a different schema on the same oracle instance on ...
0
votes
1answer
182 views

Does Oracle DB has a tool like DTS Wizard in SQL Server?

Is there a tool like the Microsoft SQL Server's DTS (Data Transformation Services) Wizard that simplifies the process of ad-hoc importing of flat files (CSV, TSV, or XLS) to Oracle database? ...
0
votes
1answer
540 views

problem in run oracle server please help

I used Oracle 11g, from few days ago I face below error: SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 7 07:33:19 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: ...
0
votes
1answer
309 views

Switch RAC nodes using dbconsole in Oracle 11g

Is it possible to use dbconsole (Enterprise Manager) to switch the active node of a Oracle 11gR2 cluster? The idea is to tell the active instance to go down and have another node take over. I want to ...
0
votes
1answer
207 views

CPU/ memory utilization

WE have a job running very slowly. And I required to produce the analysis of CPU/ memory utilization during that backup.Also need statustics around the database performance for that batch job. How to ...
0
votes
1answer
72 views

Is Oracle Smartscan really effective?

Oracle is marketing Exadata to our company, and they're focusing on Smartscan, which is, advertised 10x more effective than traditional solution. I don't really understand (and somewhat don't really ...
0
votes
1answer
512 views

Unable to start Oracle Enterprise Manager

Had some passwords expire, and this knocked out my OEM (11g, SE). Cleared this up, so that SYSMAN is not locked or expired (nor is DBSNMP, SYS, SYSTEM, all of which may or may not affect OEM, ...
0
votes
1answer
142 views

Oracle server for reporting services?

Can anybody let me know what is "Oracle Reports 11g Release 1?" Is this a server apart from Oracle Database server or this can be installed in the Oracle Database server itself? I am looking for a ...
0
votes
1answer
385 views

How to set _optimizer_search_limit and _optimizer_max_permutations in Oracle10g

I am working on a product that must support both MSSQL and Oracle (10g and 11g). I have some very complex queries that seem to run without issue on MSSQL 2005/2008, but very, very slow with Oracle. ...
0
votes
1answer
38 views

mass deploy Oracle patches with OEM with different OS's

I have not been able to get this to work. We are running our OEM grid control database/oms on Red Hat 5(32 bit), but our databases are on Solaris x86-64. I could not mass deploy agents since the ...
0
votes
1answer
619 views

What guidance for page file size and other system parameters for Oracle running on Windows Server 2008

Slightly open ended question, but what are guidelines for configuring windows server 2008 running Oracle? For example, should the paging file be kept small (1gb) if I've got 32gb of RAM in the ...
0
votes
1answer
529 views

Oracle on windows cluster with online/offline IPs

I have a windows cluster (on windows 2008 server) with nodes in different subnets. So cluster has two IPs, one for each node (I'm talking not about node IP, but about cluster IP). One is online, the ...