Stack Exchange Network

Stack Exchange network consists of 175 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.

0
votes
1answer
66 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
34 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
8 views

LDAP: Empty binddn“” and Authentication type becomes simple from none [migrated]

Am Developing an application in Spring MVC & JPA with Spring Security. Now Integrating the OUD (Oracle Unified Directory) through LDAP. While User authentication the response from the LDAP in OUD ...
0
votes
1answer
36 views

junior dba tasks [closed]

I started recently to manage several instances of oracle. I am new in the area of ​​dba, and I want to know what are the main tasks that I should pay attention to. Is there any guide for junior ...
0
votes
0answers
16 views

return same value from function although i change parameter [closed]

CREATE OR REPLACE FUNCTION GET_CONSULTANT_ID_MCH( CONSULTANT_ID_MCH IN NUMBER, YEARS IN VARCHAR2) RETURN NUMBER IS NO_CONSULT_MCH NUMBER; BEGIN SELECT COUNT(CONSULTANT_ID_MCH) ...
0
votes
0answers
14 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. ...
-1
votes
0answers
31 views

Is there any script for oracle listener to restart it

Is there any script that could restart listener when dedicated connections reach to more than 500? Best regards
0
votes
2answers
35 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
52 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
51 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
48 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
32 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
39 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') ...
0
votes
0answers
73 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
61 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
16 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
23 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
39 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
22 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
18 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
53 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
16 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
115 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
47 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
32 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
24 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
23 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
41 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
39 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
61 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
51 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
53 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
15 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
53 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
150 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
15 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
25 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
83 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
0
votes
1answer
26 views

Does tables under schema uses multiple tablespaces other than default tablespace

I have schema 'A' in a database and assigned a default tablespace as "myspace". There are 20 tables resides under single schema and all tables are using different tablespaces.Here my doubt is "Why ...
0
votes
0answers
31 views

Restrict Oracle database schema to login using Toad/PLSQL [duplicate]

I want to restrict my Oracle database schema for example john to login to database using tools like toad or PLSQL developer. this schema is used for application login using JDBC thin client. I cannot ...
0
votes
1answer
36 views

Why can i not call COUNT on a varray column in a select statement using oracle

I have a simple array type definition like this CREATE OR REPLACE TYPE "LIST_OF_NAMES_T" IS VARRAY(10) OF VARCHAR2 (100); Now I have a column items of type LIST_OF_NAMES_T in my table TABLE1 ...
0
votes
1answer
51 views

Oracle uses a lot of memory

OS: Windows Server 2012 DB: Oracle11g-r2 When you restart or turn on the server, everything works perfectly, the memory is normal, the number of sessions, too. But after 2-3 days of continuous ...
0
votes
0answers
126 views

os kernel parameter semmni failed: expected 128 found 0

I am trying to install Oracle 11gR2 on oracle linux 7. As per the documentation given in https://oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-7 there i think i have ...
-1
votes
1answer
54 views

Get the average of unique city to city distances [closed]

I tried to obtain the desired result with the following query: Select city1, city2, Avg(distance) from table group by city1, city2; ...but this SQL statement is resulting ...
0
votes
2answers
314 views

Select the oldest records in a table in Oracle [closed]

please, how can I select the oldest records in a table in oracle? and if it is possible to show them by date. Thank you
1
vote
2answers
71 views

How to copy database schema in the same database for testing purposes?

I need to copy... by any means, a schema of my database in that same database, let's say, I have SC1 and I have to duplicate it as SC2 without the data contained in SC1 (in the same database). How ...
0
votes
1answer
175 views

utlrp.sql fails to execute

I just created a docker image of Oracle 11g ee following this tutorial https://vitalflux.com/how-to-install-oracle-11g-ee-on-docker/ and loaded some tables inside. The process worked fine and no ...
1
vote
1answer
98 views

Unlock user shell script for Oracle

We have so many user ID locks from the front-end users. We need to provide a shell script to the user which they can run on OS level and unlock the ID themselves when the DBA is not present. The sys ...