All Questions

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

Oracle restore to a differnet drive

I have the following script for rman to backup the main database and archive logs: connect target sysdba/password@localhost/db run { allocate channel d1 type disk; crosscheck archivelog all; delete ...
0
votes
1answer
19 views

RMAN - 01009 Error in Oracle 11gR2 [closed]

When I want to copy-paste this script: RUN { SET NEWNAME FOR DATAFILE 1 TO '/u05/NEWDB/app/oracle/oradata/FBDB/system01.dbf'; SET NEWNAME FOR DATAFILE 2 TO '/u05/NEWDB/app/oracle/oradata/FBDB/...
0
votes
1answer
34 views

What could possibly cause a numeric overflow when enqueuing an Oracle AQ message?

We create and enqueue messages with various properties, like this: message := sys.aq$_jms_message.construct(0); message.set_string_property('a', v_a)); ...
0
votes
2answers
54 views

CSSCAN for the character set change, database version 11.2.0.3.0

According to Document 745809.1, Installing Csscan. While running the "Csminst.sql" we are getting below error SQL> @$ORACLE_HOME/rdbms/admin/csminst.sql create user csmig identified by csmig ...
0
votes
1answer
31 views

RMAN log file with date and name in Oracle 11gR2 in Linux

I have a script and I want to create my log file with datetime and with unique name. It's my script: ....... ....... rman target/ LOG='/u01/backup/logs/rman.log' <<EOF ....... ....... ....... ...
0
votes
1answer
29 views

Using of delete obsolete in Oracle 11gR2 RMAN on Linux

I'm using crontab for automatic backup (full backup). It works 2 times in a day (8 AM and 23 PM). In my script I use delete obsolete but I have a question. I want to delete old backups without last 2 ...
0
votes
1answer
47 views

Oracle 11gR2 can I delete datafiles to reduce tablespace?

I have the following doubt, maybe a little silly, if I have a tablespace for example TBS_MYDATA of 155 GB, this tablespace is composed of 5 datafiles of 31GB each, in turn, each of these datafiles ...
0
votes
1answer
42 views

How To Create A New bash_profile And Connect New Database To It In Oracle [closed]

OS -> Linux DB -> Oracle 11gR2 Normally my .bash_profile file looks like this: TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=abcde.localdomain; export ORACLE_HOSTNAME ...
1
vote
1answer
41 views

Patching after upgrade (windows 11gr2 -> 12cR2)

I have a following scenario where I had a patched oracle 11gR2 DB (applied Windows Bundle and OJVM patches) and then it was upgrade to Oracle 12cR2. 12cR2 was a clean installation (no patches applied, ...
1
vote
1answer
31 views

Oracle Database 11g Failing to mount on windows server 2012

I have an Oracle 11g database installed on Windows Server 2012. It's failing to mount after shutdown. The reason why i want to mount it is that i want to enable Archive log mode, and i have been able ...
0
votes
0answers
74 views

Export SCHEMAS and TABLES at the same time

My task is export schemas sch1, sch2 Also need to export tablespaces ts88, ts89 from schema sch3 How can I do it as one operation? Because, if I run different operations : DIRECTORY=dir ...
1
vote
1answer
102 views

Help needed to tidy up deprecated (and mal-functioning) SQL code [closed]

I'm connected to an Oracle Database (11g Release 2 - 11.2.0.4). I've inherited a chunk of SQL which apparently uses quite a lot of deprecated stuff and, importantly, "sometimes" yields wrong results (...
-1
votes
1answer
33 views

Adding columns for group by result values in oracle

Lets say my table like this and the table name is Employee. Employee ID Name Age 1 Dilshan 22 2 Udara 25 3 ...
1
vote
1answer
84 views

Managing AUD$ without DBMS_AUDIT_MGMT

I have a SYSTEM's table AUD$ where AUDIT records are stored. My AUDIT_TRAIL is set to DB,EXTENDED. I am on Oracle DB version 12c (12.2.0.1.0). With time (in 3 years) my AUD$ table grew to 500GB in ...
0
votes
2answers
448 views

Error During IMPDP in oracle database 12c

I create Dump file with EXPDP command in oracle database 11gR2 with operating system Oracle Linux 6.7 EXPDP Command: expdp hmis/pass directory=MY_DATA_PUMP_DIR dumpfile=12c_db.dmp logfile=12c_db.log ...
0
votes
0answers
25 views

Search string into dbms_xplan.display_awr output

I want to search into the result of this query. Select cursor(select * from table(dbms_xplan.display_awr(sql_id, plan_hash_value,null,'all +outline +peeked_binds'))) "PLAN" from gv$sql where ...
1
vote
1answer
45 views

Oracle 11g alternative options for oracle 12c with function

I am using (with function) in Oracle 12c. in 11g this is not available. Is there any other way we can implement with function in 11g? with function x(p_NUM in number) return number is n ...
0
votes
0answers
47 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
47 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
76 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
139 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
24 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 ...
0
votes
0answers
76 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 ...
1
vote
2answers
130 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
68 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
96 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
37 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
52 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
165 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
41 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
2answers
44 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
360 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
55 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
2answers
39 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
348 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
718 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
96 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
1answer
84 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
27 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 ...
0
votes
0answers
81 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
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
1k 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
63 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
31 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
34 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
16 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
45 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
170 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....