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
5 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
9 views

Integrate Azure ADDS with Oracle Cloud Infra

I have below use-case - Currently in my OCI infra one of the region datacenter is using RW AD domain controllers which further going to connect customer tenancies through VPNs and each customer ...
0
votes
0answers
10 views

Adding values to server start arguments oracle weblogic

Oracle has suggested to add few parameters to server start arguments which we are adding at Managed server -> configuration -> server start -> Arguments. Now i need to make this changes in more than ...
0
votes
1answer
34 views

How do I enforce encryption in transit with AWS RDS Oracle using CloudFormation YAML?

How do I enable and enforce / mandate encryption in transit for AWS RDS Oracle instances, when setting up the RDS database using CloudFormation YAML.
0
votes
0answers
16 views

azure oracle linux default password username

Does anyone know what the pass/user after typing sqlplus is for Azure cloud? The defaults oracle/oracle not working. Also, how to import sql script files aside from upload to github then downloading?
0
votes
2answers
56 views

Only oracle user can run sqlplus

I have a couple of RHEL 6 boxes with Oracle 12.2 server and 11.2 client. This is the vendor requirement. On one server I can run sqlplus as any user, on the other server I can only run sqlplus as ...
0
votes
0answers
39 views

Error "Exception [java.io.IOException:IO Error:There is no process to read data written to a pipe.]

We see this error in our environment, and thinking of the below mentioned as a workaround solution. If any of you have see this error in your experience or have an idea of such exception errors , ...
0
votes
1answer
51 views

access oracle enterprise manager from client

Somebody can tell me how to enable oracle enterprise manager to access from a client? I install Oracle Express 18.4.0.0.0 in a Centos 7 vm. Now I access to oracle em by browser on url https://...
0
votes
1answer
38 views

Oracle Cloud stopping due to inactivity

I have an Oracle Cloud Autonomous Database running in the Free Tier. Occasionally the database stops. When viewed on the website, the details say that it was stopped due to inactivity. However, that ...
0
votes
0answers
293 views

How to connect python docker container to Oracle container

My ultimate goal is to, using docker-compose, connect a python application to an Oracle database. The python application currently uses SQLAlchemy for trying to connect to Oracle. I've also tried ...
0
votes
0answers
22 views

Do I have to purchase java license to use Jenkins? [duplicate]

We are using Jenkins to build and deploy apps to production and staging. While migrating our Jenkins Servers to a newer server, we have realized that apparently Java RTE now requires a license to use. ...
0
votes
0answers
335 views

WebLogic servers, installed as a windows service, automatically stop

I have installed Oracle Database 12c Release 2, along with Oracle WebLogic Server 12c (12.2.1.4) and Oracle Forms and Reports 12c on my system, according to the documentation provided in the main ...
1
vote
0answers
87 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 ...
0
votes
0answers
50 views

Oracle logs rotation is not working with logrotate Utility

I am trying to rotate Oracle log file extension (.log and .xml). I am trying to make one good script to work with everything from less growing logs to big growing logs everyday. /u01/app/db/trace/*....
0
votes
0answers
670 views

How to install PHP 7 on Oracle Linux?

I have Oracle Linux 7.7 instance on Oracle cloud. I want to install PHP 7.2 on it. Previously I have installed PHP 7 on different Linux flavors but I could not find proper documentation, tutorial or ...
0
votes
0answers
48 views

Sum of bytes of database files of oracle database is showing more than the physical used size of the mount point

We are having oracle 11g2 database on Solaris 10. We have all data files under single mount point say /u001 and we make the sum of bytes of all data files which is more than the physical used size of ...
0
votes
0answers
25 views

Diferent dependences Oracle unixodbc

I'm trying to configure Zabbix monitoring on Oracle database, but I have dependence problem from diferent users, when I run: sudo -u zabbix ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so: ...
1
vote
0answers
27 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 ...
0
votes
0answers
17 views

Oracle Cloud Infrastructure Key Vault and KMIP protocol

I was checking OCI documentation around Key Management System (KSM) which I can create from OCI console. The documentation does not mention if KSM Vault implements KMIP protocol. I also verified ...
0
votes
1answer
58 views

OS recommendation for Oracle XE on a virtual machine? [closed]

I'm after advice on the best way to proceed, still new to some of this: I'm looking into deploying a virtual machine solely for handling a copy of oracle database XE on it. Currently we are solely ...
0
votes
0answers
26 views

Can Sun Sparc servers use monitor as main console?

Oracle's website says "You cannot use a local graphics monitor to perform the initial server installation, nor can you use a local graphics monitor to view POST messages." Is this also true for the ...
-1
votes
1answer
76 views

Install FREENAS on ORACLE SUN SPARC T5240

is possible to install FreeNas server on Sun Sparc Enterprise T5240 (Hardware compatibility),and how to do that? Thanks
1
vote
0answers
177 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 ...
0
votes
1answer
909 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
1answer
892 views

Oracle JDK is no longer available/downloading from the webupd8team

I had been depending on ppa:webupd8team/java to provide the apt package oracle-java8-installer. The packages are no longer present: http://ppa.launchpad.net/webupd8team/java/ubuntu/dists/ What ...
0
votes
1answer
54 views

Incorrect Oracle host

I have an issue with oracle 11g installed on a Windows Server 2016. When I create a new DB the hostname is always as the following image shows. https://i.stack.imgur.com/59Eg4.png However, my ...
0
votes
1answer
75 views

Synchronize Oracle database on VM under KVM using DRBD

We have two physical servers and we want to use KVM to create some VMs. One of the VMs will contain an Oracle 12 database and we want to make it highly available. We thought of using DRBD to ...
0
votes
3answers
493 views

oci_connect(): Error while trying to retrieve text for error ORA-28547

I have this connection string on an older server which works fine and connects to a remote oracle server. On this new server I installed oracle instant client simple and devel and php pecl oci8. ...
0
votes
2answers
1k 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 ...
0
votes
1answer
2k 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 ...
2
votes
0answers
80 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
1answer
190 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 ...
2
votes
0answers
134 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, ...
0
votes
1answer
220 views

Oracle RAC installation failure: disk share issue

Oracle RAC installation is failing because of shared disk issue. While running "runcluvfy.sh" to verify the disk share between nodes. it is failing on node2. I have collected trace logs of following ...
0
votes
0answers
133 views

Issue with Rewriting an URL for Weblogic Server 10.3.6

I have been working on 2 different web servers(dev-banabc and dev-banxyz), on which we have 2 applications running on each Weblogic Server. I have tried other solutions found on serverfault, however, ...
0
votes
1answer
189 views

Oracle 12c 32-bit client and direct GOT relocation R_386_GOT32 against `lxecerr’

When trying to install Oracle 12c 32-bit Client (12.1 or 12.2) on Oracle Linux 7.3 or 7.5, it throws error during linking static libraries: INFO: Start output from spawned process: INFO: -------------...
0
votes
0answers
14 views

How can I further improve Oracle 12.1 performance on RDS m4.large instance?

I'm having performance issues with my current Oracle setup. Queries are taking half a second and I can't figure out how to speed it up further. I've upgraded my RDS instance from a t2.medium to m4....
2
votes
1answer
7k views

Persist alter session set “_ORACLE_SCRIPT”=true; in Oracle 12c

I have an oracle 12c (1.0.2) running in Docker. I'm using a script which is executed during container startup: TESTER IDENTIFIED BY TESTER; This fails with this error: ORA-65096: invalid common ...
0
votes
1answer
29 views

Kernel upgrade and Oracle prerequisites error

I am upgrading kernel (Red Hat) from 6.7 to 6.9 with Amazon AMI and when I am installing Oracle through puppet I am getting this pre-requisite error. Error: Execution of '/usr/bin/yum -d 0 -e 0 -y ...
1
vote
4answers
8k views

windows 10 installing oracle client 12c or 18c hanging at step1

I am trying to install Oracle Client version 12c or 18c. I have tried both of the installers, and once I click next, it hangs and won't proceed any further. Same thing happens on both of the setup ...
0
votes
0answers
195 views

Apache httpd reverse proxy on solaris only empty page

this is my httpd.conf file I tested reverse proxy without any virtual hosts in this first draft. Where is the problem? SSL is working fine by the way that is not the problem. # # This ...
1
vote
0answers
282 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 ...
3
votes
1answer
18k views

Howto install Oracle OCI8 instantclient on Ubuntu 18.04

I want to share some information about my OCI8 installation to access Oracle databases. If you got errors like "PHP Startup: Unable to load dynamic library 'oci8.so'" or "checking Oracle Instant ...
0
votes
1answer
14k 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 ...
0
votes
0answers
218 views

Oracle database Listener error

Actually my connection in sql developer was fine while working yesterday. Today I cannot connect and when I checked the status of my listener(LISTENER1), it had, somehow, been terminated. When I tried ...
0
votes
3answers
2k 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 ...
2
votes
1answer
1k views

IO Error: The Network Adapter could not establish the connection in Jmeter load test

I'm doing a load test to Web Service SOAP with Jmeter, on non-GUI mode I start to get errors since 300 Number of Threads, this was detected with a "Response Assertion" with this rule: "Test failed: ...
1
vote
0answers
423 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 ...
0
votes
1answer
31 views

My instance of Oracle 12c is using up alot of space and I am not sure why How to free up space

I am developer, not an Oracle admin. We have an Oracle 12c instance that is used only by developers. It is currently using up most of the disk space on the machine. The C:\app\OracleUser\product]12.1....
0
votes
1answer
3k 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 ...

1
2 3 4 5
16