Questions tagged [oracle]
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. Most questions about Oracle are better placed at the sister site https://dba.stackexchange.com/
864
questions
1
vote
1
answer
255
views
Alternative for OPTIMIZER_FEATURES_ENABLE
I've installed a PHP driven application in a client's 9i server (Oracle9i Release 9.2.0.1.0 - 64bit Production). Certain queries are having an awful performance (it can use from 15 minutes to hours ...
- 249
1
vote
0
answers
85
views
Oracle Grid Control Notification for Data Guard failures
Does anyone know a way to configure a Grid Control notification rule for a failure of the SQL APPLY process on a logical standby database? I'd really like an email notification that the SQL APPLY ...
- 2,098
1
vote
1
answer
1k
views
How to change OPTIMIZER_FEATURES_ENABLE in Oracle 9i
I want to change the OPTIMIZER_FEATURES_ENABLE parameter in a local installation of Oracle 9i (32bit 9.2.0.1.0 Enterprise Edition running on Windows Server 2003) in an attempt to reproduce a ...
- 249
2
votes
1
answer
78
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
- 137
1
vote
1
answer
320
views
Oracle IIg Windows 64 Install
Tryine to do local install of Oracle 11g 64 on Win 7, everything goes fine but when I try to launch enterprise manager at https://localhost:1158/em I get a security certificate error. Where in the ...
Phil06
1
vote
1
answer
1k
views
Oracle initialization or shutdown in progress error
I installed the Oracle express edition (10.2.0) on a Ubuntu virtual machine (I am very new to Oracle Databases). Dpkg returned with a swap error, so i followed this howto to install oracle manually: ...
- 113
2
votes
1
answer
361
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?
- 183
0
votes
2
answers
1k
views
Microsoft SQL alternative for Oracle's Imp and Exp command [duplicate]
Possible Duplicate:
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 ...
- 183
4
votes
1
answer
2k
views
How to prevent remote login for SYS
Is it possible to prevent the remote logins for the SYS user? Oracle 10g.
- 141
1
vote
0
answers
675
views
Switched Oracle to use Shared Servers, now Java app throws SQLRecoverableExceptions
This issue might blur the line between Java and database problem, so I apologize if this is the wrong place for it. Not sure which side is to blame yet.
I'm a Java developer temporarily playing DBA ...
- 11
2
votes
4
answers
12k
views
How to delete data and free up disk space in Oracle DBMS 9i
I would like to know how usually one would delete data from an Oracle 9i DBMS which actually frees up disc space. Past scenario, we have had cases where clearing up 1-2 million rows of data does not ...
user66296
1
vote
1
answer
6k
views
MS SQL 2008 - Setup Oracle Linked Server [SERVICE_NAME not given error]
I'm trying to setup a linked server on MS SQL 2008 R2 to an Oracle 11g server. I've got the Oracle client installed and sqlnet.ora, tnsnames.ora & listener.ora copied from the server and in place ...
- 113
1
vote
1
answer
7k
views
Why Oracle 11g on windows default installation keeps increasing memory usage even when idle?
I installed Oracle 11g on my Windows XP 64 bit desktop with pretty much the default options. Now when I start the database, it just keeps increasing the memory usage few hundred KB at a time even when ...
- 145
0
votes
1
answer
62
views
Problem installing Oracle
I'm not an Oracle DBA, but now must install a instance. I use sqlplus to login but all commands return '2'
Why is this so?
user458739
1
vote
1
answer
548
views
Oracle Internet Directory implementation questions?
I got frustrated in managing the TNSNAMES.ORA for more than 300+ users using various Oracle DB versions 9i up to v11, usually I send email for all of the users to manually copy and update the TNSNAMES....
- 1,305
0
votes
1
answer
554
views
Does Oracle DB has a tool like DTS Wizard in SQL Server?
Is there a tool like the Microsoft SQL Server's DTS (Data Transformation Services) Wizard that simplifies the process of ad-hoc importing of flat files (CSV, TSV, or XLS) to Oracle database?
...
- 101
1
vote
1
answer
3k
views
Trouble setting timeout for Nagios test
I have Nagios monitoring an Oracle installation on a different server. Sometimes one particular test (check oracle tablespace can allocate next extent) will fail with "CRITICAL - Plugin timed out ...
- 257
4
votes
2
answers
286
views
Is there any viable alternative to using Oracle Auditing
I am currently tasked with developing a action plan for monitoring DB activity, encompassing general actions (failed logons etc) with some finer grained monitoring(e.g. who selected from table x, what ...
- 163
1
vote
1
answer
7k
views
ora-12505 error while starting new connection
I got this error while starting new connection in Oracle 11g:
Listern refused the connection with the follwoing error: ORA-12505,TNS: Listner does not currently know of SID given in connect ...
- 133
2
votes
2
answers
20k
views
Installing oracle 11g on windows 7, why getting errors?
While installing Oracle 11g on windows 7, I get these errors:
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 ...
- 133
3
votes
2
answers
8k
views
How to diagnose frequent "500 Internal Server Error" on Oracle Apex
I have an Oracle 10g XE database running on OEL 5 on an Amazon EC2 instance. On it I run a public website (actually, 2 web sites) written in Oracle Application Express 4.0.1.
Most of the year, the ...
- 168
3
votes
1
answer
5k
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?
- 133
-1
votes
1
answer
753
views
problem in run oracle server please help
I used Oracle 11g, from few days ago I face below error:
SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 7 07:33:19 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: ...
- 143
1
vote
4
answers
115
views
Requesting Oracle DBA to use SCSI instead of IDE
We want to improve the performance of our oracle database which stores around 10 TB and is OLTP.
I noted that the Oracle server uses IDE hard drive, and have heard that SCSI is faster than IDE. Will ...
fruit_trader
1
vote
3
answers
2k
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:
java....
- 740
2
votes
2
answers
6k
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 ...
- 723
1
vote
0
answers
714
views
Oracle Instant Client DSN via unixODBC
I've got the Oracle Instant Client installed on a SuSE webserver and I'm attempting to connect to an Oracle Database with PHP via unixODBC.
The connection seems to be working properly, after issuing ...
- 115
0
votes
2
answers
176
views
Oracle Installation In HP-UX
I wanna install Oracle 10g in HP UX 11.3(RISC Machine). As per the Oracle installation pre-requisites, it requires HP C/aC++ Compiler to be installed along with the requisite patches for the same. The ...
- 21
0
votes
1
answer
289
views
Connecting to 32bit Oracle server, using 32bit Oracle client on Win2003 x64
Ok so I have a proprietary com+ based integration environment running, and trying to make it work on a 64 bit system. It consists of mostly older (32-bit) vb6 and c++ components.
On to the point, my ...
- 83
1
vote
3
answers
131
views
recovery script for oracle database
I have been told I need to create an sql script that recreates all of the tables/procedures/triggers/views/sequences, etc of my current database. Does anybody have any idea how I go about doing this? ...
- 13
0
votes
1
answer
1k
views
import XML to Oracle 10g
What would be the fastest, easy, and quickest way to import an xml data to a database table in Oracle 10g database? What tool should I use (if possible free)?
The XML will look like this:
<?xml ...
- 377
1
vote
1
answer
5k
views
Unable to access Oracle DB from SQL Server with ODAC?
I've downloaded and install the ODAC for connecting oracle DB into my SQL Server 2008 using http://download.oracle.com/otn/other/ole-oo4o/ODAC112021Xcopy_x64.zip
The OleDB data provider for Oracle ...
- 1,305
0
votes
4
answers
2k
views
How much does single user Oracle database costs? [duplicate]
Possible Duplicate:
Can you help me with my software licensing question?
I am developing software for a small firm. Application back end is Oracle. I am searching for the cheapest version of ...
- 229
1
vote
3
answers
3k
views
ORA-1034 Oracle Not Found
I have recently installed oracle 11g on Windows 7 Home Premium Operating System. I logged in as administrator into windows. I am trying to create a database using DBCA wizard. I started the wizard as ...
Venkata
0
votes
1
answer
4k
views
Oracle 11g dbca on Windows Server 2008 failing with error about services - needs some more permissions?
The domain account (a slightly-reduced privilege account for managing servers) we're installing with is a member of the administrators group on the machine, but doesn't seem to have exactly the same ...
- 375
3
votes
3
answers
211
views
Is there a way to communicate DBMS with raw memory block or binaries
I am trying to communicate a numerical matrix operations library like LAPACK with any DBMS.
Is it possible to send/receive complete matrices as binary or as a direct memory pointers to process them (...
- 219
1
vote
1
answer
138
views
Oracle EE 11.2g: how to generate fresh new redo logs
In the company I work for we are heavy users of VMware machines. Almost all our projects are developed inside a virtual environment up to the point where we have to deploy them into a production ...
- 11
1
vote
2
answers
2k
views
Liferay and Oracle DB
I'm installing liferay community edition with an Oracle database, I managed to get it running with the user SYSTEM, but I don't like this... I want to create another user in another tablespace, the ...
- 13
0
votes
1
answer
863
views
Switch RAC nodes using dbconsole in Oracle 11g
Is it possible to use dbconsole (Enterprise Manager) to switch the active node of a Oracle 11gR2 cluster? The idea is to tell the active instance to go down and have another node take over.
I want to ...
- 417
1
vote
4
answers
125
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?
- 219
2
votes
1
answer
8k
views
how modify username in oracle
I create a username in oracle that has spelling mistake, I want to modify it now but I am not successful. would you please help me how I can modify my username in all_users table?
I use oracle 9.
- 143
2
votes
3
answers
142
views
Moving database from SQL Server 2005 to Oracle DB
What would be the easiest way to migrate a database that I have in SQL Server 2005 to Oracle? I have around 6 tables each with a large amount of data in it.
- 377
1
vote
3
answers
296
views
Experience with Intel X25-M 160GB and Oracle
We're considering building an Oracle database with 12 Intel X25-M G2 160GB drives in software RAID10. It'd be running Linux. Database gets some very heavy write activity during the early morning data ...
- 1,318
5
votes
3
answers
7k
views
Rename a machine after oracle (XE) installation
I am looking for a quick solution for the following problem:
I have one virtual machines (vmware) I want to be able to give to colleagues (copy of the vm). I installed on the machine Oracle XE ...
- 620
11
votes
1
answer
3k
views
Oracle 11gR2 - How to recover from normal redundancy when 1 of 2 failure groups goes down
Background info:
Oracle 11gR2
2 failure groups - normal reduncancy
Each failure group associated with a single disk
Failure Group Alpha is one Disk 1 and Failure Group Bravo is on Disk 2
We ...
1
vote
3
answers
383
views
what virtual machine should dell poweredg sc 1425 install?
I'm building our local server and want to use virtual machines but it seems VMware ESXi is not compatible with our hardware:
Server: Dell SC 1424
CPU : 2 Xeon 3.2G (buss 800, cache L2 2M)
Ram: 6G ...
Nguyen Khanh Huy
0
votes
1
answer
120
views
oracle access on vmware fusion
I'm running snow leopard and I'm doing some development that requires some network knowledge.
I've installed vmware fusion 3.0 and I've set up a virtual machine with windows 2003 server.
I need to ...
- 25
0
votes
1
answer
342
views
OAS log files filling up hard drive
We've had issues with log files for Oracle Application Server filling up the hard drive on our server. The files are in the /network/admin folder and are named server.log_XXXXX.trc and client....
- 103
2
votes
1
answer
2k
views
List remote Oracle Service Names
Some software I'm writing needs to query an oracle database - the DBA is away for a while, so all I have to go on is some source code from another application that connects to the same database (and I'...
1
vote
3
answers
10k
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,275