The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
88 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
1answer
64 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
93 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 ...
1
vote
1answer
76 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 ...
1
vote
1answer
907 views

How to activate WIFI service on Enterprise Linux Version 5 provided from Oracle?

I have installed Enterprise Linux Version 5 provided from Oracle I am able to access Internet using network cable Please tell me how can I enable WIFI service ,so that I can use internet without the ...
0
votes
1answer
16 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 ...
0
votes
1answer
26 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
1answer
65 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 ...
0
votes
1answer
51 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
177 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
306 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 ...
3
votes
0answers
400 views

Access 2010: The Oracle client and networking components were not found

I've installed these Oracle client and ODAC files required for "Microsoft ODBC for Oracle": ODAC112021Xcopy_32bit win32_11gR1_client But alas it will not work! I'm on Windows 7, using Access 2010. ...
2
votes
0answers
117 views

VirtualBox error with Ubuntu virtual machine

I am trying to work on a coding project and cannot open my Ubuntu virtual machine with Oracle VM VirtualBox. I took a snapshot yesterday at about 11, and it was working fine. Several times I closed ...
2
votes
0answers
76 views

How do I enable fully qualified column names in Query Builder in Toad for Oracle?

I've found several hits on google on how to do this in Toad for SQL, but I need the same for Toad for Oracle. (Toad v11). I'm building a large query where I combine several aliases of the same table ...
2
votes
0answers
191 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, ...
2
votes
0answers
466 views

403 Forbiden on Apache (CentOS) Server

These are my VM setup: HOST: windows 7 ultimate 32bit GUEST: CentOs 6.3 i386 Virtualization soft: Oracle virtualBox 4.1.22 Networking: NAT -> (PORT FORWARD: HOST:8080 => GUEST:80) Shared ...
1
vote
0answers
24 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. ...
1
vote
0answers
643 views

Installation of Oracle Database 11g Express Edition on Ubuntu 12.10

I am intalled the Oracle database have followed this steps [link|http://meandmyubuntulinux.blogspot.in/2012/05/installing-oracle-11g-r2-express.html?showComment=1357195285714#c4393074524447658792] . ...
1
vote
0answers
175 views

parallels accessing arbitrary port on host os from guest os

I'm running Windows 7 inside of Parallels on Mac OS X 10.7.5. No firewalls have been setup. From the Mac end, to work remotely I need to VPN into my corp network. Then I use SSH Tunnel Manager to set ...
1
vote
0answers
256 views

Need Solaris network driver 64bit

I'm newbie in Solaris and I need network driver 64bit for: - pci bus 0x0004 cardnum 0x00 function 0x00: vendor 0x1186 device 0x4b01 D-Link System Inc DGE-530T Gigabit Ethernet Adapter (rev 11) ...
1
vote
0answers
582 views

CentOS 6.1 + Oracle Express 11g

I have installed CentOS 6.1 and Oracle. And then I closed the firewall, used the right Env Typed /etc/init.d/oracle-xe start and inited OK But, I can not use "get Started" (Firefox displayed: ...
1
vote
0answers
459 views

How to run a SQL select query in Oracle database through a shell script?

I need to run a SQL select query in an Oracle database and have to capture the list of retrieved records in a shell script. Also I would like to modify the query for certain conditions and need to ...
1
vote
0answers
106 views

How can I get call centre information from CallCenterAnywhere

Our organisation uses some software called CallCenterAnywhere to manage a customer services centre which it does well as far as I can tell, but we'd like to extract some information from it to present ...
0
votes
0answers
10 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
11 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
0answers
14 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
0answers
21 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. ...
0
votes
0answers
28 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
29 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
0answers
63 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 ...
0
votes
0answers
14 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
32 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
0answers
26 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: ...
0
votes
0answers
20 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
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
52 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 , ...
0
votes
0answers
14 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
580 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 ...
0
votes
0answers
36 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
0answers
118 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
0answers
107 views

How can i export virtual machine in virtualbox with snapshots

I have VM on virtualbox with 15 snaps shots saved. Now i can export to ova and ovf with export but that does not include all snapshots of parent VM. Is there any way so that i can put all snapshots ...
0
votes
0answers
200 views

Oracle 11g - Command line error in sqlplus - SP2 -0306

I am a newbie to Oracle 11g. I installed Oracle 11g on my Windows 7 64 bit machine. And when i try to execute the command "CONN SYS as SYSDBA", i am getting the error SP2-0306: Here is a screenshot ...
0
votes
0answers
2k views

Oracle telnet localhost 1521 connect failed

Our service provider installed Oracle 11G on our Windows 2008 R2 server on vmware. But we can not connect from another client on port 1521. And we can not also telnet localhost 1521 port on server. ...
0
votes
0answers
224 views

Oracle 11g Installed but cannot access SqlPlus from terminal

I have installed Oracle 11g XE edition. It is working fine from browser. But I want to unlock hr user so I want to login from terminal. However I can't access SqlPlus command prompt from terminal. I ...
0
votes
0answers
269 views

JAVA - Error occurred during the installation

My problem figure out for me when i was configuring my Jboss AS 7 on Linux Mint, in the moment i was installing it, the JVM presentation a some problems and not work anymore. With this, i remove JVM ...
0
votes
0answers
20 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
64 views

how to use oracle r12 that is installed in external harddisk?

I am new to oracle r12 installation. And I have this installed in an external segate 1 TB hard disk. Now I want to run this on my laptop just by pluging my hard disk. But I dont know the procedure to ...
0
votes
0answers
171 views

How to delete oracle databse 11g

I'm having huge issues trying to delete the oracle database 11g. I tried the OUI but It didn't work(it shows a warning telling me that you should use deinstall which doesn't work either). After that, ...
0
votes
0answers
85 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 ...
0
votes
0answers
366 views

Problems during binding SpotLight to the instance

I have RAC Oracle11 installation built from 2 nodes running on Linux Red Hat OS. Now, I try to make connection from SpotLight running on Windows 7 to the Instance of one of nodes (TNS name of it is: ...