Questions tagged [oracle-11g]

Oracle Database 11g (not 11g R2). Please also tag oracle for search purposes.

Filter by
Sorted by
Tagged with
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: ...
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 ...
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 ...
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:...
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 ...
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....
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\...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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] ? ...
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 ...
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 ...
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 ( ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 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 ...
-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.
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 ...
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 ...
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 ...
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 ...
-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
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 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 ...
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 ...
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(...
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 ...

1
2 3 4 5
15