Oracle 11g is the July 11th, 2007 release of Oracle’s primary database product. New features added in 11.0.1 include Virtual Columns, Automatic Memory Management and Interval Partitioning.
2
votes
1answer
56 views
Regular Expression Difficulty
I'm trying to extract 456 from the string :123:456: as follows:
select regexp_substr(':123:456:', ':(\d+):', 1, 2, 'i', 1) from dual
However, this query returns null. What am I doing wrong?
1
vote
1answer
123 views
Size of an empty database
Continuing with my school-project, now I have to estimate the size of the database from here to 5 years. They give me a formula, so, in that formula, one of the values is the size of the empty ...
1
vote
1answer
976 views
Oracle.exe (SHAD) process keeps increasing
I have an Oracle Server 11g that we use for integration tests. For some reason, the processes count [select count(*) from v$process;] keeps increasing up to the limit, causing ORA-12514: TNS:listener ...
0
votes
0answers
55 views
Upgrading from Oracle 10 to 11g, what to look for in SQL embedded in code?
We're planning to upgrade our enterprise database to 11g.
We have a number of web applications using it via Weblogic and Hibernate 3.6.5, and both of those support 11g.
There are a number of direct ...
6
votes
3answers
420 views
ALTER SYSTEM DISCONNECT SESSION doesn't work
Oracle 11g. The devs leave sessions connected overnight, sometimes certain cron jobs fail because of that. I am trying to kill all user sessions, but I can't.
I login as:
sqlplus system/[password] ...
1
vote
1answer
607 views
ORA-12541: TNS:no listener using EXPDP
I need to export an Oracle 11g database to an Oracle 10g instance. I have the command, which I believe is correct:
expdp user/pass@192.168.10.8 full=Y VERSION=10.2 directory=m_dump
...
1
vote
2answers
1k views
Troubleshooting Oracle ORA-08103 - object no longer exists
I am getting this error from Oracle intermittently. A trigger is truncating a partition from a partitioned table while a long-running query is running against it.
Since I'm truncating a different ...
2
votes
1answer
143 views
ETA: translate Oracle SQL queries to MySQL
task: replace Oracle 11g with MySQL
current setup:
Oracle 11g SE One
about 80 tables
stored procedures, PL/SQL are in place but out of scope for this question
client applications do not use a ...
1
vote
0answers
66 views
Port no in Oracle Forms 11G
Which port number to be used in forms 11G Preference-->Runtime--> Application ServerURL Section? I have:
1521-Given at the time of database creation
7003 and 7004-Given at the time of WLS Domain ...
1
vote
1answer
193 views
Help with getters & setters in PL/SQL
I am not a db guy, and I have a very beginner's knowledge bout PL/SQL. That being clear now the question:
I have 2 tables one file level & another batch level. In a day, only 1 file_id is ...
1
vote
1answer
306 views
Oracle out-of-place upgrade on same host: impdp issues
I am testing an out-of-place Oracle upgrade from 11.2.0.2 to 11.2.0.3 on the same host. From what I've read, expdp and impdp is the way to go. My problem is that since I am importing to another ...
1
vote
2answers
696 views
Unable to mount oracle instance
I am trying to shutdown the system, then I want to mount it. I have tried this:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
...
1
vote
1answer
1k views
Oracle server connection reset by peer socket write error
Full disclosure, I'm not a database admin, but if anyone is able to help me, it would be you guys.
Our Oracle 11g database server stopped working, I'm not aware of anything that could have caused it, ...
0
votes
0answers
171 views
How to Import a file to Oracle APEX & what are invalid files to import? [closed]
APEX is running. I tried to import a workspace that I exported in a 4.0 version of APEX
After choosing the file I get this message:
the export file has been imported but is not a valid workspace ...
2
votes
1answer
226 views
How do I connect to Oracle Server without installing Oracle Client on client machines?
I am using Microsoft VB.Net to create a Windows application, and would like some suggestions on how to connect to an Oracle database.
-4
votes
1answer
1k views
primary key, foreign key relationship between the department and employee tables How do I install? (sql_developer) [closed]
EMPLOYEES TABLE
COLUMN NAMES:
EMPLOYEE_ID
EMPLOYEE_NAME
EMPLOYEE_LASTNAME
JOB
EMPLOYEE_BUSINESS_PHONE
EMPLOYEE_GSM
SALARY
HIRE_DATE
E_MAIL
DEPARTMAN_NO
NOTE:FOR THIS TABLE: EMPLOYEE_ID IS PRIMARY ...
2
votes
0answers
1k views
Encoding problems with sqlplus, Linux
I use sqlplus and all non-Latin characters appear as '?' when I run select queries. When I run insert or update queries with non-Latin characters I get question marks on a web page.
select * from ...
0
votes
2answers
726 views
Oracle - capture row commit order in a table
Is there a way to capture the order in which rows get committed in a table ?
Our application has clients that query the table based on a sequence_id column of the table, that is supposed to reflect ...
2
votes
0answers
126 views
How to Connect R to Oracle?
I need to connect R to oracle and I have been unsuccessful so far. I downloaded two packages: RODBC & RODM.
This is the statement that I've been using: DB <- ...
0
votes
1answer
157 views
How to troubleshoot/debug Oracle permission problems
An application is connecting to Oracle to do stuff. It's not working but I don't get any ORA errors in the application itself. I'm thinking its a permission problem. So my question is what is the best ...
0
votes
1answer
70 views
Can you search using an index while indexes are being updated in oracle11g?
I am using oracle 11g. I noticed some performance problems that causes hanging on some search operations.
Can I still search based on an index while that index is being updated in the database?
1
vote
0answers
88 views
Oracle ASM failover strategies
I inherited a production system with the following setup:
Disk A, Failgroup AB
Disk B, Failgroup AB
Disk C, Failgroup CD
Disk D, Failgroup CD
Diskgroups AB and CD are configured with normal ...
1
vote
1answer
263 views
Oracle Client vs Oracle Instant Client on Linux!
to have the following setup on a Linux box:
SQLPlus
client library (oci.dll)!!!!
ORACLE_HOME is set for users
is Oracle Instant Client enough or I need to have the Oracle Client installed on the ...
0
votes
3answers
1k views
Convert a Unix timestamp to a DATETIME in a View
I have a table that stores a unix timestamp. To query this as a date, I'm attempting to convert this timestamp to a datetime type in a view. Unfortunately, I can only seem to get the DATE portion out.
...
2
votes
1answer
312 views
Alter in PL SQL Loop
I just started learning PL/SQL an hour ago... I'm trying to set profile settings dynamically... I select distinct profile names from dba_users and I'm trying to run an alter profile command for each ...
1
vote
1answer
451 views
How can I change default backup location for oracle11g using RMAN?
I want to change to another drive due to lack of disk space.
How can I change the default location of backup files used by oracle to another drive using RMAN?
By default it's in the folder ...
0
votes
1answer
1k views
Oracle SQL for left outer join to rownum = 1 of another query?
Background
I have a query joining many tables together, the chief of which is a workorder table.
I also have a table called WOStatusHistory, which stores every status for every workorder.
A diagram ...
4
votes
1answer
2k views
Connection to an oracle db from another computer
I have installed Oracle 11g to an ubuntu, I can connect to DB using sqlplus from the localhost, But I cannot connect from another computer, I have configured my tnsnames.ora as followed;
ELIF =
...
1
vote
1answer
449 views
How do you monitor specific SQL statement of a specific user ?
We have a few standalone users here which cause high server loads for several 11.1.0.7 Oracle's.
I spoke with them a few times but it seems that their queries are causing high loads and probably ...
2
votes
2answers
3k views
Oracle 11g SYSDBA login
I installed Oracle 11g on my win xp machine. Now I want to connect to the database. I was told that to connect to the database from command prompt I should use
SQLPLUS "/ AS SYSDBA". But I want to ...
3
votes
1answer
1k views
Oracle11g password expiry issue
I have a user which has a default profile in oracle db.
I want to reproduce the following warning
ERROR:
ORA-28002: the password will expire within X days
In dba_profile I set following values.
...
1
vote
1answer
330 views
In Oracle, what grants do I need as a non-schema user to view rows in all_objects?
I have two instances of an oracle 11g database, both have the same object definitions in the schema: tables with indexes and constraints, a sequence, and a stored procedure.
The facts of the case:
...
4
votes
1answer
790 views
How to use the METHOD_OPT parameter in DBMS_STATS.gather_table_stats
Hi there I was just wondering what would be the difference between these 2 METHOD_OPT parameter settings:
FOR COLUMNS SIZE 5 some_column
and
FOR COLUMNS some_column SIZE 5
both will create a ...
4
votes
2answers
728 views
Where can I find autoextend events?
In Oracle, where can I see the history of DBFs autoextending? Or get the timestamp that a DBF last autoextended, and by how much?
1
vote
0answers
1k views
Oracle 11g displaying ORA-01034, ORA-27101, and Linux “error 2” messages.
When I try to connect to Oracle 11g using:
sqlplus noah/noah@orcl
I get these errors:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or ...
5
votes
1answer
371 views
Execution plan using B+ tree index, but also sorts
I'm using Oracle sqlplus. And I have the following query:
SELECT fooID from foo MINUS
SELECT fooID from bar;
I have created two unclustered B+ tree indexes. One in the field fooIDof the table foo ...
2
votes
1answer
2k views
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
I have a problem with a SPFILE as shown below.How can I get rid of that problem?Any suggestions?
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE ...
3
votes
1answer
486 views
SOA + Fusion + Weblogic + Oracle 11g - STUCK threads
This is sort of a last-ditch effort. We have Oracle SOA on Fusion, 11.1.1.5.0 (+ patches on a separate server) running, and nearing the point where we're taking it into production. I've posted on ...
4
votes
1answer
913 views
Partitioning a table with LOB columns in Oracle 11g
we have a fairly small table (~25k rows) that is being heavily written to and most of the rows go away quickly (it's part of a scheduling application which stores information about the jobs in that ...
2
votes
1answer
1k views
How to move the ownership/copy a table from one user to another?
I've been tasked with doing some tidying of our database. I'm not a DBA expert so here I am. (We don't have a DBA expert either).
We have a user Old_User and another user New_User.
Old_User owns a ...
1
vote
1answer
1k views
Restore Oracle database from cold backup files
I have cold backup files for an oracle database. Can someone tell me a step by step procedure on how to restore the database on my machine.I am using Oracle 11g
4
votes
1answer
10k views
How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?
I have access to a ORACLE 11g server using the following listener.ora
# listener.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by ...
-1
votes
1answer
852 views
difference between oracle 11.2.0.1 to 11.2.0.2
In my environment Oracle 11g version 11.2.0.1 was installed and it was working ok. Now I am considering upgrading to version 11.2.0.2.
What is the main difference between 11.2.0.1 and 11.2.0.2.
2
votes
1answer
2k views
Oracle Wallet Setup ORA-12578
I am having trouble setting up the Oracle Wallet on a new box connecting to a new database. I have added the following lines to my SQLNET.ORA:
SQLNET.WALLET_OVERRIDE = TRUE
WALLET_LOCATION = ...
3
votes
2answers
325 views
Migrating to Oracle Flashback for Historization on Oracle 11g
Our application built using Oracle 11g requires that we keep historic data.
The historization is legally mandated, and is mainly used for manual queries, when investigating problems, etc. Basically ...
2
votes
1answer
414 views
Oracle 11.1.0 Autobackup going to wrong location
I am running Oracle 11.1.0 on Win Server 2008. My autobackups used to go to flash_recovery_area\myDB\autobackup\*yyyy_mm_dd*. Then I added a prefix to the file name in front of %F and they started ...
0
votes
4answers
2k views
What's a good client tool to access Oracle RDBMS? [closed]
I'm looking for a good client tool to replace "Oracle SQL Developer" (the tool I currently use) which supports:
Oracle DB 10g, 10gR2, 11g
Running SQL code
Debugging SQL code (with walk-through... ...
3
votes
4answers
3k views
Simplified/automated datafile free disk space reclaim
On Oracle version 11g:
After Googling, I can't find a simple way to reclaim free space after deleting a table.
I've found a lot of explanations, telling how the datafile becomes fragmented, the big ...
4
votes
2answers
341 views
Learning Oracle, does it matter if I install 10g or 11g?
I'm taking a class in Databases, they're using Oracle 10g in class, but I'm having some trouble installing the database here in Windows 8 (auth problems), so I thought I'd attempt 11g.
Is 11g ...
3
votes
2answers
840 views
Oracle 11g setup closes without errors on pre-requisite check
I'm installing Oracle 11g and the setup wizard just closes automatically after the pre-requisite check.
I have administrative access
UAC is disabled
IPv6 is diabled
There is more than enough free ...
