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

Migrating Oracle DB to another operating system from Red Hat Enterprise by using a disk image

I have a Red Hat Enterprise server disk image that Oracle DB is installed on it. My question is : Is it even possible to use this disk image in order to setup same DB on another Oracle supported ...
2
votes
3answers
894 views

Sunfire v100 Reinstall Problems

I own two Sunfire v100 servers, and I use hyperterminal to connect to them. I am trying to re-install Solaris on one of them, so I put in the LOM cable and unplugged the harddrives. Here's the ...
2
votes
2answers
716 views

How to keep filesystem layout identical in every RedHat Installation?

I want to keep the following layout same in every installation on the identical servers: dm-0 /dev/VolGroup00/LogVol00 dm-1 /dev/VolGroup00/LogVol01 dm-2 /dev/VolGroup00/LogVol02 dm-3 /dev/VolGroup00/...
2
votes
3answers
20k views

How do I make imp use right charachter set?

I am trying to import a dmp file from one database to another. The problem is that some special danish characters are not imported right because some character map conversion is done during import. ...
2
votes
1answer
94 views

How can I tell how my oracle databases configurations' differ?

I have two databases with the same data, running on the same physical server. They are performing differently (one is twice as fast as the other). I've compared the Initialization Parameters and ...
2
votes
1answer
8k views

Oracle Enterprise Manager showing Agent Unreachable, negative disk space?

I'm recently installed Oracle 11g on a Windows Server 2008 box and although the database appears to work just fine when I load up the Enterprise Manager in Firefox it tells me 'Agent Unreachable'. ...
2
votes
1answer
65 views

Figure out exact Oracle version

I've Solaris 10 with some Oracle on it . How to find exactly, with maximum accuracy what Oracle version installed + what 64 or 32 bit this Oracle supported ? Thanks
2
votes
1answer
239 views

Microsoft SQL alternative for Oracle's Imp and Exp command

I'm looking a command line tool or SQL command to export/import a table or complete database. Much like the imp and exp commands of Oracle databases. Any suggestions?
2
votes
2answers
2k views

Disable RMAN backups in Oracle 11g

Recently I tinkered around with RMAN to see how it works, and somehow managed to get a regularly scheduled backup going. I don't really have the disk space or the need for RMAN to run, but I can't ...
2
votes
2answers
4k 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 ...
2
votes
2answers
6k 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 ...
2
votes
1answer
306 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
12k 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
347 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
465 views

How do I configure in IBM WebSphere 8.5.5 a data source using Oracle Wallet?

I have a server with a fresh installation of WebSphere Application Server 8.5.5 and I'm trying to configure a data source over a connection using JDBC and Oracle Wallet for SSL. The error message in ...
2
votes
0answers
380 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
772 views

What would cause RMAN backups over NFS to kill SAN performance?

I've been trying to figure out this problem for several weeks now, we are using an Exadata that runs nightly RMAN jobs to backup the database to a NFS mount. When these jobs occur, the average latency ...
2
votes
0answers
245 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
426 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
381 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
2k 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
252 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
136 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
1k 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
331 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
54 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
3k 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
19k 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
13k 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
452 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? [closed]

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
5k 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
4answers
8k views

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

How do I change a user's password in Oracle?
1
vote
6answers
211 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
3answers
32k 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
6answers
2k views

Linux database diff tool

I'm looking for a database schema comparison tool that runs on Linux, handles Oracle databases, and can generate a synchronization script to migrate one schema to another. TOAD does this very well on ...
1
vote
4answers
162 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
108 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
3k views

How is Oracle Solaris 11.x licensed?

can this be used in a corporate LAB? as a storage server for DEV&TEST, not production. free to use for: Developing Testing Prototyping Demonstrating your applications how are the repository, ...
1
vote
3answers
27k 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
207 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
2k 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
4k 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
374 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
6k 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 user/...
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 ...