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.
0
votes
1answer
16 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
14 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 ...
-1
votes
0answers
12 views
Create an sql script that compares two schemas and updates schema and insert date of update in a column in oracle 11g [closed]
Hi i need some help creting an sql script that can update info from one table in dbase1 to another table in dbase2 that has the same columns and if posible insert date and time in one column when the ...
0
votes
0answers
37 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
0answers
106 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 ...
1
vote
0answers
39 views
Consideration adding a server into domain [closed]
we just passed from eDirectory to Active Directory. All our computers are migrated (added to the domain). Now we planned to add our servers to the domain.
Servers are running MSSQL, Apache2, Lotus ...
-1
votes
0answers
16 views
writing a join query in oracle11g [closed]
i have to do a query in oracle 11g
but i really dont have any idea.would you please help me?
i want to cumpute the percentage of believers of every religion from the world’s population
...
0
votes
0answers
10 views
syntax error in a join query [migrated]
I have a query here:
For each country in America, give the highest mountain and its height; ordered by height.
and tables:
encompasses : country,continent
geo_mountain: mountain,country
...
-3
votes
0answers
55 views
What is dangerous about opening your Oracle g11 database for external connection [closed]
How safe is it to create an Oracle database on Oracle Linux and open it for public?
The only danger where I can think of is that someone will steal data. Are there any other risks? Is it for example ...
0
votes
0answers
31 views
PLSQL-Developer debug session crashed > database slowed down > restart VM> ORA-01034 & ORA-27101 (Oracle 11G- WIN7)
I recently started a debug session to debug a package function,
this session crashed the PLSQL-Developer at one of the first lines (that havent changed & always worked fine (its ony variable ...
0
votes
1answer
23 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
37 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
0answers
57 views
Integrating SAP Business One with Google Apps
We are planning on integrating Google Apps at a site with SAP business one.
I don't know SAP B.O. well but it includes an exchange connector I've been told.
What is the best way to get these to ...
0
votes
0answers
20 views
oracle ovm “enable vm to sniff other machine traffic/ add vnic in promiscous mode”
i need to setup snort ids in a virtual network using ORACLE OVM invironment . so the snort interface must be promiscous and enable to see all the traffic of other machines.
i have set the debian ...
0
votes
2answers
106 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
102 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
69 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 ...
-2
votes
2answers
72 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 ...
0
votes
0answers
32 views
Oracle 9 connect timeout
I have an Oracle 9 database server on Windows XP on VMWare ESX.
Oracle seems configured correctly, but outside the machine, I get a timeout.
TNS names are ok, and I get a reply from tnsping (and I ...
1
vote
1answer
89 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 ...
0
votes
0answers
31 views
Max FQDN size in Oracle
Our domain suffix is 26 characters long and our server naming convention is for 8 character hostnames. This leads to a FQDN of 35 characters. When we install Oracle (v10 on RHEL5), emca barfs on the ...
1
vote
2answers
58 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
56 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
0answers
66 views
Is it safe to restart multipathd while volumes are being used
Forgive me if this is a completely idiotic question. Trying to reload an updated multipath.conf configuration to attach a new LUN and I need to restart multipathd. Is this a terrible idea if the ...
0
votes
0answers
37 views
oracle enterprise manager plugins
We are developing a plug-in for Oracle Enterprise manager that is trying to access a web service. The plug-in for Oracle Enterprise manager is developed using flex builder. From the plug-in we are ...
-1
votes
1answer
76 views
How Log shipping works on secndary Oracle DB [closed]
We are located here in Canada and have an Oracle system in Europe which we are looking to prepare a DR system. The ideal is to have the DR system here in head office (Canada) but question would be ...
0
votes
0answers
27 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
0answers
165 views
Oracle UPK: HTTP request is unauthorized with client scheme 'Negotiate'
This is my first post. I have searched high and low for a possible solution to this, but so far have come up empty. Oracle support also has not been very helpful (yet anyway).
Below is an excerpt ...
0
votes
3answers
135 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 ...
0
votes
0answers
79 views
M5000 how to split with this configuration
We are using an M5000 with 2 Systemboards (8 CPU & 4 Memoryboard with 64gb) + 2 IO boards
What possibilities would I have?
Is it possible to configure the following?
Domain 0
5 CPU
3 ...
1
vote
1answer
114 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 ...
2
votes
2answers
489 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
721 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
94 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
40 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?
0
votes
0answers
109 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
75 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
116 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
65 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
113 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
113 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
63 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
0answers
120 views
TPC benchmarks for MySQL and PostgreSQL database
Are there any existing TPC benchmarks for MySQL and PostgreSQL DBMS?
Is there a lack of benchmarks just because it is too expensive to run or because the database performance is not up to par with ...
0
votes
1answer
131 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
57 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.
...
0
votes
0answers
100 views
ORA-00942: table or view does not exist & ORA-01031: insufficient privileges
I can't access any tables on my oracle database.
When selecting the table product I get ORA-00942: table or view does not exist
I have tried this solution but I don't have sufficiënt rights to add a ...
0
votes
1answer
66 views
JBoss 5.1.0 GA configuration for Oracle Data Guard
Can someone please point me to some tutorial or "how to" for configuring Jboss to work along with Oracle Data Guard. Motivation behind this is pretty standard, move some of the users to read from the ...
1
vote
1answer
122 views
Root SSH login works, but su/sudo to root does not work
Im recently working on a clients box, and SSH into the box with root credentials work but when i try to su or sudo to root user it states incorrect password. I tried changed the root password and know ...
0
votes
0answers
96 views
EM Agent Installation Failed (Forms and Reports 11gR2 11.1.2)
I'm new in the oracle world and i have a problem during the installation of Oracle Forms and Reports 11gR2.
I installed weblogic server 10.3.6 without a domain configuration, later when i was trying ...
1
vote
0answers
67 views
iPlanet Authentication provider
Good day. I have stepped into project that requires a server migration that would change the means of authentication for our CAC/PKI SSL enabled website. We are using iPlanet 7 and Oracle Directory ...
