Questions tagged [oracle]

Oracle is a relational DBMS (Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Most questions about Oracle are better placed at the sister site https://dba.stackexchange.com/

168 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
7
votes
2answers
7k views

Oracle 10g for Windows does not start up on system boot

We have an Oracle 10g Enterprise Edition installation (10.2.0.1.0) on a Windows Server 2003 virtual machine. It was initially created with Virtual Server 2005 R2 SP1 but has now been migrated to ...
3
votes
1answer
4k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
2
votes
0answers
86 views

ipnat.conf rdr won't work solaris 10

I'm currently trying to achieve the following from the ipnat.conf configuration file on solaris 10: I need my server to act like proxy between two specific hosts (with specific ports). Lets say hostA ...
2
votes
0answers
161 views

Self-extracting executable not extracting other archives

** Problem We are attempting to run a self-extracting executable (SFX) to install an Oracle product, Oracle Enterprise Manager 13.2. The installation starts, works for a short while, and then quits, ...
2
votes
1answer
153 views

RHEL 5.8 [Oracle] too long to shutdown

We are using Oracle database on a machine running RHEL 5.8. Every month we restart our servers (including this one) however this one takes too long to shutdown. Last time took it 40 minutes. This was ...
2
votes
0answers
935 views

Upgrading to Java 7u65 breaks my Deployment Rule Set for Oracle applications

My company uses an older version of an Oracle application that requires Java 6u45. Naturally we want to be secure, so we use a Deployment Rule Set to specify 6u45 for that internal application and let ...
2
votes
0answers
533 views

doing ODBC System DSN's from Active Directory

2008R2 Active Directory, workstations are Win7 Ent, Office/Excel 2013, Oracle 11.2. Excel fetches data from Oracle using System DSN's. Where can I put ODBC System DSN's in Active Directory? Do I ...
2
votes
0answers
1k views

What would cause RMAN backups over NFS to kill SAN performance?

I've been trying to figure out this problem for several weeks now, we are using an Exadata that runs nightly RMAN jobs to backup the database to a NFS mount. When these jobs occur, the average latency ...
2
votes
0answers
498 views

MICR check printing through Linux (EBS)

We are currently working to get a new MICR check printer (Troy Micr - HP Laserjet 600 M601) printing correctly with Oracle EBS. Our EBS installation runs on Oracle Enterprise Linux (Redhat Based). The ...
2
votes
0answers
528 views

Dtrace Oracle show high fsflush on solaris 10

Solaris 10 - Oracle 11G in a zone Running mpstat , i've noticed that one CPU was at 100% used every 5 seconds for 5 seconds while all other CPU were fine, in used but nicely spread. 1 0 0 0 ...
2
votes
1answer
505 views

How to configure multipath using Intel X520-SR2 10GB on Oracle Linux 6.2?

I've installed the Intel x520-sr2 Ethernet/Fibre card into a server that has Oracle Linux 6.2 Installed on it. When I boot the server I can go into a QLogic menu (screen has something for Intel on ...
2
votes
2answers
165 views

Linux OEL 6x - Compatibility with ACL

Will the ACL [ Access control lists like getfacl, setfacl ] utility work fine with OEL 6x? It works great with Solaris 5.9 but not sure OEL 6x will support ACL utilities
2
votes
0answers
514 views

Oracle concurrent programming execution methods

I created a package and a stored procedure under it to test a concurrent program. When I run it as an Oracle report executable method it works fine. But when I change it to PL/SQL stored procedure ...
2
votes
0answers
4k views

Oracle 11g R2 Install Guide

I have a need to install Oracle 11g R2 on Windows Server 2008 R2. I have downloaded the two files from Oracle (win64_11gR2_database) and the client (win64_11gR2_client). Does anyone have a guide or ...
2
votes
1answer
4k views

How do I configure in IBM WebSphere 8.5.5 a data source using Oracle Wallet?

I have a server with a fresh installation of WebSphere Application Server 8.5.5 and I'm trying to configure a data source over a connection using JDBC and Oracle Wallet for SSL. The error message in ...
2
votes
2answers
772 views

Oracle RAC failover backup procedure

We have Oracle 11gR2 RAC database on two nodes. We also have a RMAN backup script that works fine, using a recovery catalog database which is located in a town 20km from the data center. The script ...
2
votes
1answer
241 views

Exit sqlplus on error but not warning

We have a script that deploys code to our database as part of our application deployments. Currently, if a view or package errors, it ignores that error and moves on. We want it to fail at that point ...
1
vote
1answer
261 views

ICMP ping fine but tnsping timeout to oracle

We have Oracle running on a Windows server and a couple of Linux clients. Windows clients work just fine. However, running tnsping on a Linux (running RHEL 6.9) client has an interesting issue. Take ...
1
vote
0answers
125 views

Oracle reports SMTP change

We recently migrated our SMTP address from smtp.old.example to smtp.new.example, this caused our Oracle reports server to stop sending emails which was expected. I have updated the <pluginParam ...
1
vote
0answers
32 views

How to authenticate a Linux User against Oracle Windows NTS?

We are using NTS for our Oracle Windows on a Windows Server 2016. Adding domain users to the ora_dba group works if we want to connect remotely as System Administrator. But is it possible to ...
1
vote
1answer
237 views

Installing Solaris 10 on Sun oracle SPARC Enterprise T5220 and Sun oracle SPARC T4-1 server

I m newbie to sever environment.I got old Solaris 5.10 already installed following severs Sun oracle SPARC Enterprise T5220 Sun oracle SPARC T4-1 server It does not show BIOS loading ,when it is ...
1
vote
0answers
329 views

ORA-12541: TNS:no listener

Here is the situation: I have a computer(let's call it server PC, whose IP is 192.168.1.100) that has ORACLE installed on it. I can access the data in oracle using Python on this server PC(This means ...
1
vote
3answers
3k views

How set Oracle Weblogic oraInventory location?

I've downloaded Weblogic Quick Installer from Oracles site (http://www.oracle.com/technetwork/middleware/weblogic/downloads/index.html). I've set ORACLE_BASE and ORACLE_HOME to directories with write ...
1
vote
0answers
481 views

Can I install oracle linux or debian in Sun enterprise m4000 sparc?

I would like to install a linux OS on this server but after trial and error always came back with a error, i know that the installation is fully compatible with SPARC architecture, every time i used ...
1
vote
0answers
295 views

After some minutes oracle database is down, but listener still active

I installed Oracle 12c R2 on my fedora 24 server. Before its updates and the last upgrade to fedora 26 it was running ok, but then neither the listener nor the database can be bringed up. After some ...
1
vote
0answers
456 views

Unable to use expdp over database link

I'm trying to use Oracle's expdp to export a remote schema using a database link. I think the database link works fine, since I can execute select queries through it. When I try to execute expdp, I ...
1
vote
0answers
114 views

Resolving FIPS Compliance Issues with Oracle 11g

Problem I am working with Oracle DB 11g (11.2.0.4.0 - 64bit), Jenkins, Windows PowerShell plugin, and VsTestRunner plugin to automate running unit tests. While setting this up I stumbled upon a huge ...
1
vote
1answer
2k views

How to configure Oracle client to automatically lookup connection strings via LDAP/OID?

I wish to connect to an Oracle database using LDAP for connection string lookup. LDAP/OID is already setup, and manually using the connection string retrieved from LDAP works. However, the automatic ...
1
vote
0answers
807 views

mount a windows folder in solaris 11.3

I want to check a folder which is placed in a windows server by my Oracle RDBMS12C. therefore based on my research first I need to mount the windows folder in solaris 11.3. we are using spark server. ...
1
vote
1answer
367 views

JDBC Oracle 12 allow jdbc outgoing traffic in firewalld

I'm installing an application which needs an Oracle DB on my server. The DB is hosted on another dedicated server. The application is using JDBC to connect to the DB. I have tested the connection ...
1
vote
0answers
370 views

Registering oracle 10g db with 12c grid

Hi I have oracle grid infrastructure 12c installed for stand alone server and I'm trying to register oracle database 10g with CRS, but I suspect there was syntax change because srvctl fails when ...
1
vote
0answers
168 views

Oracle Cloud data service with Applications on AWS?

We're deploying an application that uses Oracle as the database backend, and as the application is deployed in AWS, we use AWS RDS for the Oracle database - and we have a lot of problems with that, as ...
1
vote
0answers
43 views

Limiting Oracle instances resources with Cgroups?

Is it possible to limit the amount of resources (I/O, CPU and Memory) a Oracle instance can consume using only cgroups? (no containers or virtualization) The reason I wanna do that is because I want ...
1
vote
1answer
2k views

Weblogic server hangs when “Creating data source connection pool named”

I have just installed Weblogic version 10.3.6.0 and created a data source which connects to MSSQL on my localhost. I have tested my connection and verified that a successful connection can be made ...
1
vote
0answers
384 views

How to use java UDF on AWS Oracle RDS?

I am trying to use a java udf in AWS Oracle RDS. On a managed Oracle server I can do this by using something like the following: CALL dbms_java.loadjava('-user <username>/<password> /home/...
1
vote
0answers
167 views

Oracle Linux hangs on Hyper-V

I am trying to install Oracle Linux 7.0 on Hyper-V. While I click through the GUI installer the system stops responding. The mouse cursor stays in the same place. It happened to me a few times, ...
1
vote
2answers
3k views

Powershell execute Queries using SQLPLUS

I have a RHEL server with Oracle 10G installed. I need to write a powershell script to query my database and get the output. I have imported Posh-SSH module and am able to connect to my RHEL server ...
1
vote
1answer
868 views

Creating javaroles in Oracle 11g XE

I have installed Oracle 11g Express Edition in my system.I want to create user who has got the role javauserpriv. After creating the user I ran the following command grant javauserpriv to dbuser(new ...
1
vote
0answers
62 views

Axis DMsuite RESTful API

I'm looking at Axis DMsuite for masking Oracle databases. I was told by their staff that they exposed some simple REST endpoints for triggering masking jobs, but I have done a fair bit of searching ...
1
vote
2answers
627 views

How to crash Oracle VM intentionally by loading system parameters

I am using Oracle VM. I want to perform a stress test on system parameters like CPU, RAM etc. Can anyone help me out with the ways in which I can load the parameters with high load like using all the ...
1
vote
1answer
1k views

Unable to connect to Oracle database from certain client machines

I have an application that connects to an Oracle database that works fine in development on any development machine I can find but falls over with the following error when being ran from a production ...
1
vote
1answer
4k views

Unable to convert JKS keystore to Oracle Wallet using orapki

I have generated jks keystore using keytool and using the jks keystore I have csr. The same csr I have sent to Signing authority. The Signing authority have given the trusted certificates(root,...
1
vote
0answers
344 views

Oracle 6.5: MySQL Daemon failed to start

I installed MySQL by following these instructions on my Oracle Linux Server release 6.5, specifically using the yum package installer command, yum install mysql mysql-server mysql-libs mysql-server ...
1
vote
0answers
93 views

Oracle Identity Manager and Microsoft Read-Only Domain Controllers

Is Oracle Identity Management 11g (OID) compatible with Microsoft Active Directory Read-Only Domain Controllers? (RODC) My setup has OID importing users from AD RODC. Is this configuration supported?...
1
vote
0answers
5k views

Username/password for Oracle Linux 5.8 VirtualMachine

I have the Oracle Linux 5 ova (converted to VirtualBox). The documentation I have seen mentions using either root/oracle or oracle/oracle to login. However that is not working. Any references/...
1
vote
0answers
89 views

Export data from Oracle Lite 10gR1 odb file

I hope you can help me with this one. Years ago (2005) someone way before me set up a server with WinXP and a custom-written Java/Tomcat-whatever application for monitoring some sensors, the database ...
1
vote
1answer
182 views

LSI 3042 supported with Oracle VM Server

Trying to install an HP DL165 1U server with an LSI 3042 SAS card. I get to the install, selected a language, select a keyboard screens then it asks me for a location for the driver (it doesn't tell ...
1
vote
2answers
4k views

Can't start WebLogic admin console

I'm wondering how to fix this error. We had the wrong Java installed on my machine when I got it, so my boss installed JRocket to fix things. WebLogic has been having problems ever since. I cannot ...
1
vote
0answers
1k views

SSD Performance under Oracle

I have serious performance issues with oracle running over ssd. I have two OCZ Vertex 3 MAX IOPS drives (firmware 2.15). It runs on a INTEL C600 SATA Chipset. Windows 2008 R2. So the issue is ...
1
vote
0answers
155 views

iPlanet Authentication provider

Good day. I have stepped into project that requires a server migration that would change the means of authentication for our CAC/PKI SSL enabled website. We are using iPlanet 7 and Oracle Directory ...