We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [oracle-11g-r2]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
1k views

Oracle: How to get list of objects accessible to the user?

I want to get list of all objects which is accessible to the login user. The list should include Table, Sequence, Function, Procedure, View, Sequence, Index, Trigger etc. I am using Oracle 11g and ...
0
votes
0answers
1k views

How to restore Oracle 11g database without controlfile and spfile for a new server?

Hello everyone I have made a backup to my Oracle 11g dtabase with SID=ORCL using the command backup database plus archivelog this my output after performing this command Starting backup at 10-SEP-17 ...
0
votes
1answer
609 views

DBA_TABLESPACE_USAGE_METRICS is empty

For one of my 11.2g databases, select * from dba_tablespace_usage_metrics returns no rows. Why is that and how can I fix it? Thank you in advance.
2
votes
1answer
1k views

When trying to configure data guard broker I'm getting Error: ORA - 12154 : TNS: could not resolve the connect identifier specified

I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to data broker configuration and ...
1
vote
1answer
1k views

Flash Recovery Area full

I have oracle 11g that runs on Linux serve. I have a Flash Recovery Area, I backup my archive logs to another location. presently I have very little space left in my Flash Recovery Area (FRA) thereby ...
0
votes
1answer
1k views

Oracle 11 IMPDP Table Exists but gets Does Not Exist Error

I'm running in to a weird problem with IMPDP and Oracle DB version 11.2.0.4.0 where I have a table in the destination schema that does indeed exist, but IMPDP thinks it doesn't. See this entry from ...
3
votes
0answers
288 views

Cannot add standby database to the data broker configuration in oracle 11g

I have duplicated the primary database to standby database and then I added the primary database in data broker configuration. But when I'm trying to add standby database I'm getting following error: ...
1
vote
0answers
446 views

When trying to configure data guard broker I'm getting Error: ORA-16606: unable to find property “”

I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to my configuration and when I'm ...
0
votes
1answer
541 views

Consequences of tnsnames.ora and sqlnet.ora being unavailable

Our database servers are configured with the tnsnames.ora and sqlnet.ora files centrally located on a shared network drive. In every ORACLE_HOME/network/admin directory we have a symbolic link ...
1
vote
2answers
6k views

Cleanup of Oracle killed session

I killed a session ALTER SYSTEM KILL SESSION '123,456' IMMEDIATE; But it remains in v$session for 10 days, although an attached process is absent in v$processes. SELECT s.username, s.osuser,...
1
vote
1answer
37 views

Oracle Upgrade - Attach External Tables

We have just completed an 11g to 12c migration to a new server. There is a schema that didn't seem to come over that consists fully of external .dat files. I can't seem to find a way to simple '...
1
vote
0answers
208 views

Can Oracle Database run on Microsoft Nano Server?

Microsoft Nano Server is attractive alternative to a heavier installation of Microsoft Windows Server 2016. Can Oracle Database be prepared to run this way?
1
vote
1answer
803 views

Oracle data pump import parallel configuration

I am trying to track down a cause for a difference in oracle impdp processing, and I am not finding anything, so I am wondering if anyone here can explain the cause of the differences. At times I ...
0
votes
1answer
3k views

restore database using impdp full back

I have new server and i installed oracle 10g same like production. and I have databump full backup using sys user. I need to restore on the new server. I used the following command while database is ...
1
vote
0answers
2k views

ORA-17627:invalid username/password;logon denied error message when trying to duplicate database in data broker

I'm trying to duplicate the database for the purpose of Data broker in windows platform. When I'm trying to duplicate using below command DUPLICATE TARGET DATABASE TO LOCALDEV FROM ACTIVE DATABASE; ...
5
votes
6answers
13k views

Lack of space in SYSTEM and SYSAUX tablespace in oracle 11g R2

SYSTEM and SYSAUX Tablespace size of my DB is in the following status now: SYSTEM - PCT_USED= 99 SYSAUX - PCT_USED= 95 I believe the db is in critical situation now. What can I do to bring back it ...
0
votes
0answers
232 views

Connection to HSM Lost

We are testing a particular HSM to use replace the Oracle wallet and user as a key-store for column encryption. We are using redundant HSMs so that things will continue to run even with a complete ...
1
vote
2answers
3k views

What is an example of an extproc.ora file?

What do the contents of extproc file look like? I'm aware that my extproc.ora file is missing, and I'd like to create one in it's absence. The instructions here tell me to: Configure the Oracle ...
0
votes
1answer
393 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 ...
2
votes
1answer
21k views

Oracle 11g Rman restore with another database name from backup in windows platform

Can anyone share the proper method of RMAN restore to another server with another database name in oracle 11g(Windows platform). I'm totally confused with all the RMAN restore methods which I've found....
1
vote
0answers
914 views

How to know when did a blocking session start and end?

I created one application where requests in XML format come to my application, my application runs some select and update SQLs and then responds to the other system. Total TAT for this whole process ...
1
vote
2answers
1k views

Does v$sql_monitor show all queries?

I cannot see all queries with v$sql_monitor or gv$sql_monitor. I can see some queries, none of which have /*+ MONITOR */. I have tested a query with MONITOR and it still did not show. I thought it ...
0
votes
3answers
2k views

DBA privileges information

My colleague having DBA ROLE has created a user for me with the following role. CONNECT,DBA,RESOURCE from his own user. Then I login and check the detail by using the below query. select * from ...
0
votes
1answer
163 views

Count number of rows and sum up a field of all tables in all relevant schemas with a readonly connection

We have a rather complex database setup which involves 500 schemas. Most of these schemas contain a certain table. This table contains a certain number of rows and those rows contain a size field. I ...
2
votes
1answer
739 views

v$ or rc views to report on RMAN restore database preview

Setup: We take an Incremental level 0 backup weekly using: RMAN> backup as compressed backupset incremental level 0 database; RMAN> backup check logical as compressed backupset (archivelog all ...
2
votes
1answer
912 views

32-bit oracle client install hangs [closed]

Windows 7/x64 . installing oracle 11.2 32-bit client. Install proceeds, then at 80% hangs on netca. I have not had any luck finding a solution. Any suggestions?
1
vote
1answer
214 views

Create a job from dbms_scheduler with stream redirection?

I want to create a simple job who have to execute this shell command: echo some_text > some_file The attributes some_text and some_file can change between two calls to run_job so I need to use ...
-1
votes
2answers
2k views

Moving records from one table to another in oracle database

I have a problem on performance in oracle database and I couldn't find the solution. Here is the problem; when number of records in the table increase, the memory consumption also increase and almost ...
1
vote
1answer
602 views

What is the standard time delay taken for the data to get reflected in standby database when a new data is inserted in primary database

I've configured Data guard setup using data broker. When I'm inserting new data to the tables in primary database which is suppose to reflect in standby database. When I checked those data's in ...
0
votes
1answer
424 views

Oracle: Database writers idle until 'Checkpoint not complete' even with multiple redo logs

I work on an application with a steady data income of 400 MB/hr. For that purpose we have setup 10 redo log groups with a size 100MB each. Therefore, we roll over a log approx. every 15min. Because ...
0
votes
1answer
73 views

How to delete an unknown object?

I want to create a new stored procedure but I got this error: 00955. 00000 - "name is already used by an existing object" The problem is I don't remember to have created an object with this name ...
0
votes
1answer
193 views

Is wrapping only possible for package bodies?

I am using oracle 11gR2 database in which I was trying to wrap my scripts. I read the documents and tried to wrap a sql script which contains a create table statement. I used below commands: wrap ...
1
vote
1answer
11k views

IO Error: Got minus one from a read call [closed]

I am very new with Oracle, I have installed 11g 64 bit on my Windows 10. And only started the oracle database using emctl start dbconsole. I have the following code to be connected to my database, ...
1
vote
1answer
340 views

Case sensitive Oracle 11g

At work we have 11g and the boss told me to make passwords case sensitive, but that's where I'm going, he doesn't want to set the SEC_CASE_SENSITIVE_LOGON to true in the production environment and he ...
0
votes
1answer
540 views

how do I work out why my stored procedure won't compile?

I have a stored procedure whose sql file is nearly 6000 lines in length. It's part of a series of DB build scripts which are used in lots of environments to build a standard DB setup. When I attempt ...
2
votes
1answer
366 views

Oracle: update table with object type udt

I have this Oracle code: Create type address_ty as object( street varchar2(50),city varchar2(50),prov varchar2(50),cap number); Create type person_ty as object( name varchar2(50), address address_ty)...
0
votes
1answer
284 views

Why there is no much change in the incremental backup size of level 0 and level 1

I'm implementing incremental backup in my database. As per my knowledge after level 0 backup, level 1 backup will take only the backups of changes that are done. But in my db after level 0 full backup,...
0
votes
3answers
785 views

How to export some rows of multiple tables linked between them according to one column value?

I'm not sure my question is clear so let's me rephrase it. I have three tables organized like that: I want to make a dump of these tables but I'm not interested by all the rows, I just want those who ...
0
votes
1answer
524 views

Why my function-based index is not used?

I have a table EVENT with a column DATE_RECEIVED (the type of this column is DATE): CREATE TABLE "EVENT" ("EVENT_ID" VARCHAR2(60 BYTE) NOT NULL ENABLE, [...] "DATE_RECEIVED" DATE, [...] ); I ...
2
votes
1answer
227 views

Listener is not starting in my Standby database

I'm facing a serious issue in data guard installation. I'm setting oracle_sid and oracle_home and when I start the listener,error is showing as below: C:\Windows\system32>lsnrctl start LSNRCTL for ...
0
votes
1answer
67 views

How to increase the size of query audit log?

I need to find the queries run against an Oracle instance. On running the query: SELECT first_load_time, sql_id, sql_fulltext FROM v$sql ORDER BY first_load_time ASC; Only ...
1
vote
1answer
2k views

java.sql.SQLRecoverableException: No more data to read from socket

When I use java code to insert data to oracle,the following information appeared: java.sql.SQLRecoverableException: No more data to read from socket at oracle.jdbc.driver.T4CMAREngine....
0
votes
1answer
848 views

Is there any way to revoke drop permission from table in oracle as admin? [closed]

I tried this - revoke drop on table emp from user1; but it is not working, error is Error report - SQL Error: ORA-00990: missing or invalid privilege 00990. 00000 - "missing or invalid ...
2
votes
1answer
1k views

How to change the backup and archive destination to a network drive in oracle 11g windows

Due to space issue I want to change the backup and archive destination from FRA to a network drive in my system (I'm using windows). I've done the following steps to change the destination: RMAN> ...
-1
votes
1answer
5k views

sqlplus / as sysdba is not working in windows, ERROR: ORA-12560: TNS:protocol adapter error

I tried to login using sqlplus / as sysdba in Oracle 11g, but it is asking for a password. So I tried to login using sqlplus "/ as sysdba" since I'm using Windows. But it is showing the following ...
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
245 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 ...