Questions tagged [oracle-11g-r2]

Oracle Database 11g Release 2. Please also tag oracle for search purposes.

Filter by
Sorted by
Tagged with
1
vote
0answers
1k views

How to audit database user password changes in oracle 11g?

I want to record how many times or which user accounts passwords were changed using Oracle database auditing techniques. I also want to record any password changes done to system user account.
1
vote
0answers
15k views

ORA-19815: WARNING: db_recovery_file_dest_size of 53687091200 bytes is 100.00% used, and has 2340864 remaining bytes available

I'm using Oracle 11g database in archivelog mode. I'm getting the following error in my database logs for the last two days. *** 2017-05-19 22:01:04.164 4515 kcrr.c ORA-19815: WARNING: ...
1
vote
1answer
249 views

What could be the possible reasons for cardinality estimates being very inaccurate in an execution plan?

I have a query that is selecting some data out of a table. The execution plan shows that an INDEX (FAST FULL SCAN) is used and the cardinality is 22. On the running the query it gives 227,652 rows. I ...
2
votes
1answer
101 views

Will “Oracle Express 11gR2” installation mess with the “Opera PMS” software

As in the title, I want to install "Oracle Express 11gR2" on a Win7 machine that runs Opera PMS Software (pms for Hotel Management) via Internet Explorer. I want to write a Python script that will ...
0
votes
0answers
3k views

ORA-00257, 00000, "archiver error. Connect internal only, until freed

When I was connecting to my database through SQL Developer tool I was getting error message as below: ORA-00257, 00000, "archiver error. Connect internal only, until freed." Cause: The archiver ...
1
vote
1answer
4k views

Oracle: Trigger to store username after INSERT into column of same table

Let's say I have a column in a table within my database named 'CREATE_USER'. How would I go about creating a trigger that on INSERT on the table: inserts the name of the row creating user into the ...
0
votes
1answer
599 views

How to delete Missing archive log file

I’d needed to stop archive log mode for some reason. When I tried to change the mode message told me to some file have been missing. Alter database noarchivelog; ORA-01111: name for data file 5 is ...
1
vote
1answer
570 views

Cannot execute job that runs a shell script

I have the following pl/sql script that should execute the shell script script.sh. When I runt the code below In SQLDeveloper I get: Error report - ORA-27370: job slave failed to launch a job of ...
0
votes
1answer
533 views

Assignment of dbms_metadata.get_ddl to pl/sql variable fails

I have the followig script declare v_tmp CLOB; begin v_tmp := dbms_metadata.get_ddl('TABLE', 'FOO', 'BAR'); end; Where FOO is the table's name and BAR is the name of the current user. When I ...
1
vote
1answer
12k views

Generate `insert` statements for each entry in a table

What is the simplest way to generate insert statements fro every entry in a table? For a table with 3 rows, I need to generate 3 insert statements. For a table with n rows I need to write to a file n ...
2
votes
1answer
26 views

What complications arise from edits to a table receiving a new index?

I have a very large table (1.9 million records) that currently has a unique index. I need to change that unique index to a non-unique index. Because I am trying to avoid an "outage" from this ...
2
votes
1answer
181 views

Oracle 11 query functions default value

Is there any way to select the default value a procedure/function has for a specific parameter in the procedure/function ? user_arguments has a field called default_value (long) but I do not see any ...
1
vote
2answers
846 views

Oracle file permissions expdp vs dbms_datapump

We have written our own export function using calls to dbms_datapump. In some systems the export fails due to insufficient file permissions on the chosen directory. However, using expdp to perform ...
0
votes
1answer
2k views

What is exadata database?

I need to know Is oracle exadata database is same as the oracle database which is installed in my laptop. What is the main difference. Can I simply take backup from exadata database and restore it in ...
1
vote
1answer
489 views

Find current users DDL statement running, Oracle 11g

I have created a database trigger (oracle 11.2.0.4 standard edition on windows 2008 R2) to intercept any drop or truncate statements, eg drop table abc123; and that will raise an exception to ...
0
votes
1answer
186 views

Using REGEXP_REPLACE in Oracle

Am trying to use backreference expression to take out three subexpressions from a search, and reposition each subexpression as follows: SELECT REGEXP_REPLACE('AAA 123 ppp','(^[[:alpha:]]+) ([[:digit:...
0
votes
1answer
37 views

Oracle writes whole file during database creation is it ok?

Consider empty (!) database creation: CREATE TABLESPACE reload DATAFILE 'D:\myDb.dbf' SIZE 3000M ONLINE; This is leads to writring 3000 megabytes to the disk for empty database. Is it normal for ...
2
votes
1answer
8k views

SYSTEM tablespace getting filled up

My SYSTEM tablespace is getting filled up enormously within a few days. I've added another dbf file when it was filled up completely earlier. Now, the second .dbf is also about to fill. The only ...
1
vote
2answers
157 views

Does any kind of constraint in a database have a unique constraint name?

I know that it is possible and even encouraged to add primary key constraints and foreign key constraints after the creation of the table so that the programmer has control over the names of the ...
0
votes
1answer
750 views

How to do Oracle database cluster / Failover without shared storage

I have 2 or 3 RHEL 6 servers and I don't want to have a dedicated storage device. I think maybe you can replicate changes from one node of a cluster to another in real-time. I want to cluster them so ...
0
votes
1answer
597 views

Insert query optimisation - Oracle

One of my developers is trying to perform insert into a table by selecting from a table. Below is the query that was run. The query takes extremely long time for execution (4hrs odd). Number of ...
1
vote
1answer
794 views

Unable to start listener of standby database

As part of data guard configuration, I've installed standby database using Oracle Software only and configured .ora files/folders as required. But while trying to start the listener or check the ...
1
vote
1answer
2k views

Why public synonyms become invalid

I have 2 packages and 2 public synonyms for those packages. There are dependencies between those packages. If I make changes to any of those packages and compile them then packages are compiled (specs ...
0
votes
1answer
519 views

create additional oracle 11g database in linux

I have already created a database XE on my linux desktop.Please find the below information about the database. ORACLE_SID=XE ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/...
2
votes
3answers
3k views

Feasibility of Partitioning existing tables with huge data in Oracle

We have a set of 24 tables that take up about 1tb+ data which is why DBA suggested to use partitioning to better handle usage. The only issue being the partitioning of the existing tables is ...
1
vote
1answer
300 views

Auditing authentication issues in a distributed environment

I'm trying to get a better handle on what locked out a specific user when multiple Oracle databases are involved using database links. Setup: sqlplus kjohnston@db2 create user testuser identified ...
0
votes
1answer
2k views

Why CTX_DDL.SYNC_INDEX procedure doesn't work?

I'm following the Oracle documentation to create indexes with Oracle Text. The problem is, when I update my data and want to synchronize my index with the CTX_DDL.SYNC_INDEX procedure (according to ...
1
vote
0answers
441 views

Oracle - can't drop an editioning view

I have an Oracle 11gr2 DB, and I have created an editioning view called TEST which I'd now like to drop. I run DROP VIEW TEST; as DBA, and get the following error: ORA-04045: errors during ...
1
vote
1answer
719 views

What is the meaning of the segment name of a domain index?

I want to know the space used by one of my indexes. I query the view DBA_SEGMENTS to do it: SELECT segment_name, sum(bytes) FROM dba_segments WHERE segment_name LIKE '%INDEX_NAME%' GROUP BY ...
1
vote
1answer
1k views

How to delete tablespace and table after delete datafiles?

I deleted datafiles with asmcmd. I need to delete tablespace and tables on this tablespace. I tried: drop tablespace tablespace_name including contains cascade constraints getting error: ORA-14405: ...
0
votes
0answers
175 views

How to turn on the expanded mode in Oracle SQL*Plus?

As in the switch \x of PostgreSQL. For more information on the PostgreSQL expanded mode, fetch https://serverfault.com/questions/618642/psql-expanded-mode-equivalency-for-mysql. Both PostgreSQL and ...
4
votes
2answers
353 views

Why does SAMPLE BLOCK often return zero?

In a comment on another question, someone asked: I used SAMPLE BLOCK in many tests but found that it would inexplicably return '0' much of the time. Any idea why? I speculated that this might be ...
0
votes
1answer
199 views

How to make datapump apply directly to the destination schema

I have a schema on a server that returns and half I need to replicate it to another server, so I'll la and do an expdp on server1 sending the file to server2 and do an impdp. Solve the problem. ...
1
vote
1answer
126 views

Use which schema to query V$OSSTAT

I need to query the values of V$OSSTAT and am able to do so using tools like dbVisualizer. But when I take the identical query and put it into some Javacode I fail to find the table. I had this ...
3
votes
1answer
688 views

Oracle Client Silent Install Fails

I'm creating an automated package in PDQ Deploy which installs the Oracle client, and some patches. Step 1 copies the staging files to the target, which completes successfully. Step 2 attempts to ...
3
votes
1answer
53 views

Incrementally Updated Image File Backup Multiple Locations

With an Incrementally Updated Image File Backup the same script handles both the initial image backups, and the incremental backups that can be applied to the images to bring them up to date. Is ...
1
vote
1answer
69 views

How much Tablespace we need to create for Oracle schema [closed]

How is the optimum number of tablespace we need to create in an Oracle schema ? One for data and one for index ? Thanks
-1
votes
1answer
294 views

EXPTIME in Oracle database stands for?

I want to know the table name and what it actually stands for - EXPTIME apart from CTIME, LTIME and PTIME
1
vote
1answer
902 views

What are the events that EVMd process in Oracle RAC distributes across cluster?

I am new to Oracle RAC. I was studying about Oracle RAC background processes, in which I came across EVMd process which distributes the event message across other nodes in the cluster. Could you ...
2
votes
1answer
431 views

Add New Interface for Oracle DB

I believe there are similar question about this. But I need more explanation about my plan. I have an 11g Oracle database running with one listener on port 1522. And currently using one interface (...
4
votes
1answer
272 views

Ship Standby Logs Without Datafiles

When building a new standby database, is it possible to have it start shipping archive logs from the primary without having the datafiles on the standby yet?
0
votes
1answer
1k views

ORA-01722: The specified number was invalid when truncating timestamp

Query: SELECT first_load_time FROM v$sql; Result: 2017-02-16/07:45:25 2017-02-17/06:47:36 2017-02-17/02:05:31 2017-02-15/17:39:13 Query: SELECT to_char(FIRST_LOAD_TIME, 'YYYY-MM-DD') ...
1
vote
1answer
6k views

Datapump export taking too much time to complete

I've scheduled to take a backup of my oracle11g database, daily at 11pm via Windows Task Scheduler. At this time, I'm not letting my database to go down. Also, my database is in noarchivelog mode. ...
1
vote
1answer
19k views

Encountering “Snapshot too old” error during execution of expdp command

As am facing an issue while performing expdp command in my production db.(Oracle 11g in windows enviornment) cmd> expdp 'sys/123@PROD as sysdba' DUMPFILE=BACKUP_02082017_BACKUP.dmp LOGFILE=...
1
vote
1answer
639 views

How to resolve TNS error in Oracle 11g when connect with Navicate) [closed]

I want to connect Oracle11g with Navicate, but when I make a connection he display a error Ora-12514: TNS: Listener does not currently know of service requested in connect descriptor.
1
vote
2answers
763 views

Database backup using RMAN

We are planning to backup database using RMAN, but since I'm a newbie in DB administration, I don't have much knowledge in this. I've a few queries though. Currently we are using Oracle 11g database ...
1
vote
0answers
220 views

Oracle 11.2 index on VARCHAR vs index on DATE

I have a table with 15,339,375 records and it has an index on a date field that's converted to a VARCHAR(5) and stored as "MMYDD". It has an index on the field. The records in the table are all from ...
0
votes
3answers
984 views

Issue in DB export

I've scheduled to export my database at every midnight via Windows Task Scheduler. This was properly exported for so long. But, recently in some days, export is not happening as required. The logs are ...
-1
votes
1answer
409 views

Way to restore database in 'noarchivelog' mode

My database(Oracle 11g) is in 'nonarchivelog' mode. Now, I'm encountering an issue with my database server. Unfortunately, I don't have any database backup as well as VM back up of last two days. I'm ...
2
votes
1answer
2k views

Sequence number shows a lower value after dump file import

I'm using Oracle 11g database in which I have more than 12 schema's consisting of many tables. I've created sequences for primary keys to these tables. I've also created synonyms to refer my ...