Tagged Questions

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.

learn more… | top users | synonyms

0
votes
1answer
447 views

ORA-12154: TNS:could not resolve the connect identifier specified

I'm trying to use bat file/CLI to run SQL script against certain Oracle database with following syntax: sqlplus -L user_name/database_name@Password @d:\my_bat_file\sql_script.sql If I run this ...
0
votes
0answers
193 views

Username/password for Oracle Linux 5.8 VirtualMachine

I have the Oracle Linux 5 ova (converted to VirtualBox). The documentation I have seen mentions using either root/oracle or oracle/oracle to login. However that is not working. Any ...
1
vote
0answers
35 views

Export data from Oracle Lite 10gR1 odb file

I hope you can help me with this one. Years ago (2005) someone way before me set up a server with WinXP and a custom-written Java/Tomcat-whatever application for monitoring some sensors, the database ...
0
votes
1answer
361 views

How do I install Oracle Linux 6 with the UEK over the Internet?

Is it possible to use the Oracle Linux 6 UEK download and download the rest of the OS over the Internet? I have UEK running. I selected URL for the Installation Method. I tried various URLs for ...
0
votes
1answer
87 views

IBM System X M4 Series Servers Oracle Linux Support

Is Oracle Linux runnable/compatible with the M4 Series of the IBM System X Servers? In their compatibility website, most compatible machines listed are those from Dell and HP..there are IBM system ...
0
votes
1answer
307 views

Error installing Oracle-Java6

I'm attempting to install Oracle-Java6 on my VPS, running ubuntu-10.04 for the purpose of running Openmeetings. I installed the ppa webupd8team/java, updated and ran sudo apt-get install ...
0
votes
1answer
39 views

Oracle 10g backup issue

Introduction: I have to set up a backup concept for an old Oracle 10g installation. The server is old and poorly managed, but I have to ensure we have rock solid backups until the system will be taken ...
0
votes
3answers
2k views

Can Docker help me install Oracle 11g database on Ubuntu?

We are struggling with a common problem of trying to provide an Oracle 11g instance for our developers to test with. Our standard build agents are based on Ubuntu 12.04 but Oracle supports only RedHat ...
0
votes
1answer
108 views

Error while using oraenv

I'm using Oracle RAC in RH6, and when i try to use the 'oraenv' utility to set the variables with the user oracle, i get an error: [oracle@vhor12 ~]$ . oraenv /bin/.: Permission denied. Using it in ...
0
votes
1answer
115 views

SQLPlus for Oracle 11 not rolling back

I have a shell script which invokes an SQL file. However even with AUTOCOMMIT OFF and on SQLERROR EXIT ROLLBACK. Sqlplus fails to rollback. My sql file has 3 lines 3 are correct and 1 is incorrect. ...
0
votes
1answer
166 views

Oracle Counters for Perfmon

How to install Oracle Counters for Windows Performance Monitor (and operfcfg.exe) on a separate machine (other than the machine where Oracle Database Server is installed) ? The Oracle database version ...
0
votes
1answer
474 views

SP2-0750: You may need to set ORACLE_HOME

I am getting following error message when i write sqlplus on command prompt SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory Here are the path details Net ...
2
votes
1answer
362 views

How to recover from a power loss on an OVM server

We had a UPS error and lost power on a physical server hosting about 10+ virtual machines using Oracle VM platform. We got it back up and running, but I am wondering what is the best way to recover ...
0
votes
2answers
131 views

Set up JDBC DataSource in LDAP

How do I create a JDBC DataSource in an OpenLDAP server? The problem is that jdbc/something is not a valid DN or RDN. But that is the format of the name that you are supposed to use for JDBC ...
0
votes
1answer
41 views

Oracle application and DB scale out in private cloud

I have a client who was looking to migrate their Oracle environment to Amazon - probably Amazon RDS but were unable to get the SLA they wanted from it. I need to know if deploying something to ...
1
vote
2answers
584 views

Install an Oracle DB in a linux VM

I am trying to set up an Oracle database server (at the moment just for testing purposes) in a virtual machine. The setup I'm using: VirtualBox Network adapter in NAT mode (redirecting ports ...
2
votes
4answers
1k views

How to make RHEL have persistent local hdd name?

I have 2 identical Dell R720 servers running identical Oracle Enterprise Linux(RHEL)6.4. Both servers (supposedly) configured in exactly the same way. However, one of the servers is behaving ...
7
votes
1answer
436 views

LSI RAID controller errors on DB import - How to troubleshoot?

We're running an import of a database dump on an Oracle system - (RHEL 5.9, 2.6.18-348.6.1.el5). The import does not complete, eventually erroring-out with: ORA-15080: synchronous I/O operation to a ...
3
votes
1answer
325 views

Oracle Audit Vault and Database Firewall on Hyper-V

I am trying to configure an Oracle Database Firewall / Audit Server as virtual machines on Hyper-V. The problem is that, for example, to install the Database Firewall on a virtual machine, the VM ...
2
votes
0answers
203 views

Dtrace Oracle show high fsflush on solaris 10

Solaris 10 - Oracle 11G in a zone Running mpstat , i've noticed that one CPU was at 100% used every 5 seconds for 5 seconds while all other CPU were fine, in used but nicely spread. 1 0 0 0 ...
1
vote
1answer
87 views

Oracle SQLConnect: 1033 via UnixODBC

Here is the full error: PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[08004] SQLConnect: 1033 [unixODBC][Oracle][ODBC][Ora]ORA-01033: ORACLE initialization or shutdown in ...
0
votes
1answer
328 views

Cannot open oracle 9i database: ORA-16038: log 4 sequence# 1781 cannot be archived

my server was unexpectedly rebooted. after the server boot up I received the following error when trying to start up the database: ORA-16038: log 4 sequence# 1781 cannot be archived ORA-19504: ...
0
votes
0answers
314 views

Oracle 11gR2 Listener stop automatically

My problem is after I started Oracle Listener succesfully, it will stop automatically after a few seconds. cache1-> lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 20-MAY-2013 ...
0
votes
0answers
161 views

can not get required packages with yum

I wound like to install Tuleap - on Oracle Linux 6.4 [ebalbar@puding ~]$ yum repolist Loaded plugins: refresh-packagekit, security repo id repo name ...
0
votes
1answer
2k views

Cannot start Oracle XE 11gR2 Net Listener and Database on Ubuntu 13.04

I have been following the setup step on this article for installing Oracle XE 11g R2 on Ubuntu 13.04. The environment variables PATH, ORACLE_HOME, ORACLE_SID, NLS_LANG ORACLE_BASE have all been set up ...
0
votes
1answer
54 views

Oracle APEX in browser over VPN

After lots of futzing around with all of the settings, I finally managed to get APEX to work on a remote server. To get that to happen, I had to grant my user the SYSDBA role, and I also included ...
1
vote
1answer
116 views

LSI 3042 supported with Oracle VM Server

Trying to install an HP DL165 1U server with an LSI 3042 SAS card. I get to the install, selected a language, select a keyboard screens then it asks me for a location for the driver (it doesn't tell ...
0
votes
2answers
550 views

Oracle 10g on RHEL - All memory gets eaten up nightly at 20.15

Okay, to start things off, I'm brand new to Oracle DB. Much experience with Microsoft products (boo) and Ubuntu linux, but RHEL and Oracle are very new to me. The environment ... Oracle DB 10g ...
3
votes
1answer
462 views

CPU Sockets vs. Cores

We are looking at software that is licensed by socket. Right now our hypervisor (EXSi) underutilizes the 2 socket 8 core processing power it has. Most guests only have 4 virtual cores. In order be ...
0
votes
2answers
226 views

Fail to create temp files in Oracle 10g

My disk is full so I delete oracle temp files to gain space. I use oragle 10g with CentOS release 4.4 Operation System. First Search temp files SELECT tablespace_name, file_name, bytes FROM ...
-1
votes
2answers
598 views

How to create running live server images Windows 2003 Server?

We have Windows 2003 Server (Oracle, Exchange 2003) running on old hardware and these are very critical servers. My company is not investing in IT department. I am looking full server live IMAGE on ...
1
vote
1answer
542 views

Sun Fire X4200 (not M2) Firmware (BIOS/ILOM)?

i've running BIOS/ILOM 1.0 and it sucks with the hyperthreading sync error flood :( I just got my hands on a nice Sun Fire x64 server but I'm in a bit of a bind.  I need BIOS and ILOM files for a Sun ...
1
vote
2answers
106 views

What if I follow Oracle Instructions for hostname [duplicate]

Oracle Docs requiring Hostname to be FQDN. What do you think? Not really what I want to do but... should I? Verifying Host Names Use the following to verify host name settings: For Oracle Linux 4 ...
0
votes
1answer
138 views

Remove some entries from oracle DMP file

I have a DMP file from a production database that i'm trying to import into a testing environment. The DMP file was exported with exp (full backup). I no longer have access to the production database ...
0
votes
1answer
93 views

Prevent UNDOTBS to abort import

I have a dumpfile that I want to import in an Oracle 10g database in a virtual machine (with limited disk space). The dump file is about 3.5GB. When I try to import the dump, the size of the ...
0
votes
3answers
748 views

How do I redirect Weblogic logging to database?

Is there a way to send or redirect Weblogic (or Fusion Middleware) logging output to a database, without having to write a custom application? All the documentation I've read seem to deal exclusively ...
1
vote
1answer
580 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 ...
3
votes
2answers
3k views

Oracle Linux 6 kernel panic boot - anything I can do?

I'm running Oracle Linux 6 on a HP Proliant server. It's been running fine for the last week, but seemed slow earlier so the Oracle service was stopped. Rather than restart the service, I was asked to ...
2
votes
2answers
3k views

How do I (or is it advisable) downgrade Redhat Enterprise from 5.9 to 5.8 and find out when the original upgrade happened?

Two fold question. How do I find out when the upgrade from 5.8 to 5.9 happened? Where is this logged? What is the process of rolling back or downgrading from 5.9 to 5.8? Background: Supporting a ...
1
vote
1answer
859 views

Anyway to find out who shutdown oracle database

In my oracle database alert log file, I saw someone issued the command to shutdown oracle database. I am not able to find out what caused this. Is there a way to find out which user/program that ...
-2
votes
2answers
48 views

Do any versions of Oracle have a user limit? [closed]

I'm not sure which version of Oracle we have at Work (Enterprise or Standard), but do either of them have a limit on how many user accounts you can create?
1
vote
0answers
382 views

SSD Performance under Oracle

I have serious performance issues with oracle running over ssd. I have two OCZ Vertex 3 MAX IOPS drives (firmware 2.15). It runs on a INTEL C600 SATA Chipset. Windows 2008 R2. So the issue is ...
0
votes
1answer
480 views

Oracle connection failure to service with 'HA Events=True' in connection string

I'm assuming this is a configuration problem. Some background. I'm running a Windows 7 VM with VM Player. I've installed Oracle 11gR2 within the VM along with clients, Enterprise Manager, ...
2
votes
1answer
226 views

How to configure multipath using Intel X520-SR2 10GB on Oracle Linux 6.2?

I've installed the Intel x520-sr2 Ethernet/Fibre card into a server that has Oracle Linux 6.2 Installed on it. When I boot the server I can go into a QLogic menu (screen has something for Intel on ...
2
votes
1answer
118 views

puppet templates: possible to print the size of an exported resource array?

I'm writing a puppet module for ocfs2 and making use of exported resources to populate the definitions of all the cluster nodes in the config file on each cluster. This all works well. The cluster ...
0
votes
1answer
785 views

Place for setting environment variables for WebSphere JVM process

I have a websphere application which runs under the user wsadmin. The application invokes the SQL bulk loader client ./sqlldr The sqlldr needs some environment variables predefined in order to work ...
0
votes
1answer
295 views

Where to get FW/BIOS for Sun Fire X4150

I have been trying to get the lastest software for the X4150. I get to this link http://www.oracle.com/technetwork/systems/patches/firmware/release-history-jsp-138416.html#X4150 but it gets me no ...
0
votes
1answer
152 views

Different sqlldr locations on load balanced nodes

We have two nodes in a cluster in a load balancer running third party WebSphere application. We have noticied that ./sqlldr location is different for both the nodes. For one node , its: ...
0
votes
1answer
375 views

install kernel-uek-2.6.32-300.7.1.el5uek.x86_64.rpm fails

While trying to install kernel-uek-2.6.32-300.7.1.el5uek.x86_64.rpm I got following error :( Pls help, really in trouble [root@nonprodsrv02 kdumprpm]# rpm -ivh ...
0
votes
2answers
78 views

Filessystem sizing issues on root

I recently installed a VM version of Oracle Linux 6.3 and began installing applications for testing. I realized that the "/" mount is small and the "/home" mount is way oversized, See output below. ...