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
300 views

Setup database replication between 2 servers

Is it possible to setup replication of oracle databases, with one server outside the firewall? If so any suggestions on how to setup would be great.
2
votes
1answer
2k views

MS SQL - Problem running SQL Server Agent Job via service account credentials

There are 5 steps in this job. First job is an SSIS Package store, second to fifth are file system jobs. We configured all jobs to use Windows Authentication. Under Run As, we specified a user account ...
2
votes
1answer
11k views

How to create separate tablespaces in Oracle XE?

Creating separate tablespaces is possible in expensive versions of Oracle, but I can't seem to find a way to do so with the free version Oracle XE. The administration interface just has a "View ...
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
342 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
293 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
189 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
327 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
316 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
1answer
1k views

How do I ensure that the SQL*Net keepalive is turned on?

I have a public facing application server that accesses an Oracle database that resides behind a firewall. Some of the processes that are executed through the application server can run for over an ...
2
votes
1answer
195 views

HPSA (HP Server Automation) [closed]

Using HP SA (HP Server Automation) version 9 for automation and its Oracle database consumes inordinately large amounts of CPU resources. Anyone have a similar experience?
2
votes
2answers
104 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
595 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
0answers
272 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
53 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
17k 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
11k 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
417 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
6answers
4k views

Can Docker help me install Oracle 11g database on Ubuntu?

We are struggling with a common problem of trying to provide an Oracle 11g instance for our developers to test with. Our standard build agents are based on Ubuntu 12.04 but Oracle supports only RedHat ...
1
vote
6answers
188 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
3k views

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

How do I change a user's password in Oracle?
1
vote
3answers
24k 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 ...
1
vote
4answers
157 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
2k 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
106 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
3answers
25k 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
204 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
361 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
506 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
2answers
165 views

Why does my Apache access log timestamp sometimes go backwards?

I noticed that in my Apache log (actually Oracle's branded HTTP Server, which is really Apache) the timestamp of the lines sometimes goes down, instead of up. Here is an example: 1.2.3.4 - - ...
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
72 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
911 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
4k 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
4k views

sqlplus: I have a table that's more than 20 columns wide. How can I display it properly

In sqlplus from Oracle XE Client 10, I want to run select * from t_abc where rownum<11 on sqlplus I planned to save the result into a text file that I can view with a text viewer. I've learned ...
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
8k 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
841 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
259 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
124 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
870 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?