Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [oracle-11g-r2]

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

1
vote
1answer
17 views

Error while installing Oracle 11g in Ubuntu 18.04

Also getting a runfixup.sh script which is also giving error root@szh-server:/tmp/CVU_11.2.0.1.0_zuman# ./runfixup.sh Response file being used is :./fixup.response Enable file being used is :./fixup....
0
votes
3answers
46 views

Database Migration [on hold]

We are migrating our one of testing servers. My questions are: What is a best way to migrate database from one server to another? If I do data migration through export/import utility (Full database ...
0
votes
2answers
24 views

Safe to use SQLNET.ALLOWED_LOGON_VERSION_SERVER in 11g sqlnet.ora file?

I have a mixed environment running both 11g and 12c databases on the same server. One of our databases was recently upgraded to 12c, and the older Oracle clients have started throwing ORA-28040 ...
0
votes
1answer
21 views

Always start Oracle DB in Idle State

Is there a way to setup your Oracle db to always be brought up in an idle state so that you can then 'startup' when you want to use it. I'm running Oracle 11g R2 on Windows with lean resources.
2
votes
1answer
26 views

How to copy a tablespace to another database without using Data Pump in Oracle 11G

I have a database on a legacy system that has some data that needs to be exported to another environment. Everything I need is contained in one tablespace. Unfortunately, I am unable to use Data Pump ...
0
votes
0answers
37 views

Move expdp part file before job end

I have an Oracle 11gr2 database running on Enterprise Linux 6.6 server. I use the following command to split the expdp dump file to 10G size chunks: expdp userid=/ DIRECTORY=dmpdir dumpfile=dump%u....
0
votes
0answers
21 views

Update RMAN Transportable Tablespace

I'm doing a RMAN Transportable Tablespace like this: TRANSPORT TABLESPACE fsdata, fsindex TABLESPACE DESTINATION '/u01/app/oracle/admin/orcl/rman_transdest' AUXILIARY DESTINATION '/u01/app/oracle/...
-1
votes
2answers
61 views

Creating Dictionary Management Tablespace Oracle [closed]

i am stuck at creating a dictionary management tablespace in 11g Release 2 Oracle 32 bit , I can't create a normal tablespace with dictionary management because my System tablespace is locally ...
0
votes
1answer
34 views

In a database trigger on event create - How do I reference the created object?

Given the following trigger: CREATE OR REPLACE TRIGGER TRG_CREATE_TABLE_INITRANS AFTER CREATE ON SCHEMA BEGIN IF SYS.DICTIONARY_OBJ_TYPE = 'TABLE' THEN exec 'alter table '||<table_owner&...
3
votes
1answer
129 views

How do I restore an Oracle file system backup onto a new developer machine?

A server (not mine) has died due motherboard temperature problems and disk controller problems. Given that the company's IT support should have known better, and so on, the company does have a file ...
1
vote
0answers
26 views

Deployed application (Oracle 11g, VB.NET 2015 and Crystal Reports) cannot connect to database

I'm developing an application using Oracle 11g, VB.NET 2015 and Crystal Reports on Windows 10. I created a package and installed it on another PC on same network. The package is running fine but ...
2
votes
2answers
100 views

How can to make a new user see table in existing schema [closed]

I'm new into Oracle so this question might be dumb. I created new user and now I would like him to see table (or even better all tables by one command) in already existing schema (hr schema in this ...
1
vote
2answers
33 views

How to configure Oracle11g to send out Password Expiry Notifications vide SMS or e-mail?

Please guide me in configuring Oracle11g to send out Password Expiry Notifications vide SMS or e-mail before password expiry of one week or upon user's profile entering into grace period or any other ...
0
votes
1answer
36 views

Is it feasible to escape ' (single quote) with ESCAPE clause, if yes, then how to do it?

I understand that we can use '' to escape a single quote in Oracle queries. However, I want to know if it is feasible to escape a single quote in the ESCAPE clause. set up: create table test_t ( x ...
1
vote
1answer
26 views

Oracle 11g - DROP database command on ACFS

In Oracle 11g and higher (on RHEL 6) issuing the 'drop database' command in mount restrict mode will delete all the DB's ASM datafiles. Can somebody tell me if this command also drops all ACFS ...
0
votes
1answer
62 views

How to execute sqlplus by root using sudo in linux?

Scenario: *oracle xe11g r2 is installed( and runs properly when logged in as oracle). *logged in as user, root *added root to groups oinstall and dba as follows: #useradd -G oinstall root #useradd -...
-1
votes
1answer
23 views

How to export response file from already installed Oracle database?

I know that I can follow the steps of Oracle Universal Installer (OUI) and choose to save a response file at the end (summary step) to use it in further silent installation, but is there a way to ...
1
vote
1answer
64 views

How to refresh Oracle data dictionary to remove deleted tablespace and datafiles?

Long story short we have a server with two Oracle instances running on it: ora1 and ora2. Somebody defined an undo tablespace for ora2 and provided the same datafile of the undo tablespace datafile of ...
0
votes
0answers
51 views

39001. 00000 - “invalid argument value” error using DBMS_DATAPUMP.add_file

I been trying to use the Oracle Data Pump PL/SQL API to move data to AWS Oracle RDS. My export job is failing on my local installation of oracle database. Local database is 12c and RDS is 11g. I been ...
0
votes
1answer
25 views

How to run EM of Oracle 11g, if i haven't emctl, netmgr, dbca, OracleDBConsole<SID>?

I don't know what is wrong with my Oracle 11g, but it is missing a lot of things. After reinstallation it stays the same. My overall path is like C:\oraclexe\app\oracle and after it there are folders ...
0
votes
0answers
31 views

Select only columns/fields where value is not null

I run the following SQL query SELECT * FROM emer_comp WHERE primaryKeyColumn = 'givenValue'; This way I can see all fields values corresponding to that row. However, this table has many fields that ...
0
votes
1answer
34 views

How to delete a datafile if the father-tablespace does not exists? [closed]

I just know Oracle basic and I would like to know about the datafiles. I have some files ".dbf" associated with Tablespace that already were deleted. I don't know how I can drop that datafiles and ...
0
votes
2answers
96 views

How to export dump of some schemas exclude some tables

I need to find the way make an quick and light weight dump export. It is the reason why I want to export only specific scheme and to exclude large tables. I use Enterprise Manager for it. Data ...
1
vote
1answer
73 views

SELECT all the children of a row and concat

I have this requirement that I need to attach a new column in select statement. It holds a string series of the disp_order of its children. I currently have the SQL statement only for the immediate ...
0
votes
0answers
13 views

How works the flash recovery area

Im working with QGIS and Im trying to save a Mapinfo map to Oracle Spatial. The map file is around 1GB and has 700k road segment. The issue is when copy the segements from the source map to the db ...
0
votes
1answer
46 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
1answer
63 views

ASM Space Usage

Oracle Version: 12.1.0.2 I had about 100 GB freespace on my +ASM diskgroup on Friday. When I came back on Monday, I see only 45 gigs. How can I find what consumed my space? Or is there a SQLPlus ...
0
votes
0answers
87 views

TNS-01153 : Failed to Process the String

I changed IP Server address which installed Oracle 11g on windows server. But my listener service has not worked so I can't access from the remote. Below are my listener.ora # listener.ora Network ...
0
votes
1answer
34 views

program column is null in v$session

CREATE OR REPLACE TRIGGER AWH_TOOLS_TRG AFTER LOGON ON HRMS.SCHEMA DECLARE v_prog sys.v_$session.program%TYPE; v_pro varchar2(250); BEGIN SELECT upper(program) INTO v_prog FROM sys.v_$session WHERE ...
0
votes
1answer
113 views

Oracle convert multiple rows to column using pivot

I have a table that contains the values +-------------+--------------+---------------------+-------------+-------------+--------------+-------+---------+-----------+---------------+--------------+ |...
0
votes
1answer
21 views

Migrating Oracle Views to SQL Server

In the process of retiring an Oracle 11g host for an HRIS database, I've been asked to migrate as many assets as possible to a SQL Server 2016 instance for read-only archival. The volume of table ...
1
vote
1answer
88 views

Error granting SELECT on view that uses ALL_OBJECTS

I'm in the middle of testing Oracle 12c for our application. I have something similar to this view in a particular schema, which we'll call MY_OWNER_SCHEMA for this question: CREATE OR REPLACE VIEW ...
0
votes
1answer
23 views

Question about alerts in Oracle 11.2

I inherited an Oracle 11.2 server. I wanted to see if whomever configured it before me had any alerts configured, perhaps to notify on audit events. Logging on as sysdba, I issued this command per ...
0
votes
0answers
61 views

Error while importing database using impdp Oracle 11g

While importing the database using impdp I saw this in the log file . Cannot set an SCN larger than the current SCN. If a Streams Capture configuration was imported then the Apply that processes the ...
0
votes
0answers
34 views

Problems with SQL Loader Discarded Null or Blank Column

Hello Guys I need help I need to treat a field that be on blank or null with SQL Loader, but I'm having problem about this because the SQL Loader discarded columns on BLANK or NULL, so a tried that ...
0
votes
1answer
21 views

Scrambling PII data in CLOB columns

I am working on scrambling PII tags in CLOB columns such as <FirstName> or <LastName> or <SSN_Number>. so I am using the below query to achieve the same. UPDATE /*+PARALLEL(8)*/ ...
1
vote
1answer
39 views

Oracle table transfer between databases in two different hosts

I have a 500Gb table which I need to transfer to another Oracle database in another remote host. I have a 10 Megabits/sec speed connection between two hosts. What can be the most efficient way to ...
0
votes
1answer
183 views

ORA-39001: ORA-39000: ORA-31640: ORA-27041: and Linux-x86_64 Error: 13: Permission denied [closed]

I used this command to export data: expdp gsw/password DIRECTORY=gsw DUMPFILE=gsw.dmp logfile=gsw.log SCHEMAS=GSW Now importing this to other server as: [root@linux gsw]# impdp gsw/password ...
1
vote
2answers
48 views

Masking PII columns in Oracle

I am using Oracle 11g R2 on Linux, and I have multiple tables in my database that has got columns that needs to be masked. I have tried the OEM to mask the data as mentioned in the below hyperlink, ...
0
votes
1answer
40 views

Dealing with Oracle ARCHIVELOG during huge updates

It's required to update columns with metadata globally in all rows of all tables in DB. Let's say every table has a column MY_META and the aim is roughly update ANOTHER_TABLE set MY_META = 'HELLO' ...
0
votes
0answers
212 views

Prevention of ORA-01555: snapshot too old: rollback segment number with name “” too small

We have a cashier system relying on Oracle databases for data storage. Any time connection to the database abruptly goes down (for example due to the store being out of power and UPS not working ...
0
votes
1answer
48 views

Creating an insert trigger on views

My table definitions look like this: I've created a view as: users_questions(qid,username,question) I want to create an instead of trigger on the view which puts the data going to be inserted on ...
0
votes
2answers
86 views

How to improve SELECT performance on a big ORACLE view? [closed]

I cannot use a materialized view for the base table data changed frequently. There are about 0.6 million rows in the_big_view. The query I need to do is: SELECT * FROM the_big_view WHERE ...
0
votes
0answers
25 views

Migrating Oracle 11G Fail Safe to new hardware? Multiple Cluster Nodes

We have a 11G 2 Node Active \ Passive Failover configuration that we want to move to new hardware. Is it possible to have 4 nodes running temporarily while we move everything over? I.E. 1 Active and ...
0
votes
0answers
115 views

Oracle db crashes with ora-00822

I've restored database to another host, backup of production db was restored to our testing environment to provide actual data. And it looked like everything is fine, users switched to new db and ...
1
vote
1answer
47 views

Reclaim Database Wasted Space

In our company we have a test server on which Oracle RDBMS 11g is installed. My question is related to reclaiming wasted space. I ran the following query: select table_name,round((blocks*8),2) "...
1
vote
0answers
155 views

SAP Oracle Full Online Backup Failing

we have a SAP instance that runs on Oracle 11.2.0.4.0 DB. Since a while full online backups are failing every time. Full online backups are scheduled in SAP tcode DB13 (or DBACOCKPIT) and use BR*Tools ...
0
votes
0answers
15 views

How to link two Oracle servers

I am using two oracle servers. One is server A(local oracle server) and server B(remote oracle server). Note: Installed Oracle version is 11.2.0 Requirement I need to link server A and server B. I ...
0
votes
1answer
809 views

Swap utilization is high in oralce

How to reduce swap utilization in linux server which have running oracle 11g2 Server. currently is shows above 80 % in enterprise manager so how to identify the which process uses swap memory in ...
1
vote
0answers
27 views

How to keep only those archivelogs that are created after a latest db backup in oracle 11g?

I am little confused with oracle db backup. I have configured my Oracle 11G DB with ARCHIVELOG in Fast Recovery Area (NFS mount). I only need latest backup to restore in case of failure, but no point-...