Tagged Questions

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
1answer
75 views

Configuring Oracle 10g Express

I was wondering how to configure oralce 10g http service (http://127.0.0.1:8080/apex) to listen on some other interfaces (like http://192.168.50.128:8080/apex)?
3
votes
3answers
9k views

where is my Oracle database located on my hard disk?

I used to have a oracle installed on my old pc, i had a database on it ,, but currently what i have is only the hard disk of my old pc, dose anyone can help me how can i find my database on that hard ...
0
votes
2answers
222 views

Oracle backup and recovery

During recovery Oracle writes the following error: RMAN-06054: media recovery requesting unknown log: thread 1 seq 9 lowscn 4034762 I have used in mount mode this command: change archivelog all ...
2
votes
2answers
15k views

Setup Oracle instant client on CentOS/RHEL Linux - for PHP and Perl

I'm trying to setup a CentOS 5.5/64 bit VM to access a remote Oracle database with PHP and Perl scripts. (I have no experience with Oracle, have only programmed and administrated some PostgreSQl and ...
0
votes
1answer
2k views

How can I turn of redo logging on a materialized view refresh?

10gR2 Database, in Data Guard configuration to both a physical and logical standby. I have a materialized view that does a complete refresh periodically of about 40K records from a remote database. ...
0
votes
1answer
1k views

Can I create an oracle ODBC driver without installing the Oracle Client?

recently I got a task to migrate the back end of an access database to oracle (the front end should still remain in access), I need an odbc connection for that and on the PC I am working on I don't ...
0
votes
1answer
1k views

Orcale 11g client installs error on 64 bit win server 2008 OS

Checking operating system requirements ... Expected result: One of 5.0,5.1,5.2,6.0 Actual Result: 6.1 Check complete. The overall result of this check is: Failed <<<< Problem: Oracle ...
0
votes
1answer
532 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, ...
1
vote
1answer
294 views

Oracle 10g cannot see any data in tables

Im getting this error in Oracle 10g log file 2010-11-12 16:07:41.838: [ OCROSD][3069777600]utgdv:2:ocr loc file cannot be opened 2010-11-12 16:07:41.865: [ OCROSD][3069777600]utopen:1: Couldnt ...
2
votes
1answer
505 views

Oracle 11g installation on Remote Server(OS:Ubuntu)

Please let me clear steps to install oracle 11g from local linux(or windows) machine to remote server( OS : Ubuntu). When I try to run the runInstaller command,its not working from windows local ...
1
vote
1answer
1k views

After applying archive log in oracle, what time is it now?

I have restored the database and applied the archive log. How can I tell the latest transaction timestamp I have recovered to? This is oracle 10g R2 standard (no flashback enable)
2
votes
4answers
1k views

How to temporariliy disable access to Oracle database?

I would like to be able to temporarily disable all access to an Oracle database, except my own, to be able to perform maintenance actions without interruptions. Simplest way?
3
votes
2answers
9k views

How do I find out which tnsnames.ora file is being used by my linux system?

When I do an updatedb and locate tnsnames.ora I get back a long list due to various Oracle DB installations. I need to add some entries to whichever is the "default" tnsnames.ora configured for the ...
0
votes
2answers
914 views

Convert an Oracle 10g RAC database to single instance

In an attempt to reduce the complexity of a solution, I've been asked to convert a two node Oracle 10g RAC production database to single instance. The database is running on RHEL5 with ASM on SAN. I ...
0
votes
1answer
90 views

Oracle style programming in postgresql

I want to know if oracle style object oriented programming is possible in postgresql 8.4. I have installed orafce. When I tried to create a object like so: CREATE TYPE addr_obj_typ AS OBJECT ( ...
0
votes
1answer
66 views

Oracle/DB2 compare

I need to find definitions or explanations (DB2 and Oracle) for: instance database connection authority authorization transaction log tablespace application agent lock lock timeout Do someone know ...
1
vote
2answers
67 views

oracle to ms sql server or database

can anyone tell me how to access to ms sql database from oracle from another computer? and i want to know which version of oracle should i use to do that?
0
votes
3answers
5k views

How to move Oracle database to another PC without restoring backup?

Take this scenario: Suppose the customer has no backup of Oracle 9i or 10g database. The customer wants to move the database from one PC to another. The other PC has a fresh installation of Oracle. ...
0
votes
2answers
946 views

Oracle 9.2 ORA-01122 problem with UNDOTBS01.DBF

Something went wrong with our backup. What I did shutting down db recover the backup restart db after that I got this error ORA-01122: Datenbank-Datei 2 bringt Fehler bei Verifizierungspruefung ...
1
vote
1answer
70 views

What DNSSec implementations are available, and have they been checked for padding Cryptographic Oracle vulnerabilities?

A cryptographic Oracle is where one can deduce the private key when a error condition is created. Considering the recent ASP.NET padding Oracle exploit, can anyone tell me if the DNSSec ...
0
votes
4answers
3k views

Can't run GUI while installing Oracle in Linux from a jar file

I'm trying to install an oracle product in Linux using a jar. When I run the command "java -jar installer.jar" using the root user, the installer's GUI shows up without problems. But if I try to run ...
1
vote
3answers
1k views

Non GUI installer version for oracle 11g

I am looking for a installer version which is entirely non GUI . since I have to install oracle 11g on a remote server(OS: Ubuntu). I am connected to remote server through ssh using putty.
0
votes
4answers
3k views

Installation of Oracle 11g on remote server(Ubuntu) connected using ssh

When I tried running installer of oracle using oracle user after remotely connected(using ssh), I am getting this error. [oracle@htrtret database]$ ./runInstaller Starting Oracle Universal ...
1
vote
2answers
4k views

Oracle 10g default username and password

I'm trying to import a database dump file into Oracle 10g. I'm very very new to Oracle. I've installed Oracle Server ok, but when I go to SQLPlus, I'm prompted for a username and password. I've ...
1
vote
1answer
3k views

oracle database move current server to another machine problem

these day i really stress because of oracle server, im quite new to oracle. i have one old windows 2003 server which installed oracle 10.2.0 version. and i want to full backup of this oracle then ...
1
vote
3answers
440 views

How to find out which version of Oracle is running?

I have an oracle database on a windows 2003 server which i can't start. How can i find out which version it is? EDIT: Some of the oldest files are from 2003 and I dunno know if it's the original ...
1
vote
1answer
613 views

How can I change NLS for an Oracle XE installed on Ubuntu 10.04?

I am trying to import a dump and I get the following message: Export file created by EXPORT:V10.02.01 via conventional path import done in US7ASCII character set and AL16UTF16 NCHAR character set ...
3
votes
1answer
668 views

Is there a way to easily run the same query in Toad against multiple Oracle database servers?

I have several servers hosting data for the same application, and I want to see the results of the same query from different servers.
1
vote
1answer
375 views

Solaris ufs forcedirectio

I have oracle database on a Solaris 9 box. Oracle datafiles are stored on the ufs filesystem mounted with forcedirectio. So I'm using now only Oracle Buffer Cache. question: is it good idea to ...
2
votes
2answers
3k views

Oracle: replacing tnsnames.ora with LDAP lookup?

How do I go about replacing client-side tnsnames.ora with an ldap query? I'm not interested in running Oracle LDAP, we have an existing LDAP infrastructure. I need: format of LDAP entry how client ...
3
votes
2answers
3k 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 ...
3
votes
1answer
2k views

installing oracle 11g in ubuntu 10.10

i'm trying to install oracle 11g database in my ubuntu 10.10, following this tutorial http://oracleabc.com/b/archives/167 but, at the step 11, the system asks for oracle password! which password is ...
1
vote
1answer
465 views

Oracle DB emulator

Don't now if its a right place to ask, so if not please give me a hint. I need some software that do can emulate how Oracle DB works with disks (NOT ORACLE WORKLOAD TOOL). I've already took a look at ...
3
votes
4answers
1k views

VMWare VCenter Server 4.1 & Oracle

We have VCenter Server 4.1 set up to use Oracle database (11r2 with the latest patches). Everything works fine except the vcenter server starts very slowly, at the startup time one of the oracle ...
0
votes
1answer
1k views

PL/SQL Plus script just gives me numbers

I have an PL/SQL Script that I'm trying to run from the command shell with SQLPLUS. However, whenever I go to run it, All I get back is a number and a cursor waiting for some input. When I hit enter, ...
0
votes
1answer
714 views

Oracle client installation on Windows 7

I installed Oracle 11g database on Windows XP(32-bit) and now I need help for installing Oracle client on Windows 7 (64-bit) If possible, can you explain me how to do this... step by step... starting ...
0
votes
1answer
145 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 ...
1
vote
4answers
420 views

why this statement in oracle perform much slower then ms sql

I tried to run a simple test to see how the speed fair between oracle and Ms Sql as follow: populate two tables with 2 million records, cross join them, filter by a range, and do a sum. Both table ...
1
vote
1answer
230 views

Oracle 8i - Error signaled in parallel query server

I am attempting to run a query against an Oracl 8i database instance running on Aix. It is a simple select * against a single table. The query runs for approximately 8 hours and then throws the ...
3
votes
2answers
699 views

How to handle one-way synchronization of two Oracle databases with no network connection?

Here's the situation: I have two Oracle 10g databases (with the same tables, etc.) that cannot be connected by network. At some regular intervals (say, once a day) I need to be able to update the ...
1
vote
1answer
523 views

High “user rollbacks” in v$sysstat - what does it mean?

There are some people on my team running performance tests against an Oracle database. During the execution of their scripts, they are seeing a large increase in the value of "user rollbacks" in the ...
0
votes
5answers
2k views

What is the Best HW / OS Combination for Oracle 11g?

My company is in the midst of upgrading our database hardware / software to support Oracle 11g. We're considering the following hardware / OS combinations for the database server: Sun v890 (current ...
2
votes
2answers
2k views

Executing Oracle SQLPlus in a Powershell Invoke-Command statement against a remote machine

We have a basic powershell script that attempts to execute SQLPlus.exe on a remote machine. The remote does not have Oracle Instant client installed, but we have bundled all the necesary dlls in a ...
1
vote
1answer
657 views

Oracle sysman password reset and enterprise manager

We are running oracle 10g.yesterday we had to reset sysman(and all other sys acounts)user with alter user command. Password change command worked by oracle enterprise manager does not see the database ...
0
votes
1answer
755 views

Examples of Exp tool to export data from Oracle db table to text file

I need to export data from an Oracle database and then import the data to another oracle database. To import data, I can use SQLLDR tool to load a flat text file. To do that, I have to generate this ...
0
votes
1answer
161 views

installing oracle on linux red hat 5

while installing oracle on linux red hat 5 its giving java.lang error how can i get rid of it?
3
votes
3answers
3k 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 ...
0
votes
3answers
17k views

how to imp whole database and replace current data?

I have two database, says A and B. They are same, expect the data records are newest or old. I want to exp from the newest one (A) and imp to the older one (B). when I import to the old one by the ...
2
votes
2answers
3k views

Install oracle 11gR2 on Centos 5 : No init file found

I'm trying to install oracle 11gR2 on Centos 5 and when I do a /etc/init.d/oracle start I get in the log : No init file found for Database instance "ORCL". Error database instance "ORCL" not ...
5
votes
5answers
4k views

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 ...