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
0answers
19 views

Update Certificate in Oracle Wallet

We have been downloading data from our vendor for over ten years over the Internet through an encrypted connection enabled by an Oracle Wallet. The self-signed certificate expired, so the vendor sent ...
0
votes
1answer
38 views

Migrate a remote oracle database (11g) into a docker oracle XE database (11g)

I am brand new to Oracle and I am trying to migrate an existing VM that has deployment scripts run on it every release to use a docker container instead. Then I can run the release scripts and tag a ...
2
votes
2answers
65 views

How to “flatten” multiple rows with same ID (Oracle 11g) by concatenating **multiple** fields per row?

I'm connected to an Oracle Database (11g Release 2 - 11.2.0.4). I'd like to "flatten"/"merge" all rows with the same ID, pretty much as is well delineated here: https://www.w3resource.com/mysql/...
0
votes
1answer
62 views

How to alter database hour and date in Oracle?

How can I alter the date and hour of the database? I don't want to alter the hour and date from the server, only in database.
0
votes
0answers
17 views

How to refresh the URI type data : insert into temptable values (SYS.URIFACTORY.getURI('URL'));

How to refresh the URI type data and reload to table , whenever the website url got refresh. My complete code: Created table with URI TYPE create table vignesh3(url URIType) loaded data ...
1
vote
0answers
6 views

Problems with Standalone grid : Cannot start database with srvctl, Enterprise manager cannot find listener

First of all, thanks for your time and effort on this, I've been looking into this problem for about two weeks but still haven't figured it out yet. I know it might be due to different root causes, ...
0
votes
0answers
24 views

oracle dbca do not start

I need to create a new instance in an existing installation in 11gr2, but despite having configured the variables of the new instance, executing the dbca does not start, and no error message is ...
0
votes
2answers
38 views

Oracle Active Data Guard - OPEN_MODE STATUS

I would to ask some question regarding Oracle Active Data Guard. Currently, we are looking for an efficient way to get a real-time backup of Oracle Database. We tried to apply Oracle Active Data ...
1
vote
1answer
33 views

ORA-00904: “GET_JAVA_PROPERTY”: invalid identifier - 11gR2

In Oracle DB 11.2.0.4, linux 6.7 single instance select get_java_property('java.version') from dual; SQL> show user USER is "SYS" SQL> select get_java_property('java.version') from dual; ...
0
votes
1answer
40 views

DB_RECOVERY_FILE_DEST_SIZE automatically decrease size after shutdown

I am using oracle database 11gR2. I increased db_recovery_file_dest size with alter command alter system set db_recovery_file_dest_size=60G scope=both; When I shutdown database and again open ...
0
votes
1answer
32 views

Which mechanism is best for previous data archived in oracle?

Our company has a big data server in which large data is stored, like images, video, audio, etc. Our company wants a process running with the new year, such that in 2020 the previous year's 2019 data ...
1
vote
1answer
32 views

Give me suggestion about backup of schema and full backup in oracle

I need your help about backup in oracle database. Currently I am using Export Utility of Schema Backup but taking more time to complete and size is 40GB. For full database backup using Image Copy and ...
0
votes
1answer
23 views

Executing an oracle variable string as I do in SQL Server

In SQL Server I can do something like: DECLARE @VAR VARCHAR(100); SELECT @VAR = SELECT * FROM SYS.DATABASES EXECUTE(@VAR) How can I execute a string that I've created inside a variable in Oracle? ...
0
votes
1answer
27 views

11g dataguard broken after primary ran out of space

I have Data Guard setup with Primary (A) and read-only standby (B). primary server (A) ran out of space on the data mount point as auto extend was turned on. I managed to revive it by adding ...
0
votes
1answer
116 views

ORA-12516: when accessing another database via link

I need to bring some data (blobs) from another database. I created global links to enable bidirectional communication. The links work. When I try to bring some data from tables that have BLOB columns ...
0
votes
1answer
37 views

Installed Oracle XE 11.2. How do I create a database?

I'm new to Oracle, so please bear with me. I recently installed Oracle XE Release 11.2 on a Windows 2008 Server that we have. The installation was successful. During installation, I was asked to set ...
0
votes
0answers
19 views

SSMA Migration data failed from Oracle to Azure Database

I'm having an issue with the migration between an Oracle database and an Azure Database using SSMA v7.10.0. I can connect, convert the schema and synchronize with the Azure database with no problem. ...
0
votes
2answers
37 views

creating view on “oracle view”

I am using oracle 12c. We have an oracle view ALL_SCHEUDLER_JOBS. As we will loosing the access to this table, I create a view on it as below : the below function is placed inside a package called ...
1
vote
2answers
90 views

Issue Moving data from 11g to 18c

I have an rman database backup from Oracle 11g XE which i am trying to import into oracle 18c XE database using below commands rman target / shutdown abort; startup nomount; SET DBID ...
2
votes
1answer
52 views

How can i select columns from two tables using REF

I'm new to Oracle's PL/SQL i'm using 11g. I have 2 Type Objects each one of them with has a table and third table where i keep references of this 2 objects, how can i retrieve values from objects ...
1
vote
1answer
225 views

Does Oracle 11gR2 is supported on RHEL 8 or Oracle Linux 8? [closed]

Oracle (afaik) did not updated their compatibility matrix yet. Can I run Oracle 11gR2 (which still is in extended suporte) in the new OS?
1
vote
2answers
36 views

SQL queries to get the duplicate records based on trim

I have a table that has got the below set of records. UNMASK MASK 123 897609 00123 896509 0000456 5632789 456 32567889 5678 5632789 From the above table I need to select only the below records....
2
votes
1answer
102 views

Oracle: Casting timestamp as date and comparing result

I don‘t really understand what cast(timestamp as date) is doing. I am on Oracle Database 11g Express Edition Release 11.2.0.2.0. select cast(to_timestamp('20190516 08:00:00', 'yyyymmdd HH24:MI:SS') ...
1
vote
0answers
334 views

Oracle listener give “Message 850 not found; No message file for product=network, facility=NL”

I'have just completed oracle 11g database software installation on Linux. I launched netca and configured a listener. As soon as I try to run lsnrctl I get the following error. [oracle@lnx-db ~]$ ...
1
vote
2answers
66 views

Reading data from oracle 8 in 2019

I'm an intern stuck dealing with a database system that is as old as I am. The Issue: I have a perl script pulling data from a server running Oracle 8 (8.1.7) and placing the data into a .csv. The ...
0
votes
0answers
25 views

Extract table data in a BLOB field

I am trying to extract data from tables in a delimiter separated value format. To extract data i am concatenating all the columns of the table with each other and then converting the concatenated ...
0
votes
1answer
33 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 ...
0
votes
1answer
51 views

UTL_RAW “invalid identifier” error message

When I execute the following: select utl_raw.cast_to_raw('8') from dual; I receive the error message below: invalid identifier ...while in other PC with the same Oracle version, i.e., 11g, the ...
0
votes
1answer
24 views

Using AMMM or Huge Pages for Oracle 11g R2 Database

I'm running an Oracle production 11gR2 database which has around 65Gb of data, running with a 4Gb SGA & 40Mb PGA using ASMM. Now, I have a memory increase up to 32Gb. I'm planning to increase ...
1
vote
0answers
29 views

How to change permissions of Oracle generated logs?

The oracle generated logs (ie. alert and listener logs) are being created with 600 permissions. These files are of course created automatically by the oracle user. How would I change the permissions ...
0
votes
0answers
61 views

Physical memory usage of Oracle 11g

We are setting up a new server with Oracle database (Oracle 11g r2) for our ERP application. The new server is on VMWare, 256 GB RAM, 48 vCPUs, and SSD SAN storage (RAID 10) connected directly to the ...
0
votes
1answer
24 views

Getting TNS Name from connection string

I normally connect to my Oracle database at work using a connection string. Other then the obvious answer of asking the DBA what it is, using SQL Developer or some other tool can I find out what the ...
0
votes
0answers
24 views

When establishing access to data on a remote database, are views or synonyms preferred?

Consider a scenario where you have two databases: On database A you need to access data on database B. You could create a view on database A that selects from the table on database B. CREATE OR ...
0
votes
1answer
273 views

Not all variables bound ORA-01008: not all variables bound error

I am using Oracle SQL developer. I am running a query on employees table which is by default, having columns like first_name, last_name, employee_id, email, phone_no, hire_date, job_id, salary, ...
3
votes
1answer
51 views

Using MVIEWS to take in time data snapshot of tables

I have a requirement where I have to Load data periodically from more than 100 tables of an OLTP oracle database into MS SQL database. In my solution I want to use MVIEWs of these tables with Fast ...
0
votes
0answers
33 views

CPU usage high after os oracle password change

Oracle 11.2.0.4 Exadata (we're relatively new to exadata still) I had something strange happen this morning and the OS user oracle password expired. This meant that cronjobs wouldn't run was the ...
0
votes
1answer
26 views

Oracle 11g RAC - PSU

Simple question, when patching two nodes of 11g RDBMS, do I need to patch GRID as well, or only RDMBS is enough? Thank you in advance
1
vote
1answer
26 views

Oracle SQL 11gR2 => find out all dates where “impdp” was performed

Hello my team performed several database Data Pump Import "impdp" over the last two years. The workflow was always to import all "application" schemas ( The schemas that are used from our ...
0
votes
1answer
15 views

During table migration of tables from one tablespace to another, does it needs free space to do the alter table move?

During migration of tables from one tablespace to another (all datafiles in the same disk/partition/mount), does it needs free space to do the alter table move? exemple:. I have 30gb of free space on ...
0
votes
2answers
42 views

Moving tables to new tablespace needs temp space or any kind of addictional space? (Oracle 11g)

I've been trying to search for this info on oracle documents but they just don't talk about it. I need to move about 2TB of different tables from 3 different tablespaces to a new tablespace (...
0
votes
1answer
84 views

Using JOINS in QUERY clause in EXPDP

I have a par file that is using JOINS in QUERY clause. But it is not working. directory=expdp DUMPFILE=Test_SIT_Query_1table_%U.dmp encryption_password=oracle parallel=8 logfile=TEST_SIT_Query_table....
1
vote
2answers
73 views

Run shell script on Oracle 11g

I have an oracle database: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production "CORE 11.2.0.1.0 Production" TNS for Linux: Version 11.2.0.1.0 - ...
0
votes
1answer
58 views

Optimizer choosing a bad index

I have a pretty simple select statement, select column 4 from table_x where column1=:1 and column2=:2 and column3=:3 Columns 1,2 and 3 make up the primary key on the table. For some reason, ...
0
votes
0answers
62 views

How to manage Oracle diagnostics logs not managed by adrci?

How can I identify Oracle log files that are not managed by adrci? I wish to manage disk space usage, in a similar scenario to this article: "How to free up disk space? which logs/directories to ...
0
votes
0answers
16 views

Exporting Multiple, Multi Level BOMs using Bind Variables

I am trying to create a master export of all of our active Manufacturing BOM's. What I am hoping someone can help we with is how to combine these two queries so it will perform, loop? through the each ...
0
votes
0answers
57 views

Rman, Create two Incrementally Updating Backups

I am using the following rman (Oracle11gR2) commands to create an Incrementally Updating Backup Copy RUN { RECOVER COPY OF DATABASE WITH TAG 'incr_update; BACKUP INCREMENTAL LEVEL 1 FOR RECOVER ...
0
votes
3answers
231 views

How to grant user to dbms_crypto ?? Oracle (User which created inside SYSTEM)

Couldn't find user I tried this grant execute on sys.dbms_crypto to "DB_Project"; But error: ORA-00942: table or view does not exist 00942. 00000 - "table or view does not exist" Also tried this:...
0
votes
0answers
19 views

How many keys does wallet keystore have?

I my scenario I have configure transparent data encryption with password based software keystore only for example 'ewallet.p12' and create a master key for software keystore. I want to know can we ...
0
votes
1answer
30 views

Oracle Loop through values from one table and join with another table

I have a table (table1) with fields package_id and contract_id. Data in table 1 is like that 1 package_id can have 1 or more contract_id associated with it. I have another table (table2) with ...
0
votes
2answers
97 views

Welcome message for oracle schema

I want to display welcome message when ever a oracle schema try to login database using TOAD or PLSQL developer only