The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
48 views

Toad Query Builder Object Palette is empty

I realize this is a re-ask of In Toad for Oracle's Schema Browser, my Tables list is empty, but I don't have the ability to just add a comment yet. I'm running Toad 12.6 and I've setup a ...
0
votes
0answers
11 views

Oracle VM VirtualBox Win 7 Data Recovery

So I'm running Oracle VM VirtualBox with a Build of Windows 7 Ultimate, and the virtual guest OS just crashed out of no where, and won't allow me to access my windows guest os. I wanted to know if ...
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 ...
-1
votes
2answers
102 views

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

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 ...
0
votes
0answers
11 views

Oracle SQL Developer Data Modeler: How to Search for a Table and Show in the Diagram

In the Oracle SQL Developer Data Modeler 4.0, there is find functionality. It's icon is the binoculars in the top right corner. When we use that find operation, we receive a list view of results that ...
0
votes
0answers
17 views

Oracle Virtual Box: No option for 64bit vm's [duplicate]

I've installed virtual box on my pc and I want to use 64 bit operating systems inside my vm. Unfortunatly I can only create 32 bit vms (the 64 option is missing completly). I know it should be there ...
0
votes
1answer
3k 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
1answer
39 views

Oracle 11g express install on Linux

Do I have to be root user to install Oracle 11g on RHEL 6.5 (Santiago)? I am able to install the rpm as a different user, rpm2cpio oracle-xe-11.2.0-1.0.x86_64.rpm | cpio -idv But when I run . ...
0
votes
3answers
2k views

Oracle VM VirtualBox “instruction at 0x806d58e2 referenced memory at 0x00000000” error

When I start Oracle VM VirtualBox 4.2.18 on Windows 8.1 64bit, the below message shows. What is the meaning of this message and how to solve it? VBoxTestOGL.exe The instruction at 0x806d58e2 ...
2
votes
1answer
203 views

WebLogic 12.1.1.0 is truncating dynamically generated XML file

this is my first question on SU/StackOverflow, so bear with me... We've got an exploded application, residing on a NAS mount, that we just moved from WebLogic 6.1 to WLS 12.1.1.0. Believe it or not, ...
0
votes
0answers
37 views

Task Schedule excel file with ODBC/Oracle connection

I am having problem running an excel file with ODBC connection for Oracle to run via Windows-7 Task Scheduler. It will just say running. What the excle file does. After I open the file, it will ...
0
votes
0answers
18 views

How to Create a VirtualBox like Oracle developer day VM using CentOs?

Oracle has provided us a way to use Oracle Database on Mac with its Developer day VM's. But its of huge size and I couldn't resume the download. So I want to build a VM with Oracle Database installed. ...
0
votes
1answer
25 views

I moved Oracle Instant Client, but it didn't actually move?

I set up our local intranet on IIS running on a Windows Server 2012 using Oracle Instant Client to connect to our database. I installed Oracle Instant Client to C:\instantclient during set up. It ...
1
vote
0answers
46 views

check_oracle_health with OPS$Nagios account

I can login to my database via sqlplus with the OPS$ account, but i cannt seem to get it to work in with the nagios check_oracle_health. Im testing from the command line. ...
0
votes
0answers
18 views

Installing java 7 or 8 on Mac OS, some questions

I have java 6 installed on my Mac OS laptop. Due to a requirement of some Android library of having Java 7 installed, I need to install it. Should I install Java 7 or 8? Or both? I know there's no ...
0
votes
1answer
44 views

How do I check for command line parameters in sqlplus?

I am trying to write a sql file which will run under sqlplus. My goal is to create a mechanism by which sqlplus will prompt for password if no parameters are passed, and if &1 is present, continue ...
0
votes
0answers
35 views

Patch Heartbleed Vulnerability on Oracle Enterprise Linux 6.5

After running an application scan on a webapp hosted on Oracle Enterprise Linux 6.5, the scan reported that the app was vulnerable to Heartbleed. I am having a tough time updating OpenSSL on OEL 6.5. ...
1
vote
1answer
186 views

Oracle SQL Plus expdp in bat file

I try to export all my bases with a .bat file, but when the .bat file open and connect in sqlplus, the program don't read the last of file. I need export and log all export with Spool. The .bat is ...
1
vote
3answers
6k views

I am not able to save the changes in tnsnames.ora file

I am tring to save the tnsnames.ora fille, but couldn't it showing acess denied. Any one have any idea regarding this? Curently I am using Oracle 11g on Windows 7
-2
votes
2answers
3k 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
0answers
76 views

Virtualbox Centos / Oracle Express losing connection

I am running a Virtualbox Centos Oracle Express developer machine in a local "Hostonly" network. After a few minutes I can verify with SQLDeveloper that the working connection to Oracle is suddenly ...
1
vote
2answers
590 views

Database is full; what should be the strategy?

What if my database is full and I don't have any spare hard disk or memory space. What should my strategy to free up the space?
0
votes
2answers
2k views

starting oracle database automatically

I am using Fedora 8 and Oracle 10g Express Edition. Every time I start my fedora I have to click on start database. How can I add startdb.sh to startup so that it automatically executes when Fedora ...
2
votes
1answer
297 views

Trouble installing OpenCOBOL

When I ./configure, I get this error: configure: error: libdb is required I signed up for an Oracle account (yak shaving), downloaded Berkeley DB, untarred and unzipped, wrestled with the unhelpful ...
0
votes
2answers
1k views

Is there sofware that can emulate how Oracle works with disks?

Don't now if its a right place to ask, so if not please give me a hint. I need some software that do can emulate how Oracle works with disks (Notice: Not the Oracle workload tool). I've already took a ...
0
votes
0answers
87 views

What software do I need to query an Oracle database?

I know how to write queries, but haven't had to mess with the software before. I've been given a username, password, and an Oracle TNS string (the text, not a tnsnames.ora file). Nothing I've tried ...
1
vote
1answer
724 views

Install Oracle on Mac OS X Lion 10.8

I have no experience with Oracle but need to install it on my Mac so that I can test pulling data from an Oracle database. I already have Apache, PHP, MySQL installed but have no idea where to start ...
0
votes
1answer
3k views

Restricting a user to access only his own tables in Oracle SQL Developer

I am confused in the permission, privileges in the SQL Oracle Developer. The user created can access all the schema/user 's tables. I want to restrict specific user in the database to access (ALTER, ...
0
votes
1answer
2k views

Oracle database client on OS X?

I am looking for a way to run the Oracle database client on a Mac. The server will be on a remote host. There used to be a Mac version of Oracle 10gR2 Client, but now I can't find it on Oracle's ...
4
votes
1answer
60 views

Database integration with …well with sound beep or light? [closed]

Perhaps this post major editing : I work for company which sells services online. I would like to build some kind of software bridge/integration tool which would integrate our Oracle database with ...
1
vote
1answer
78 views

database statistics and reporting with or without parsing of built in logs

I prefer a generic statistical utility / plugin / application, but don't limit myself as specific might do well too. I want to see a way by which I can see query statistics for ALL queries. e.g ...
0
votes
2answers
1k views

Using sqlplus as tnsping alternative

Is it possible to use sqlplus as an alternative for tnsping since tnsping wasn't installed with the oracle setup. I simply want to check via batch script, whether the definitions from the tnsnames.ora ...
0
votes
1answer
210 views

Comparison between Oracle RAC Cluster Database (10gR2, 11gR2 and 12cR1) and deployed Oracle DB on Linux Cluster [closed]

Oracle RAC implementation may be costly for small enterprise, but how it would be if Linux cluster is implemented and then standard Oracle DB is deployed on that cluster to achieve availability like ...
3
votes
4answers
3k views

Login to Oracle database without username and password

I want to login to a database by running an SQL file from a unix script without supplying username and password (as root)....is this possible? Database is oracle
0
votes
1answer
419 views

Can't import a dmp file to oracle 12c database (imp-00037)

I am trying to import a dmp file to my oracle 12c instance, while I used to do that without trouble I got a file which didn't work with both imp and impdp. After long research without a result I ...
1
vote
1answer
108 views

Oracle database block diagram or map

I have an Oracle database. It has multiple schemas, and each schema has many tables. Is there a way to generate a tree diagram or block diagram, such as this image, to visualize the database? I ...
0
votes
1answer
736 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
1k 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
88 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 ...
0
votes
0answers
15 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
1answer
331 views

Oracle local database product (like MS Access)

Is there a Oracle, local database product (which I can run on my laptop like MS Access) which is free for developers, and in which I can Create tables, Load data from file, Run SQL (oracle's syntax) ...
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 ...
0
votes
0answers
66 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 , ...
9
votes
3answers
9k 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
210 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
15 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
34 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
57 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
31 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
42k 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 ...