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. Most questions about Oracle are better placed at the sister site https://dba.stackexchange.com/
Questions tagged [oracle]
850 questions
-1
votes
1 answer
Unable to connect to an Oracle XE database from Oracle Sql Devloper
I've installed an Oracle 11g XE on a Linux ubuntu 14.04, successfully created a user, and imported a database into it.
my problem is , if when I want create new connection for connect with DATABASE hr for example Bring me a message :
Status :…
![](../../users/profiles/352243.webp)
BkarimCe
- 1
-1
votes
1 answer
Using xhost, display and startx - confused
I have a client A (192.168.1.1)(vncviewer) accessing Server B (192.168.2.1) (RHEL6) to run a installer.
The installation pre-requisite is to set the xhost and DISPLAY properly.
Q1) Please correct me if I am wrong for the following
Xserver should be…
![](../../users/profiles/294202.webp)
Noob
- 363
- 2
- 6
- 16
-1
votes
2 answers
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 daily basis without rebooting system/server.
I…
![](../../users/profiles/163788.webp)
user163788
- 11
- 2
-1
votes
2 answers
display sql syntax in Oracle's sqlplus?
What is in Oracle's sqlplus equivalent of Linux's man or --help ?
When I'm in sqlplus and type help index, I get some commands displayed, but there is no way to get specific sql syntax. For example if I type 'help select' I get:
SP2-0172 No HELP…
![](../../users/profiles/120356.webp)
user1375963
- 1
- 1
-1
votes
1 answer
Recieving ORA-12560: TNS:protocol adapter error on classic ASP same connection in .net works
I have 2 different application installed on a windows 2008 one is .net the other is classic ASP. They would be connecting two different databases however to help trouble shoot the issue I have both connecting to the same database. The .NET app will…
![](../../users/profiles/103879.webp)
mark greer
- 1
- 1
-1
votes
1 answer
problem in run oracle server please help
I used Oracle 11g, from few days ago I face below error:
SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 7 07:33:19 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: pentacms
Enter password:
ERROR:
ORA-01033: ORACLE…
![](../../users/profiles/74205.webp)
Amir
- 143
- 1
- 9
-1
votes
5 answers
What are the most popular database vendors based on market share?
I am wondering if anyone can point me to research or a link to statistics regarding popularity of database deployment. Obviously, MySQL, Oracle, SQLServer are some of the major players but I am looking for actual data on market share. Any data or…
![](../../users/profiles/66906.webp)
nicholasklick
- 123
- 1
- 3
-1
votes
4 answers
time required to Build server configuration
I need an advice on time required to build the following items.
1) oracle 10g installtion
2) Apache web server
3) Solaris OS
4) Setting of backup service for server
5) Big IP Load balancer
A quick response will be appreciated.
![](../../users/profiles/38731.webp)
Rajeev
- 187
- 2
- 9
-1
votes
1 answer
What guidance for page file size and other system parameters for Oracle running on Windows Server 2008
Slightly open ended question, but what are guidelines for configuring windows server 2008 running Oracle?
For example, should the paging file be kept small (1gb) if I've got 32gb of RAM in the server?
Are there any simple parameters to…
![](../../users/profiles/457.webp)
Nick R
- 1,106
- 3
- 14
- 19
-1
votes
1 answer
Users and Roles Extraction in Oracle
I've tried to write a query to have a users/roles extraction, i don't have much SQL skills as well as on oracle, so I started with this:
SELECT A.GRANTEE, A.GRANTED_ROLE, B.ACCOUNT_STATUS FROM DBA_ROLE_PRIVS A
JOIN DBA_USERS B ON A.GRANTEE =…
![](../../users/profiles/501522.webp)
bind2lrz
- 7
- 4
-1
votes
2 answers
Best Practice: Add an Additional Disk to Expand Logical Volume or Expand Existing Disk
We host a client’s Oracle VMs on our Nutanix platform. To date, whenever their VMs require more space they have us add an additional vDisk which they then add to the VG in order to expand the required LV. The reason they’re doing it this way is…
![](../../users/profiles/626876.webp)
Reginald Greyling
- 101
- 2
-2
votes
2 answers
Oracle getting slow
My DB is getting slow on particular weekdays like Saturday and Sunday. What will be the reason?
Database is Oracle 11g R1.
Operating system is Windows 2003 64 Bit Service pack 2.
unknown (google)
-2
votes
1 answer
Why would my Oracle read from disk?
Our Oracle server (version 12c) is running on a RedHat-6.7 server with 128GB of RAM.
The current size of the only database on it is only about 60GB.
Yet, we see plenty of disk reads -- on the device where the database is stored -- in the…
![](../../users/profiles/160236.webp)
Mikhail T.
- 2,272
- 1
- 22
- 49
-2
votes
1 answer
HP Proliant DL380 Gen9
I have HP proliant DL380 Gen9
I do the installation oracle linux 6.4 and installation does not detect the logical drive created. i have 300GB SAS- on raid 0 logical drive
-2
votes
1 answer
SSH - Connection refused
I have setup on a server VMware ESXi 5.5.0. I have add the operating system Oracle Linux 5
I'm trying to setup ssh for local computers that runs on Ubuntu. But I get the error Connection refused.
I checked if the port is open on the server with…
![](../../users/profiles/228061.webp)
Elis
- 1
- 1
- 1