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

2
votes
1answer
4k views

Installing SSL Support in Weblogic 10

I have some troubles installing my SSL Certificate into Weblogic 10, here are my configuration steps: Copied the .cert and .key to the server Executed the following: []# keytool -import -keystore ...
2
votes
1answer
335 views

OS Authentication

I'm currently using Oracle 11g on RHEL 5. I want to disable OS authentication administration on my database because of the security issue. When OS admin user login to OS, and they issue "sqlplus /", ...
2
votes
0answers
210 views

doing ODBC System DSN's from Active Directory

2008R2 Active Directory, workstations are Win7 Ent, Office/Excel 2013, Oracle 11.2. Excel fetches data from Oracle using System DSN's. Where can I put ODBC System DSN's in Active Directory? Do I ...
2
votes
0answers
51 views

Alternatives to oracle flashback database/table functionality

Does anyone know of an open source tool or similar that covers the same functionality as the Oracle EE built-in flashback database and flashback table features? I'm considering going from Oracle EE ...
2
votes
0answers
130 views

MICR check printing through Linux (EBS)

We are currently working to get a new MICR check printer (Troy Micr - HP Laserjet 600 M601) printing correctly with Oracle EBS. Our EBS installation runs on Oracle Enterprise Linux (Redhat Based). The ...
2
votes
0answers
220 views

Dtrace Oracle show high fsflush on solaris 10

Solaris 10 - Oracle 11G in a zone Running mpstat , i've noticed that one CPU was at 100% used every 5 seconds for 5 seconds while all other CPU were fine, in used but nicely spread. 1 0 0 0 ...
2
votes
1answer
237 views

How to configure multipath using Intel X520-SR2 10GB on Oracle Linux 6.2?

I've installed the Intel x520-sr2 Ethernet/Fibre card into a server that has Oracle Linux 6.2 Installed on it. When I boot the server I can go into a QLogic menu (screen has something for Intel on ...
2
votes
2answers
84 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
2
votes
1answer
372 views

Cant open up oracle web console after install db 11gr2 and show weird symbols?

i just finished installing oracle database 11gR2. after successful install, i will usually want to open up web console at http://localhost:1158/em.. however if i open up the page i get a weird symbol ...
2
votes
1answer
3k views

logfile deleted on Oracle database how to re-create it?

For my database assignment we were looking into 'database corruption' and I was asked to delete the second redo log file which I have done with the command: rm log02a.rdo this was in the ...
2
votes
0answers
221 views

Oracle concurrent programming execution methods

I created a package and a stored procedure under it to test a concurrent program. When I run it as an Oracle report executable method it works fine. But when I change it to PL/SQL stored procedure ...
2
votes
0answers
50 views

Equivalent of SQL Server trace for Oracle 10g?

I've got a bad code duplication problem where we cannot tell which versions of packages/procedures are being used. i.e. I have different packages with procedures of the same name and I need to be ...
2
votes
1answer
2k views

what is causing oracle archive log files to be growing fast

in the last few days our Oracle DB has been generating a large amount of archive log files. How would I find out what DML activity has been causing such a spike in log file generation?
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 ...
2
votes
1answer
10k views

SQL, pl/sql, sqlplus: how to return a variable to DOS batch file?

I have a DOS batch file which invokes sqlplus, which executes some basic SQL contained in another .sql file, and I want the last part of it to return a value back to the dos batch file. However, ...
2
votes
2answers
366 views

Unknown user name or bad password

I have 2 application hosted on server A which connects to the database server B. For every few seconds, there is this error log in the event viewer of the database sever. Both window services ...
2
votes
1answer
3k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
1
vote
10answers
5k 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
6answers
182 views

What DBMS' have tight integration with a dedicated OS'?

It has always been my strong conviction that a large-scale multi-user DBMS should reside, stand-alone, on a dedicated server or clusters, with no other unecessary apps, processes or services which ...
1
vote
4answers
2k views

How do I change a user's password in Oracle?

How do I change a user's password in Oracle?
1
vote
3answers
15k 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 ...
1
vote
4answers
152 views

Can anyone recommend a text messaging service for sending alerts and notices from an Oracle database on Linux? [closed]

We're investigating ways to alert users of application errors out-of-hours. Has anyone used a Linux-based text messaging (phone) service for sending out alerts?
1
vote
1answer
900 views

Root SSH login works, but su/sudo to root does not work

Im recently working on a clients box, and SSH into the box with root credentials work but when i try to su or sudo to root user it states incorrect password. I tried changed the root password and know ...
1
vote
4answers
103 views

Database security

What aspects should be considered in order to have a secure database? Along with avoiding sqlInjection, what else should be considered? What should not be done?
1
vote
8answers
11k views

Oracle 11gR2 exp does not export some tables

I have an Oracle 11g (11.2.0.1) Database running on Linux (x64). Within the database I have a schema and 33 tables for it (all in the same tablespace). When I log in via sqlplus I can list all the ...
1
vote
3answers
23k views

How do I fix “ORA-01033: ORACLE initialization or shutdown in progress” error?

I have an Oracle 9.2 database. The server has crashed. After rebooting any attempt to connect to the Oracle server returns error ORA-01033 (as in title). I've tried stopping and starting the Oracle ...
1
vote
2answers
201 views

What knowledge should Oracle DBAs and sysadmins share?

http://serverfault.com/questions/20248/what-would-make-working-with-dbas-easier already touched on the question of interaction between DBAs and sysadmins. The answers focused on personal interaction ...
1
vote
2answers
1k views

how does odbc driver work?

I have an application hosted on jboss. use jdbc driver of oracle to connect to an oracle 10.2g database. Can anyone guide as to what happens when a session is established. Just trying to understand ...
1
vote
1answer
3k views

Oracle temp file TEMP01.DBF taking up too much space

Can I delete this file or recreate it with a size limit? Thanks.
1
vote
3answers
345 views

Oracle DB Deadlocks

We have a situation where a db is "slowing down". DB operations that normally take a second or two are taking ten times as long. There appear to be a large number of locks in the DB when this is ...
1
vote
3answers
5k views

Oracle export failed: EXP-00006: internal inconsistency error

My call to Oracle's exp is failing with: EXP-00006: internal inconsistency error EXP-00000: Export terminated unsuccessfully The command I execute is C:\oracle\product\11.1.0\db_1\BIN\exp ...
1
vote
4answers
2k views

Infiniband for Oracle 11g RAC private interconnect?

We currently have a 2-node Oracle 11g RAC using 1GigE as the private interconnect. At peak update time, the traffic between nodes reaches 35 MByte/second, so we are still doing good in terms of ...
1
vote
7answers
485 views

Scripting Oracle tasks in Linux

I am more familiar with Windows so Linux is a rather strange place for me at present, so please exuse me if this is a dumb question. Basically, i would like to know if anyone has any suggestions ...
1
vote
2answers
3k views

Best practices for SQL Server to Oracle data synchronization

I have some tables in a SQL Server database that I want to make available to an Oracle database. Keeping in mind that data integrity is the top priority, what are some best practices for keeping the ...
1
vote
1answer
2k views

How to use Oracle Installation Prerequisites on Redhat Linux 6.5?

Today I get error below when install Oracle 11gR2 on Redhat Linux 6.5. I follow instruction in this link: http://public-yum.oracle.com/ After I call this command: # yum install ...
1
vote
2answers
67 views

OEL fresh install while keeping old LogVols

I've been asked to install OEL 5.x on a server and setup a disk with a few directories (there's only one disk in the server). So I have an OEL 5.x server wtih multiple log volumes in a volume group: ...
1
vote
3answers
840 views

no suitable image found when installing Oracle on Mac OSX

I'm installing Oracle Database 10g Release 2 (10.2.0.4) for MAC OS X on Intel x86-64 I have Mac OS X 10.6.7, running at Intel Mac. When I start installing, I am faced to the following error: ...
1
vote
2answers
3k views

How to install Oracle extensions for PHP on Linux SUSE?

does anyone have some experience in installing the ORACLE PHP extensions (oci_connect()) on Linux SUSE ? Thank you Antonio
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 ...
1
vote
3answers
2k 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.
1
vote
2answers
5k 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
3answers
469 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
2answers
233 views

how to hide oracle version

Anyone with version fingerprinting tool can know oracle version. So, are there any ways to hide oracle version rather than filtering incoming traffic?
1
vote
3answers
87 views

Oracle database linux flavor

Can someone recommend me a linux flavor to install an oracle database on? I have no preferences for any flavor. Is there flavor which is easier than others? Or has less issues?
1
vote
2answers
120 views

Correct directory for Oracle installation on Linux

What is the best directory to install Oracle on Linux box? /srv, /opt, /usr/local?
1
vote
1answer
644 views

Oracle: TRUNCATE sometimes takes ages

Usually, truncating a table takes 5-10 seconds. But when several people work on the same DB instance (but different tables), the operation can take more than an hour. How do I debug this?
1
vote
3answers
3k views

How do you clone an oracle instance?

How do you clone an oracle instance? Basically, I want to end up copying it from d:\oracle\oldname to d:\oracle\newname. I'm working with Oracle 10.2.
1
vote
1answer
220 views

Grants for Oracle User

How do I get a list of all security rights for a specific Oracle user?
1
vote
2answers
4k views

How do I set the ORACLE_HOME variable for the Local System account?

I've run into an issue with one of my systems where multiple Oracle versions are installed for the support of various applications, but I need to run a program as a Windows service using the Local ...
1
vote
5answers
25k views

TNS-12535: TNS:operation timed out — Oracle DB

I'm seeing a lot of queries from a .Net data access server I maintain timing out. It appears to be totally random with no relationship to data or data locks. For example, the following query timed ...