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.
3
votes
3answers
21k views
Oracle difference between SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name
Can someone explain to me what's the difference of SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name in Oracle ?
Thanks
Michael
2
votes
3answers
2k views
How to determine SQL causing Oracle CPU Spikes
I have a J2EE Spring/Hibernate webapp using Oracle 11g for persistence, occasionally in production the Oracle CPU spikes to 100% usage, restarting Tomcat drops the Oracle CPU. I am unable to ...
2
votes
2answers
1k views
Oracle startup and shutdown with Powershell
I'm trying to automate the startup and shutdown of some Oracle instances with powershell.
The best I've come up with so far is below
param(
[String]$Instance = $(Throw 'Instance required' ),
...
7
votes
7answers
2k views
Things every Oracle DBA should know
This could include:
Books worth reading;
Tools worth having;
etc.
1
vote
1answer
112 views
Oracle / PHP / Apache
I have built a web app that was performing very fast, until users from a third coutry (the majority) started using the application. Now its very slow.
I see from the logs that I keep getting ...
3
votes
1answer
1k views
ActiveMQ with persistence in a database
Are any of you running ActiveMQ with persistence in a database? Even better, in an Oracle database?
We're wanting to replace our current JMQ uses with ActiveMQ. The plan is to have two machines ...
1
vote
1answer
298 views
How to rescue oracle instance having oradata and admin?
I have copy of oracle folder, installed on windows. There are have oradata and admin folders.
It is Oracle 9.2.0.8.0.
I had working WibXP operation system, and installed oracle there. Now WinXP, ...
2
votes
1answer
179 views
Good Oracle book for MySQL users?
Just started using Oracle, no previous experience. I do have a good amount of experience with MySQL (and played a little with PostgreSQL). Could you recommend me a good introductory book to Oracle ...
2
votes
1answer
172 views
Non-intrusive stored-procedure auditing on Orace 10g
I'm working in a environment where there are a large variety of legacy client programs. I'm trying to get an idea of which programs use what stored procedures. Is there a way to audit access to a ...
1
vote
2answers
2k views
Find Current open Cursors in Oracle
What is the query to find the no. of current open cursors in an Oracle Instance?
Also, what is the accuracy/update frequency of this data?
I am using Oracle 10gR2
0
votes
3answers
166 views
Which platform has good job openings in Oracle 91 & 10g
I plan to do an Oracle course in Dream infotech. They are providing training in Oracle on Linux / Solaris. Which platform is best and has good job openings?
3
votes
8answers
354 views
Should a DBA store and retrieve passwords
Should a DBA record passwords for application logins, or should this be a responsibility of developers/analysts? By application login, I mean the login which an application uses for access to the ...
1
vote
3answers
4k views
Oracle 11g server rename issue
So we set up an Oracle server out of production (11g on Server 2008 x64) and our plan was to just rename the server's hostname to move it into production. Well, the database itself is functioning but ...
4
votes
5answers
3k views
Are there any disadvantages of using UTF8 in an oracle database?
We are installing ordering a configured oracle database and they are asking us what character encoding we would like to have. The application (in Java) is in English only but users are from different ...
1
vote
1answer
1k views
Rolling Upgrade of Oracle 11g from 32 bit to 64 bit?
I have an Oracle 11.1.0.7 database running on windows 32 bit. I would like to upgrade to 64 bit (same version of oracle) and would like to use a standby database for a rolling upgrade. Is this ...
2
votes
1answer
774 views
Oracle: Can Weblogic 11G run PL/SQL code like App Server 10G?
This is probably a silly question, but I'm not an oracle admin so I'm not sure. Our client currently runs a website written in PL/SQL and HTML on a Oracle 10G system. As everything is moving in the ...
2
votes
1answer
3k 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 ...
1
vote
1answer
2k views
ORA-01041 error when duplicating database to new host
I'm using RHEL 5 with Oracle 11g and I'm testing data guard.
I am trying to setup data guard by following this link:
...
1
vote
5answers
2k views
Error encountered while installing Oracle 9.2.0.8 patch set
I encountered the error message below while applying Oracle 9.2.0.8 patch set using OUI on server running Oracle 9.2.0.7 and Windows 2003 Enterprise Edition SP2:
Error in writing to file ...
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
2answers
113 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
1k 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
3k 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 ...
2
votes
1answer
5k views
Oracle XE 10g: missing file spfileXE.ora (Windows Server 2008 64 bit)
I'm having problems installing Oracle XE 10g on a Windows Server 2008 64 bit machine.
After the installation the connection to the database administration page http://127.0.0.1:8080/apex fails.
If ...
1
vote
1answer
2k views
How to Check Oracle Extent Free Space Available?
I need to add some indexes to a moderately large table and I'd like to know in advance if the tablespace has room to hold the index. (The extents are suppose to automatically increas in size, but the ...
0
votes
1answer
826 views
Weblogic - Adding websites
Is it possible to create a website in a domain pointing to a local directory?
Or does everything deployed to Weblogic have to be WAR, EAR, RAR or JAR?
I want a simple possibility to just FTP to a ...
1
vote
3answers
308 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 ...
2
votes
1answer
1k views
Oracle 10g on Snow Leopard?
I have found a couple of pages on how to get this configured on Leopard (link and link), and then apparently an upgrade to Snow Leopard does not seem to complicate matters much. However, I'm already ...
2
votes
2answers
739 views
How do I setup Red Hat Enterprise Cluster and oracle 9 to support failover?
I am trying to figure out how to use RHEL cluster to have automatic failover of an oracle 9 database from one physical machine to another. Ideally this solution would be fully hardware redundant in ...
0
votes
1answer
3k views
ORA-27101: shared memory realm does not exist
A couple mornings now my Oracle database has hit this error and not come up for an hour or so. Then it works fine for the rest of the day without needing any interaction. But this messes up my apps ...
0
votes
2answers
169 views
Oracle / windows hardware recommendation [closed]
I'm specifying a Windows server to run Oracle for (time based) performance tests of our application.
Although the total data volume & number of users will be low, we would like the performance to ...
2
votes
2answers
1k views
Skip inserts for one table with oracle imp
I'm doing an oracle imp and in the dump there is a big table that I would like to only create but not to insert row into.
Is this possible ?
Exp was done on 10.2.0.4. I'm doing imp on XE ...
1
vote
4answers
113 views
Is there service management software in existence that meets these needs?
I work in an IT dept. at a higher ed. institution. Because the department is small and the infrastructure simple, managing all the services we offer out to the school (like LDAP, AD, various DBMS', ...
1
vote
2answers
364 views
Database run in archive log mode
I'm using Oracle 11g on RHEL 5.
I've created one database with no archivelog.
After doing offline migration from SQLSERVER to ORACLE, I've changed this database to run in archive log mode.
My ...
2
votes
1answer
1k views
prevent ORA-28001?
Using Oracle 11g, is there a way to prevent my user's passwords from needing to be updated (ORA-28001)?
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 ...
15
votes
10answers
431 views
Should core system servers be able to connect to the internet for maintenance/support?
A couple of our servers have Oracle maintenance licenses. Our hardware vendor asked there was internet connection in the server room. Our policy is that all machines in that room is isolated from the ...
2
votes
9answers
5k views
Oracle Vs SQL Server to handle around 6-7 Terabytes of data
I am looking for some valid points to choose between Oracle Vs SQL Server to handle around 5-6 Terabytes of data. This data will get accumulated over a period of 8 Months. Any data older then 8 months ...
1
vote
1answer
575 views
Create Oracle user to do backup job
For the security reason, I want to create the user and then assign the backup job to that user. This means that this user is not allowed to do anything else beside backing up the database.
However, ...
1
vote
2answers
7k views
Disconnecting an Oracle Session from a Logon Trigger
I'm trying to construct an Oracle 11g logon trigger that restricts access for a specific user to a known list of applications. For example, user SCOTT can only connect with MYAPP.EXE.
I believe I ...
2
votes
1answer
155 views
Oracle Database Security
I'm currently using RHEL 5 and Oracle 11g.
I use DBCA to create Oracle database with all default options available.
The problem is that when I create a new user on that database, this user can ...
0
votes
5answers
730 views
Oracle to SQL Migration
I'm currently starting a project for an Oracle to SQL 2008 migration. Since I'm currently reading the official SSMA Guide to Migrating from Oracle to SQL Server 2005 i'd like advice and pointers from ...
2
votes
1answer
315 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 /", ...
1
vote
1answer
383 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?
2
votes
5answers
3k views
SMON process in infinite loop in Oracle database instance…help!
My team and I have Googled (and Binged!) our guts out trying to find an answer to this issue, so hopefully the Oracle gurus on SF will know the answer.
A week ago we had a power outage in the ...
0
votes
1answer
402 views
iSQLPlus not starting on Port 80
I am trying to change the port for iSQLPlus on my Oracle DB server, by making changes in the file http-web-site.xml.
When I change the port to 80, in this file, the iSqlPlus doesn't start. I can ...
1
vote
3answers
192 views
Is there a Oracle issues database?
Does anyone knows where to find the description for an Oracle issue? That is the oracle issue database?
I have found a patch for my product, and the release notes says ( in my own words )
Fixed ...
1
vote
6answers
246 views
Are there any good free or cheap tools for building an Oracle Database diagram?
I need to diagram an oracle database and I am hoping to find some good tools that are either cheap, or free.
Ideally the tool should allow me to draw the relationships between the tables, as well as ...
0
votes
1answer
427 views
How do I give access to execute packages and select from table for another schema
I have a schema called SCHEMA1 with packages and tables that needs to be accessed by user SCHEMA2.
I want SCHEMA2 to have access for executing packages and look at source code. Also I would like to ...
0
votes
2answers
64 views
Why do I only see the 'default' DB when linking an Oracle server in SQL Server 2008 Mgmt Studio?
When I add an Oracle server as a Linked Server in SQL Server 2008 Management Studio, I can only see a database named 'default', and none of the other DB's on the server. Using Microsoft OLD DB ...
