Questions tagged [oracle-11g]
Oracle Database 11g (not 11g R2). Please also tag oracle for search purposes.
726
questions
2
votes
1
answer
6k
views
ORA-01157: cannot identify/lock data file 201
SQL> select FILE_NAME,TABLESPACE_NAME from dba_temp_files;
*
ERROR at line 1: ORA-01157: cannot identify/lock data file 201 - see
DBWR trace file ORA-01110: ...
CommunityBot
- 1
0
votes
1
answer
390
views
Oracle 11g - Decreasing Big Table Size
I want to reduce the size of a table.
I thought if I could do this with export / import, but when I check it
with the ESTIMATE_ONLY option, it doesn't seem to work.
I have no chance of using ...
CommunityBot
- 1
0
votes
1
answer
4k
views
Unable to connect to oracle database. Getting ORA12505 error
I am newbie to ORCALE
I am trying to connect to oracle server and i am getting this error. This is was working fine before but now i am facing this issue. Need help
An error was encountered ...
- 101
0
votes
1
answer
300
views
error writing input to commandERROR: Invalid username and/or password
This is the error I have been getting on my RMAN notifcations on my backup jobs for the last day or so. The title is exactly how the message is formatted.
~~~End Step Output/Error Log~~~
Error Log:...
CommunityBot
- 1
0
votes
1
answer
197
views
EMStagePatches_$ORACLE_SID is using up space
We have this directory:
$ORACLE_HOME/EMStagePatches_$ORACLE_SID
We are running out of space and this directory is using up a lot of space. Is it safe to delete it? I think it is something to do with ...
CommunityBot
- 1
0
votes
2
answers
36
views
Query optimization [Oracle DBMS]
I have a query that always must return a single row and its execution time is about 5s, so I need to optimize it:
SELECT * FROM RESPONSE res
INNER JOIN REQUEST req ON res.ID = req.ID
WHERE res....
- 2,492
0
votes
1
answer
605
views
How to view databases and tables after 'imp' import using Oracle SQL developer
Maybe that's a wrong form of answer...
The problem is:
I've got an Oracle database dump file (very old, created with imp utility)
At last, I've imported it. The command was imp file=E:\Downloads\...
CommunityBot
- 1
0
votes
1
answer
29
views
Migrate from Oracle 9.2 to 11g
I have a executable application that using Oracle ODBC Driver V9.2. My Old server Have Oracle 10g on windows 2003 32bit. I install and configure new server using Oracle 11g on Windows Server 2016 x64.
...
2
votes
2
answers
21k
views
How can I find port running Oracle Enterprise Manager
I need to connect to the Oracle Enterprise manager of a remote machine. But I dont know the port on which OEM is running on the remote machine. I have access to the machine from terminal though.
Is ...
CommunityBot
- 1
4
votes
1
answer
6k
views
Oracle Database Server TNS Listener Remote Registration Vulnerability (CVE-2012-1675)
Some of our Internal DBs Oracle installed in Linux and Windows servers have been highlighted with the issue Oracle TNS Listener Remote Poisoning (CVE-2012-1675).
This security alert addresses the ...
CommunityBot
- 1
0
votes
1
answer
451
views
Partitioning on a computed column
Using - Oracle 11g
I have created a table say X. of this table, a column say C3 is a computed column which will have a value based on incoming values for the other 2 columns say C1 and C2. I am using ...
CommunityBot
- 1
1
vote
2
answers
640
views
How to switch between Oracle 11g and 12c on same linux
I have oracle11g and 12c installed on same machine and few test cases that need to be run on both versions.
Can power up both database simultaneously and run tests parallely.
Do you know any document ...
CommunityBot
- 1
1
vote
1
answer
1k
views
Is it possible to show DML that is locking some table?
I already saw here how I can list my locked objects. Suppose I, using PL/SQL Developer(pink cylinder logo one), run select * from someTable for update and didn't commit nor rollback. Now using the ...
CommunityBot
- 1
1
vote
1
answer
838
views
Error ORA-12505 when connecting to Database Oracle 11g SQL Developer
recently I installed Oracle XE 11g with SQL Developer.
When I first ran it and created a database and a new user, everything worked perfectly - I was able to connect to the database and was able to ...
CommunityBot
- 1
0
votes
0
answers
28
views
Best approach for purging records (including related records) from an Oracle database with undo capability?
Please let me know which approach you would take.
The problem
I have a large Oracle 11g DB that needs to have old records purged to free disk space. One of the requirements for the project is that we ...
- 183
0
votes
1
answer
310
views
Oracle 11 rman db restore file corruption
First to mention that I came to the need of asking help after furious research I reattempts for about 3 weeks. I checked previous threads in Oracle community but nothing works for me. I am trying to ...
CommunityBot
- 1
0
votes
1
answer
208
views
Dataguard the datafiles are created in another diskgroup
I have a recently made physical dataguard configuration and everything works correctly so far, but I've noticed that the datafiles that are created in the primary are created in the standby in a ...
CommunityBot
- 1
2
votes
1
answer
544
views
Oracle using sub-optimal index on bind variables
Let's say you have a table, called ORDERS, which contains ORDER_NUMBER, CUSTOMER_ID, and ORDER_DATE (among other fields). And you have one index on ORDER_NUMBER, another on CUSTOMER_ID, and third ...
CommunityBot
- 1
0
votes
3
answers
174
views
Command Line Creation of a new 12g Oracle Database
I am new to creating an Oracle database using the command line. I am logged in as superuser; now I would like to create a new blank database, "mynewdatabase".
$ . oraenv
ORACLE_SID = [oracle] ? ...
CommunityBot
- 1
1
vote
2
answers
429
views
Connection denied from Java application
I try to connect from my little Java class to Oracle11g database and connection was refused with a SQL error.
From client (SQL Developer) connection works.
This is the ERROR when I try to run java ...
CommunityBot
- 1
0
votes
1
answer
3k
views
Oracle PLSQL validate a row and insert each cell value of row as a new row with validation results in another table oracle
I am very much new to the DB world, so wanted to review whether I am following right approach or not.
I have two tables,
table A --> is a table with 40 columns
table B --> is a table with the 3 ...
CommunityBot
- 1
1
vote
1
answer
29
views
insertion in a table of objects with nested table in oracle
I have a problem inserting in a nested table in oracle
These are the relevant types and tables;
create type movies_type as Table of ref movie_type;
create type actor_type under person_type
(
...
- 4,726
0
votes
1
answer
703
views
How to convert the JSON date with to_date function
How to convert the specific string Aug 6, 2018 3:17:11 PM with the function to_date?
That string is a result of a Java parsing mechanism for JSON. I would like to be able to recover it directly from ...
CommunityBot
- 1
8
votes
1
answer
990
views
Oracle Ref Partitioning: Deadlock due to child table row migration
My ordering application uses Oracle 11g Database. This DB has a primary table ORDERS and multiple child tables like ORDER_DETAILS, PLAN etc.
ORDERS table is LIST partitioned on STATUS column and all ...
CommunityBot
- 1
0
votes
1
answer
177
views
EMCA insists that it cannot connect to the service
Really new to Oracle and being a DBA in general. I am trying to set up a development environment so that I can play an learn oracle better. Enterprise Mananger failed to configure itself when I first ...
CommunityBot
- 1
0
votes
1
answer
43
views
Is there any method like max() function? oracle version 11.1.0
I want to select the maximum value, but if the user has more than one value in one column, then leave all
I have a table :
create table package (U_id, service, offer,product) as
select 1, 12345, ...
- 4,726
0
votes
1
answer
213
views
Oracle 11gR2 - Expdp Full Database With Exclude Some Table Data
We will migrate our database using datapump.
It will be full database export with exclude some table's datas.
But we want to do a different operation for 2 different tables. We want to export the data ...
- 89
0
votes
0
answers
41
views
replace duplicate column values only on one column, from second occurrence onwards
I have a simple query in Oracle 11g
select ID,Section,Capacity,Output from yeilds order by section;
that returns data in this form
ID
Section
Capacity
Output
2
SectionA
45
30
3
SectionA
45
25
4
...
- 465
5
votes
3
answers
33k
views
Passing parameters to a procedure executed by DBMS_SCHEDULER
I have a scheduler program that runs a stored procedure that requires input parameters.
BEGIN
DBMS_SCHEDULER.DROP_PROGRAM
(program_name => 'MYSCHEMA.EXPORT_SCHEMA_STARTING');
END;
/...
- 2,127
2
votes
1
answer
20
views
Moving logs (not archive logs or redo logs)
My employer has six Exadatas: three in a RAC in one data center, and the other three in a RAC in another data center. One is primary, and the other is a DataGuard standby. On the standby RAC, we also ...
- 2,256
-1
votes
1
answer
108
views
Why can't Many to Many relationships exist in relational database management systems?
While reading Oracle 11g Sql by Joan Casteel, the author mentions that many to many relationships couldn't exist in relational databases. I was wondering what the reasoning behind this fact was.
- 72.4k
1
vote
1
answer
797
views
drop table causes ORA-08103 with another one
In my process I have 2 tables.
target table, load table.
The target table holds the current data, and a lot of queries are fired against it.
When new data coming we use a FULL LOAD and the goal ...
CommunityBot
- 1
0
votes
1
answer
100
views
Oracle database issues
I had my database working properly but I had an issue and when I tried to repair it I executed the following command
alter tablespace system add datafile '/var/oracle/oradata/data.dbf' size 10000m ...
CommunityBot
- 1
0
votes
1
answer
47
views
Sum of Total per Client
I want to know the total of each product that each customer has bought and I don't know how to add the total per customer.
The tables are as follows:
CREATE TABLE CLIENTES -- Customers
(
CODIGO ...
- 126
1
vote
1
answer
2k
views
Generate & Email report from Oracle Forms 11g
I generate a report in PDF through passing of parameters from Oracle Forms 11g. I have a requirement to email the same report automatically as well. Following is the part of forms where I have passed ...
CommunityBot
- 1
-1
votes
1
answer
47
views
Example tablespcae in Oracle 11g
I need to know why example table space is created by Oracle 11g ? Does it effects the performance if it is full ? if yes how can we stop it being used ?
Thanks
- 2,256
0
votes
0
answers
34
views
How to store data in loop and after assign data set to out ref cursor in Oracle
I tried to store date in loop and after that dataset set to OUT SYS_REFCURSOR. In this time I declared array variable and I tried to store data in loop by each iteration. and after, I want to assign ...
- 1
0
votes
0
answers
29
views
How to resolve the "file 1 needs media recovery" error in Oracle 11g?
I am trying to migrate oracle 11g database from Windows to a Linux server. I have followed these steps for migration:
I have opened database in mount mode.
Then I have backed up file on the Windows ...
- 22k
0
votes
1
answer
48
views
ORA-12514 error after rebooting
We have an oracle 11g cloud database that was working fine until recently when it started throwing the ORA-12514 after every reboot. The instance is programmed to be started up every morning and ...
- 6,803
0
votes
1
answer
63
views
Oracle 11gR2 (11.2.0.4.0) - Drop and Remove Datafiles
We have a database of 2000 users.
We will drop all remaining schemas, leaving only 2 end users, excluding Internal (Oracle maintained) users.
After this operation, there will be a very high reduction ...
- 1,929
0
votes
0
answers
54
views
TNS:destination host unreachable
I have a Linux server running oracle database 11g with an interface setup (eth0). due to some other requirements, i added a new interface (eth1) to connect to a separate vlan and a proxy was also ...
- 1
0
votes
3
answers
333
views
Oracle database won't start, ORA-03113
Running Oracle 11.2.0.4.0 on CentOS and discovered the hard drive filled up, giving error in alert log:
ORA-19815: WARNING: db_recovery_file_dest_size of 64424509440 bytes is 99.98% used, and has ...
- 1,929
0
votes
1
answer
44
views
When to perform which type of incomplete recovery?
This is purely learning purpose, that which incomplete recovery type is use in which condition? And DBA is bound to choose one or can choose anyone of following Incomplete recovery type?
Scn-based ...
- 1,929
1
vote
1
answer
64
views
Why is Oracle's TZ_OFFSET wrong for all cities on only one server?
Why does Oracle think that the timezone offset of Denver is UTC-7:00?
The server time and systimestamp look right.
Server 1: Oracle 11.2.0.4.0
SELECT SESSIONTIMEZONE FROM DUAL;
America/Denver
cat ...
- 2,492
6
votes
5
answers
28k
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 ...
- 67.5k
9
votes
3
answers
79k
views
ORA-01502: index or partition of such index is in usable state problem
I have a table in my Oracle database, where
select pkcol, count(*) from myTable group by pkcol having count(*) > 1;
yields
PKCOL COUNT(*)
------- ----------
1 2
2 ...
1
vote
1
answer
15k
views
Select query with views crashes with ORA-03113: end-of-file on communication channel
I've installed an application developed on 11g XE in a 11g Enterprise Edition server (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production) and main SELECT query triggers this:
...
4
votes
2
answers
771
views
RDS Oracle SE - Performance troubleshooting options
I have an RDS Oracle SE2 instance with Amazon RDS. Our team is looking forward to move couple of applications to RDS. But we’re looking for options that are available in RDS Oracle SE to perform ...
0
votes
1
answer
30
views
Counting failed attempt
Here is my code:
create table failed_login_attempts(
login_id number(5) primary key,
date_created timestamp default systimestamp,
email varchar2(110),
ip varchar2(24),
mac varchar2(18),
attempt number(...
- 1,833
20
votes
4
answers
85k
views
Can I change the SID of an Oracle database?
The Server is Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit
Is there an easy & quick way to change the SIDs of the test databases on the server?
Dropping & recreating of ...
