The tag has no wiki summary.

learn more… | top users | synonyms

8
votes
3answers
8k views

Alternatives to Oracle JRE

I would like to uninstall as many Oracle products from my computer as possible because I don't like that company. However, I require Java for some of my applications, e.g. Eclipse. What alternatives ...
0
votes
1answer
79 views

How to use backreferences in oracle sqldeveloper find/replace

How do you use backreferences when doing regular expression find/replace in Oracle SQLDeveloper? \n doesn't work for me and neither does $n.
0
votes
0answers
5 views

How to backup Oracle database and tomcat directory from Disk with Fedora or other linux live cd?

Some partitions of my disk corrupted (superblock error) and cannot boot, stacked on "Maintenance Mode". How to backup oracle database and tomcat directory on that disk with linux cd ?
0
votes
0answers
24 views

Linux 32 bit CPU + Oracle Limitations

I have 32 bit RedHat 4 server (with hughmem kernel) CPU is 2 x Xeon X5650 (12 total psychical cores, 24 virtual) On the server there is running Oracle 10G (32 bit) database instance. Oracle because ...
0
votes
1answer
14 views

What does this “3-line to column” icon indicate about an object in SQL Developer?

In SQL Developer, under Tables, almost all of my tables are just a normal table icon, however, every so often I come across a table that has the icon/image shown below. I wasn't around when some of ...
0
votes
1answer
16 views

Why is oracle instant client so slow on OSX?

I have both a PC and Mac environment setup to connect to the same Oracle server. Both are using Oracle instant client 11.2.0.4 and are on the same network. Both machines are similarly configured ...
2
votes
4answers
39k views

Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name

I have a batch file which starts the Oracle Services net start OracleOraDb11g_home1TNSListener net start OracleServiceORCL call C:\app\Edifixio\product\11.2.0\dbhome_1\BIN\emctl.bat start dbconsole ...
0
votes
1answer
2k views

Oracle11g localhost:1158/em not connect

In my Windows 7 professional edition, I installed Oracle Database Express Edition 11g Release 2 which is downloaded from Oracle.com. The SID is 'orcl', username is 'system'. When I attempt connect to ...
0
votes
2answers
2k views

Missing scott user in Oracle 11 g database

I have installed Oracle 11g R2 on my Windows. During the installation, in password management, the "scott" user is missing. I'm unable to login in "scott" as my sample schema. What do I have to do in ...
0
votes
1answer
3k views

How to fix UDI-31623 error in Oracle?

Yesterday I've tried to import another DUMP as a new Oracle schema and failed to to limited space. So the impdp exited with an error. I've successfully deleted outdated schemas using the sysadmin ...
0
votes
1answer
42 views

SQL Developer 4 Toolbar

Recently my SQL Developer toolbar became messed up. I'm not sure what I did, and I can't change it back. When I got to View-->Show toolbars-->Customize Main Toolbar, it just says ...
2
votes
5answers
6k views

Ctrl v does not work in ORACLE SQL Developer

I cannot get Paste ( Ctrl+V ) to work in Oracle SQL Developer
6
votes
2answers
3k views

Override RPM install path

I've downloaded an RPM from Oracle that wants to install in /usr, and due to the way our SysAdmins set up our workstations, I don't have enough disk space in /usr. Most of the space on the root ...
1
vote
1answer
2k views

Genymotion: possible to create a shortcut to an Android virtual device?

I'm using Genymotion as Android emulator, but would like to be able to start a virtual device from the command line or with a Windows shortcut, instead of the Genymotion window. Because Genymotion ...
0
votes
0answers
18 views

Load data from mailbox to oracle table

I have an incoming mail which has the below format in the body Number of output records -: Consumer Extract |: TOTL_OUTPUT_REC: 10684 Number of output records -: Campaign Extract |: TOTL_OUTPUT_REC: ...
1
vote
0answers
15 views

USe of Optimal Flexible architecture in oracle 11g?

I would like to to know about Optimal Flexible Architecture(OFA). I went through some articles in internet. But how exactly should we do to separate Oracle binary files and oradata(data files ) in ...
1
vote
0answers
15 views

Permenant link to official Java documentation pages?

Does Oracle's official Java documentation pages such as http://docs.oracle.com/javase/8/docs/api/java/util/concurrent/ConcurrentHashMap.html have permenant links? If so I'd like to use that instead ...
0
votes
0answers
46 views

Tableau slow connection to data source

We are having continued problems with our Tableau Servers... We have two servers tableau1 & tableau2 tableau1 is a proof of concept on a slow pc acting as a server. tableau2 is a server managed ...
0
votes
2answers
71 views

Add a file to /etc/yum.repos.d to install Oracle JDK 1.6.0-45 from yum?

I have a fresh RedHat 6.5 virtual machine on Amazon Web Services (EC2), its repos look like this currently: [root@ip-172-31-11-112 tmp]# ls -1 /etc/yum.repos.d/ redhat-rhui-client-config.repo ...
0
votes
2answers
6k views

Installing Oracle 11gR2 on RHEL 6.2

I'm having some difficulty installing Oracle 11gR2 on RHEL 6.2. I have compiled a giant list of every single step I have taken so far. I installed RHEL 6.2 on VMware. It did its easy install ...
0
votes
0answers
11 views

data was displayed in my toad even after pressing F9 key

i am using the package dbms_output package for display some in formation for defining particular operation. after writing the procedure we generally F9 key to compile & execute the program. but ...
0
votes
0answers
27 views

How can I connect to apex oracle database using ssh?

I have obtained a workspace in apex.oracle.com , where I can use database provided for me. Now I can run the sql command in browser to do operations, but thats kinda slow. So what I need to do is , ...
1
vote
1answer
62 views

Oracle SQL Select: If not exist, leave blank

I have two tables: Table1 [ID] [Number] 1 40 2 100 3 7 and Table2 [ID] [Number] [Name] 1 40 A 3 7 C Data originates in Table1, then gets copied to ...
2
votes
4answers
9k views

I just installed oracle 11g and I can't figure out how to log into the enterprise manager

Any idea what the default login is? none of my oracle accounts are working.
0
votes
2answers
76 views

Is it possible to install OS Windows 8.1, Windows 7, Windows Server 2012, Oracle Linux, Oracle Solaris, Fedora Linux?

I'm planning to have 6 operating systems in my laptop. And wanted to have more in the future. I want to install 2 versions of desktop OS in windows (7 and 8.1) and a server OS in windows (Windows ...
0
votes
2answers
65 views

Connect to Oracle Linux Virtualbox Database from Debian Linux Virtualbox

I have an Oracle Linux 6.4 with Oracle 12c running on a Virtual box with NAT and bridged network running on an OSX host. A second guest is a Debian Linux with NAT and bridged network. I'm trying to ...
0
votes
1answer
40 views

Loading Oracle Virtual Box Error

When I tried to install 'Oracle VM Virtual Box' it is giving a error -'VT-x/AMD-V hardware acceleration is not available on your system. Certain guest (e.g. OS/2 and QNX) require this feature and will ...
0
votes
1answer
85 views

Looking to kill frmweb processes with no jobs

So I am trying to figure out a way to kill Oracle frmweb processes that are doing nothing when load begins to get too high. So far, I have found this command: ps -elf | head -1; ps -elf | awk '{if ...
0
votes
1answer
92 views

probe-scsi-all shows two disks with the same PhyNum

I'm attempting to remotely determine the physical location of two disks in an Oracle SPARC T4-1 server prior to performing a Solaris install. Because the disks use World Wide Names (WWNs), the Oracle ...
1
vote
4answers
4k views

Sqldeveloper /as sysdba connection

I'm a total newbie in Oracle. I installed Oracle 11g XE R2. Also I installed SqlDeveloper 3.2.20.09 version. I generated auto connections, and I have 2 connections. One is: /as sysdba and ...
0
votes
1answer
78 views

concurrent scheduled jobs and ora-27477

Need: To have Oracle kick off a shell script that performs processing on tables and data in the Oracle database. The script is instantiated by specific activity from web clients. Issue: Web clients ...
0
votes
0answers
9 views

Oracle RAC 11G Requirements VS Single Node 11G

I have an Oracle 11G Database running on Solaris SPARC. I'm already using NFS for the node. I'm looking at moving to RAC. Would there be any additional requirements for RAC besides an additional ...
0
votes
0answers
442 views

Installing Oracle 32-bit Client on Windows Server Already Running 64-bit Oracle Database Server

I have 64-bit Oracle Database Server (11.2.0.3) installed on Windows 2008 R2, and naturally, it automatically installs the 64-bit client. I have to install an application onto this server that is ...
1
vote
1answer
61 views

Oracle Client 11g for Solaris

OS: solaris 11_2-text-x86 I want to install an Oracle Client but can only see the Oracle Database 11g Release 2 Client (SPARC) but my Solaris OS isn´t sparc. When i still install the sparc version ...
1
vote
1answer
48 views

Process Monitor Results from two Citrix Servers Application Error

I have two Citrix Servers both running an in-house bespoke software. The software generates files using a word 2003 mail merge template which runs VBA code to query an oracle database. Anyway the ...
1
vote
1answer
17 views

Bind Solaris 10 swap file

I have created an Oracle swap file to enhance my swap space. I have to do this for a Oracle Client installation. After creating swap file i Run the swap command to specify the additional swap space ...
11
votes
4answers
82k views

How do I completely remove Oracle 11g?

How do I completely remove the Oracle 11g client from my computer? I am running Windows 7, 64-bit. I have tried running deinstall.bat, but this doesn't work.
0
votes
0answers
19 views

Oracle Cloud Control - Cant execute jobs

I am using Oracle Cloud Control 12c (WebLogic) on Oracle Linux Server 6.3. When I want to apply the downloaded agent-software, the job stuck in scheduled Status. Is there a way to force this job ...
0
votes
0answers
30 views

Oracle VirtualBox won't let me create a machine

I get this error message: Callee RC: REGDB_E_CLASSNOTREG (0x80040154) When trying to use Gentoo. I ran in administrator mode, but didn't work. I did everything it suggested, without changing a ...
0
votes
1answer
212 views

What is OracleXETNSListener service?

What OracleXETNSListener service does? I know it is installed with Oracle (11g Express), but I couldn't find a description. What I checked: The service description field is empty. Google hits show ...
0
votes
2answers
87 views

Oracle SQL Developer - How to add folders to frequently used locations in Open Folder interface

How do you add folders on the left side of the Open Folder interface? In one of my previous versions of the installation I had a couple different folders I frequently used in that part of the ...
0
votes
1answer
82 views

Should a dev team use a local database or a remote shared one? [closed]

I'm part of a team of developer and today, we do our developments against an Oracle 11g database installed on our own machine each. I would like to know your point of view about this way of working ...
1
vote
3answers
13k views

OS X Lion - Installing Oracle 10g Standard Edition

Im trying to install oracle 10g on to OS X Lion, I have previous achieved this on snow leopard with the following ...
0
votes
0answers
89 views

IE10 dropdown menus not resizing properly when page-zooming

Drop-down menus are not displaying right in IE 10 when using anything other than 100% zoom. 100%: 125%: 75%: It is working on one computer, but I can't identify the difference. Both ...
0
votes
1answer
180 views

error starting Oracle HTTP Server

I instaleded Oracle HTTP Server on Windows Server 2003 and It's work. But when I restart computer, I get error. service.log: Request failure: 0 of 1 processes started. HTTP/1.1 204 No Content ...
-1
votes
1answer
44 views

Do oracle database server use a License Key?

I installed oracle Linux and oracle database on a test server using the media on the OTN. I noticed that no key was required. My question is this: On a production environment at some point do I have ...
0
votes
1answer
481 views

Environment Variable ORACLE_UNQNAME not defined

I'm trying to install Oracle 11gR2 Entreprise Edition but during database creation, I got this Error : Environment Variable ORACLE_UNQNAME not defined And when I tried to lunch 'emctl.bat' From ...
0
votes
1answer
184 views

Connect to Oracle DB server remotely

I have Oracle 9i db installed on machine connected to the Internet behind nat and the Oracle DB server is listening on default port 1521. When I connect over lan to DB server its worked perfect and I ...
0
votes
1answer
629 views

Installing Oracle 12c on CentOs 6.4

I need to install Oracle DB 12c on Centos 6.5/6.4 that has no GUI (or xserver) installed, Is there a way to do it? Can you point me to a manual? Thanks
0
votes
1answer
57 views

Anyone has and is willing to share BIOS update for Sun X4170?

I have a Sun X4170 server and would like to update its BIOS (for one, Windows 2008 does not work on it). However, since Sun was bought by Oracle, there is no way to download any BIOS update. Does ...