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/

Filter by
Sorted by
Tagged with
0
votes
0answers
18 views

Oracle Database systemd service: ORA-01031: insufficient privileges

I'm having troubles starting an oracle database with systemd. The start and stop script was created in /home/oracle/scripts/ oracledbstart.sh: #!/bin/bash export ORACLE_HOME=/opt/oracle/product/11.2.0....
12
votes
5answers
77k views

Installing Oracle 32bit and 64bit client on the same machine

So I need to have both the 32bit and 64bit clients for Oracle 11g coexist on the same machine. I have installed both together before, but there are many issues where applications that need to use the ...
0
votes
0answers
31 views

Accidentally turned my RHEL installation into an Oracle one. How do I change it back?

I successfully managed to install an Oracle database on my server (if such I thing should be considered a success). However, the way I did it had the unfortunate side-effect of making lsb_release ...
0
votes
2answers
2k views

How do I set up Weblogic 12c on Windows to start the http server on boot?

Windows 2008 server, Weblogic 12c. I have a pretty simple setup using nodemanager. My problem is that our webhost likes to patch and reboot the server without telling us, and the HTTP server doesn't ...
0
votes
1answer
1k views

ERROR: Not enough space?

Now this is a very unspecific question. I'm trying to figure out what this message would mean. Here is the story behind it: I'm installing Oracle enterprise manager cloud control (12c r3) on Solaris ...
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 ...
-2
votes
0answers
16 views

Sun Oracle X3-2L Server How to firmware Update?

I am using / trying oracle x3-2l server but firmware update not find files. I can't using oracle support. How to firmware files download and updated? Please help me.
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
1answer
143 views

xRDP fails on Ubuntu Server 20.04 in Oracle Cloud VM instance and ubuntu-desktop installed

I am running into a problem where xRDP fails to respond to any RDP requests sent to a VM instance running in OCP under Ubuntu Server 20.04 with GNOME GUI installed (via sudo tasksel install ubuntu-...
0
votes
0answers
13 views

Oracle12c standard edition SNMP monitoring

I have Oracle12c "standard" edition database running. I would like to enable SNMP to monitor this database. All the documentation I found so far pointing that I need "enterprise edition&...
0
votes
1answer
1k views

Recieving ORA-12560: TNS:protocol adapter error on classic ASP same connection in .net works

I have 2 different application installed on a windows 2008 one is .net the other is classic ASP. They would be connecting two different databases however to help trouble shoot the issue I have both ...
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
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 ...
0
votes
1answer
44 views

Connect Oracle Autonomous Database in Microsoft Azure Data Factory

Anyone in here have already connected Oracle Autonomous DB in Azure Data Factory? We are trying to implement some data copies from SQL Server to Oracle, but I am not able to reach Oracle Autonomous ...
0
votes
2answers
2k views

Escape all characters that shell or sqlplus need escaped in any password given

You may try for yourself by creating this user: CREATE USER "karl" IDENTIFIED BY "/?'!@#$%^&*()_+=-~`" (Maybe there are other symbols I should have included for my testing, but that seemed ...
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 ...
0
votes
1answer
67 views

Integration of Azure with Oracle Cloud Infrastructure (OCI) ORA-03113: end-of-file on communication channel

I'm trying to integrate Azure and OCI using this approach and this article. Now, I have the infrastructure up and running. It consists of a VM in Azure, an Autonomous Database (ATP) Oracle Cloud ...
0
votes
1answer
1k views

Exception thrown when trying to access a web service (Weblogic) - java.lang.LinkageError

I've installed Adobe LiveCycle for Weblogic 10.3.4, and when I try to access one of the web services it deployed, I'm getting the following exception: Exception - java.lang.LinkageError: loader ...
0
votes
1answer
2k views

Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history

Is it possible to migrate Oracle SOA BPEL instances from one environment to another with history? For instance, I want to move from BPEL instances deployed to defined partition on Oracle SOA to ...
0
votes
1answer
13 views

Oracle Database Realtime Sync

Client is using Oracle Database Standard Edition so Active Data guard feature is not available and he wants to have a standby replica of the database which can take over the environment as soon as the ...
0
votes
0answers
118 views

Connection timed out (FRM-92103) with Oracle Forms 11g on Azure Windows Virtual Machine

We are running an Oracle database 19c with Oracle Forms 11g on Azure Windows VM. Our config is as follows: Azure Windows Virtual Machine Standard B4ms (4 vcpus, 16 GiB memory) Public IP address with ...
2
votes
1answer
105 views

Connection issue (ORA-03135) with Oracle database on Azure Windows Virtual Machine

We are running an Oracle 19c database on Azure Windows VM. Our config is as follows: Azure Windows Virtual Machine Standard B4ms (4 vcpus, 16 GiB memory) Public IP address with an "idle timeout&...
0
votes
1answer
28 views

oracle em does not show any administrations options

I want to try some administration tasks on the new version (19) of Oracle database like add a new user or edit user rights on the em. So I downloaded the oracle vm. I tried to connect to oracle ...
0
votes
0answers
12 views

how to deploy multiple oracle db scripts using jenkins

I have just started using Jenkins and would like to implement as mentioned below - I want to pass directory name to shell script and then execute all .sql scripts inside that directory using jenkins. ...
0
votes
1answer
3k views

Oracle 11g MTS install fails with error: OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull

Is there a workaround in the Oracle 11g Universal Installer for the following error? OUI - 10150: Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull in component oracle ...
1
vote
1answer
2k views

One Way Replication of Oracle 11g to MSSQL 2008R2

We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS. What is a good method to automate a one-way, read-only ...
-2
votes
1answer
35 views

From ZFS Array CLI how to get the latest snapshot for share

from ZFS Array cli how to get the latest snapshot for share. my share name is "test_share" for this share want to check the latest snapshot. Test-ae0101zfs201:shares test_proj_test/...
1
vote
2answers
6k views

yum Cannot open: oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm. Skipping

I am following this article on installing the oracle client RPMs on a CentOs 6.x server using yum localinstall.for some reason yum cannot open the RPMs - and I am at a loss as to what the next step ...
0
votes
0answers
158 views

nginx reverse proxy to Oracle ORDS/APEX - how are cookies set?

Using nginx to reverse proxy to Oracle's "Always Free Tier" in Autonomous Database which provides ORDS which connects to APEX in the database. Mainly because Oracle doesn't support vanity ...
0
votes
0answers
57 views

windows 10 installing oracle client 12c, 18c or 19c hanging at step 4

I am trying to install Oracle Client version 12c, 18c or 19c. I have tried both of the installers, and once I perform prerequisite checks on step 4, it hangs and won't proceed any further. Same thing ...
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,...
0
votes
0answers
37 views

Oracle RAC 19c Backup to NFS Failing

I have mounted the NFS share on Oracle RAC Machine with the following options: rw,bg,actimeo=0,hard,timeo=600,nolock The NFS Server Export: rw,no_root_sqash,no_all_squash,secure. The directory where ...
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 ...
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 ...
0
votes
1answer
1k views

Java installation error on Debian 8

I followed the instructions from this website: https://www.digitalocean.com/community/tutorials/how-to-install-java-with-apt-get-on-debian-8 When I install jre and jdk it says: Reading package lists....
1
vote
2answers
3k views

AWS Database Migration Service requires a role not mentioned in documentation

I am trying to perform a database migration using AWS Database Migration Service (DMS) from a self-managed database on EC2 to AWS RDS. I get this message when I try to run the task to perform the ...
0
votes
0answers
156 views

Oracle cloud - ORA-20401: Authorization failed for URI

I'm having a problem with Oracle object storage authentication. I have a user danilo and this user belongs to Administrators group (This group has the ALLOW GROUP Administrators to manage all-...
1
vote
1answer
16k views

SQL Developer - The Network Adapter could not establish the connection

This is my first time connecting to an Oracle server. I'm using SQL Developer. They only gave me an IP, the default port (1521), a user name and a password. So I filled them in in the "New / Select ...
1
vote
2answers
4k views

Oracle: Getting ORA-01195 and ORA-01110 when attempting resetlogs

I am trying to get our database to startup. When I login to sqlplus and do a startup, I get the message: Total System Global Area 534462464 bytes Fixed Size 2215064 bytes Variable ...
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 ...
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
25 views

Monitoring Windows Failover Cluster with Enterprise Manager

I'm trying to monitor SQL Server instances on a 2 node active/passive windows failover cluster with Enterprise Manager. Oracle gives the following steps: -Install local agents on both nodes. -...
0
votes
0answers
53 views

I am not able to start an instance of Oracle Database - ORA-00205: error in identifying control file, check alert log for more info

When I want start the server instance I get the following message: SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System ...
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 ...
0
votes
3answers
2k views

enable fanotify on oracle redhat linux kernel 2.6.39-400

As a newbie in linux environment, I am trying to install clamav daemon, which is clamd, on oracle redhat linux 6 kernel EUK 2.6.39-400. It needs to have fanotify enabled in the kernel. As I see there ...
0
votes
1answer
4k views

OCI8 installation issue in Centos 7

I installed PHP 5.6 and Apache 2.4, and oci8 module on my fresh Centos 7 system. The oci8 module is working on terminal, but it's not working in Apache and not showing in phpinfo. I tried to disable ...
0
votes
1answer
38 views

Getting Error while connecting public to private server on Oracle cloud

ssh -t -o ProxyCommand='ssh -i ~/.ssh/id_rsa opc@0.0.0.0 -W %h:%p %r' -i ~/.ssh/id_rsa opc@0.0.0.0 ssh -t -o ProxyCommand='ssh -i ~/.ssh/id_rsa opc@<publiIP> -W %h:%p %r' -i ~/.ssh/id_rsa opc@...
0
votes
0answers
41 views

Can not find wich process is consuming all memory in Oracle Linux server 7.7

I have a server here wich has an alert of high memory usage (95% of all memory is being used), but i cant find where it is being used. [user@server ~]$ free -m total used ...
1
vote
1answer
6k views

Internet Explorer 8 - TLS Fatal Error Close Notify - Oracle HTTP - Server Apache 2.2.22.0

I applied the POODLE fix for Apache via SSLProtocol All -SSLv2 -SSLv3 in the ssl.conf file for our Apache server but am having issues with the CAC Client authentication via SSLVerifyClient require. I ...
0
votes
1answer
2k views

ORA-01019 under Win 8.1 / Server 2012 R2, ODBC Excel

We getting error message ORA-01019 when trying to connect to an Oracle 9.2 database with ODBC in an Excel macro running in Office 2013 32bit (!!!) under Windows 8.1. We are having the same issue ...

1
2 3 4 5
17