Tuesday, May 26, 2015

What am I worth?

What should I pay?

Database Administrator (DBA) Salary
(United States)

A Database Administrator (DBA) earns an average salary of $69,472 per year. People in this job generally don't have more than 20 years' experience. The skills that increase pay for this job the most are UNIX and Oracle.

$43K

$55K

$69K

$85K

$99K

MEDIAN: $69,471

10%

25%

50%

75%

90%

Add this chart to your site:

640px

300px

Show Hourly Rate

	National Salary Data (?)	$0	$50K	$100K	$150K
Salary	$43,264 - $99,026
Bonus	$0.00 - $9,880
Profit Sharing	$769 - $8,357
Total Pay (?)	$40,310 - $102,592
Country: United States \| Currency: USD \| Updated: 2 May 2015 \| Individuals Reporting: 4,101

Job Description for Database Administrator (DBA)

A Database Administrator’s main task is to maintain and support the large files that contain a company’s business information. His or her responsibility is to ensure that the information contained in those files is constantly available to the users of that information. The Database Administrator implements, configures, and troubleshoots database instances, replication, backup, partitions, storage, and access. The DBA is responsible for monitoring and optimizing system performance using index tuning, disk optimization, and other methods. The Database Administrator is the person responsible for setting user privileges within the database environment. The tools used in performing these tasks are the various database software packages that are available in the market such as RDBMS (Relational Database Management Systems) and the like. The main skills required for this position include a demonstrated knowledge of the leading database software packages and utilities, and a proven familiarity with programming concepts. In addition, this role requires the utmost attention to detail and the ability to multitask. At a minimum, a certification in Database Administration is essential for this position, although having a college degree is a big advantage. The Database Administrator usually works in an office setting together with the rest of the technical staff with whom he or she constantly interacts. The people a DBA typically interacts with are the Business Analysts, Systems Programmers and the users, who are mostly the customers and employees of the company. The Database Administrator usually reports to a technical manager, such as the Chief Information Officer. Many established businesses with large-scale information systems usually hire a Database Administrator to manage their file system. In most cases, a Database Administrator maintains a regular work schedule; however, he may be required to perform certain maintenance work during off-hours, and on weekends or holidays. The Database Administrator is also oftentimes required to go on an on-call schedule in order to troubleshoot problems that can occur with the company files.

Database Administrator (DBA) Tasks

Monitor and optimize system performance using index tuning, disk optimization, and other methods.
Install, configure, troubleshoot, and maintain a database system.
Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access.
Set user privileges within the database environment.

Common Career Paths for Database Administrator (DBA)

Add this chart to your site: 640px

640px

300px

Plan your career path. Drag job titles to investigate a particular path and click on a link to see where particular career can lead.

Database Administrator (DBA) Job Listings

Database Administrator (PostgreSQL DBA)

May 21

Kforce Inc. - Atlanta, GA

RESPONSIBILITIES Kforce has a client seeking a Database Administrator (Postgre. SQL DBA) in Atlanta, Georgia (GA).... - Indeed

Apply For This Job »

Senior Oracle Database Administrator - DBA

Apr 28

Verizon Wireless - Alpharetta, GA

The Oracle DBA will work as a member of the Enterprise Database administration team to support VZW business internal/external systems providing the following... - Indeed

Apply For This Job »

Informix Database Administrator (DBA)

May 08

Net2Source - United States

Informix Database Administrator (DBA). Builds technology roadmaps which are incorporated into Informix database designs. Total Experience Required.... - Indeed

Apply For This Job »

View More Jobs »

jobs by

Search for more jobs:

Popular Employer Salaries for Database Administrator (DBA)

Popular Skills for Database Administrator (DBA)

This chart shows the most popular skills for this job and what effect each skill has on pay.

Pay by Experience Level for Database Administrator (DBA)

Median of all compensation (including tips, bonus, and overtime) by years of experience.

Pay Difference by Location

▲40%

▲15%

▲14%

▲14%

▲14%

▲11%

▲9%

▲9%

▼-3%

▼-3%

National Average: $69,026

Larger city markers indicate a job is popular in that location.

Learn about cost of living by city »

Database Administrator (DBA) Reviews

What is it like working as a Database Administrator (DBA)?

Database Administrator (DBA) in Allentown:

"Demanding Stress In Corporate Culture Doing The Work Of Three People."

Pros: Challenging, rewarding, lots to learn, variety of tasks, direct mail, database, fundraising.

Cons: Hourly position but work is salary work. Doing the work of 3 different people, not enough time to do the work required. Work environment is stressful. Not appreciated by upper management.

Related Job Salaries

Sunday, May 24, 2015

Oracle Linux Installation Pre-install package Public Yum Server

Public Yum Server

Last updated: 22 September, 2014

Introduction

Yum uses a configuration file at /etc/yum.conf.

The Oracle public yum server offers a free and convenient way to install the latest Oracle Linux packages as well as packages from the Oracle VM installation media via a yum client.
You can download the full Oracle Linux and Oracle VM installation media via edelivery.oracle.com/linux. To stay current on errata updates, you may wish to subscribe to the Oracle Linux errata mailing list.
This yum server is offered without support of any kind. If you require support, please consider purchasing Oracle Linux Support via the online store, or via your sales representative.

Getting Started

Download and Install Oracle Linux

Download and copy the appropriate yum configuration file in place, by running the following commands as root:

Oracle Linux 7

# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol7.repo

Oracle Linux 6

# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol6.repo

Oracle Linux 5

# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-el5.repo

Oracle Linux 4, Update 6 or Newer

# cd /etc/yum.repos.d
# mv Oracle-Base.repo Oracle-Base.repo.disabled
# wget http://public-yum.oracle.com/public-yum-el4.repo

Oracle VM 2

# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ovm2.repo

Oracle OpenStack for Oracle Linux

# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-openstack-ol6.repo

Enable the appropriate repository by editing the yum configuration file
- Open the yum configuration file in a text editor
- # vi /etc/yum.conf.
- # PUT YOUR REPOS HERE OR IN separate files named file.repo
- directory=/etc/yum.repos.d
  enable=1
- Locate the section in the file for the repository you plan to update from, e.g. [el4_u6_base]
- Change enabled=0 to enabled=1
Begin using yum, for example:
yum list
yum install firefox

You may be prompted to confirm the import of the Oracle OSS Group GPG key.

Frequently Asked Questions

Where can I learn more about Oracle Linux?

A: You can read a summary of features and specifications here. Additional technical information about Oracle Linux is available on OTN's Linux Technology Center.

Where can I learn more about Oracle Linux Support?

A: You can read more about Oracle Linux Support at oracle.com/linux, For white papers, data sheets, FAQs and other technical information, see the Linux Technology Center

Where can I learn more about Oracle VM?

A: You can read more about Oracle VM here. For technical information about Oracle VM, see the Oracle VM product page on OTN

Where can I learn more about Oracle OpenStack for Oracle Linux?

A:You can read more about Oracle OpenStack for Oracle Linux here . For technical information about Oracle OpenStack for Oracle Linux, see the product page on OTN

Where can I find the source code for these binaries?

A: This yum server offers source packages as well as binary packages. We also provide the source packages for Oracle Linux 4, Oracle Linux 5, Oracle Linux 6 and Oracle VM on oss.oracle.com, Oracle's portal for all of its free and open source software contributions.

Where can I get help getting this yum repository to work?

A: This yum server is provided for free and without support. You may use the Oracle Technology Network Linux Forum, where other users are ready and willing to help.

Where can I learn more about yum?

A: There are several resources available on the the Web. Here is an overview of basic yum commands

How can I be notified of Oracle Linux Errata?

A: To subscribe to Oracle Linux errata notifications via email, go here. You can also stay on top of Oracle Linux errata via Twitter: @orcl_uln

How can I use public-yum to update Oracle VM 3 Server?

A: To update Oracle VM Server to 3.2.x using public-yum use http://public-yum.oracle.com/repo/OracleVM/OVM3/latest/x86_64/ as YUM Base URL and http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5 as YUM GPG Key in Oracle VM Manager. For details please refer to Oracle VM Installation and Upgrade Guide for Release 3.2.

To upgrade from Oracle VM Server 3.2 or 3.1 to Oracle VM Server 3.3, please refer to Oracle VM Installation and Upgrade Guide for Release 3.3 for detailed instructionss, and please do not use public-yum directly.
To update Oracle VM Server 3.3 to the latest 3.3.x using public-yum use http://public-yum.oracle.com/repo/OracleVM/OVM3/3x_latest/x86_64/ as YUM Base URL and http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 as YUM GPG Key in Oracle VM Manager. For details please refer to Oracle VM Installation and Upgrade Guide for Release 3.3.

How can I convert an RHEL or RHEL-compatible system to Oracle Linux using public-yum?

A: Download and verify the Oracle Linux GPG Key that best matches your RHEL-compatible release and then follow the "Getting Started" instructions above.

Red Hat Enterprise Linux 4, Update 6 or Compatible

# wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el4 -O /usr/share/rhn/RPM-GPG-KEY-oracle
# gpg --quiet --with-fingerprint /usr/share/rhn/RPM-GPG-KEY-oracle
pub  1024D/B38A8516 2006-09-05 Oracle OSS group (Open Source Software group) 
     Key fingerprint = 1122 A29A B257 825F 322C  234E 2E2B CDBC B38A 8516
sub  2048g/0042D4F4 2006-09-05 [expires: 2011-09-04]

Red Hat Enterprise Linux 5 or Compatible

# wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
# gpg --quiet --with-fingerprint /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
pub  1024D/1E5E0159 2007-05-18 Oracle OSS group (Open Source Software group) 
      Key fingerprint = 99FD 2766 28EE DECB 5E5A  F5F8 66CE D3DE 1E5E 0159
sub  1024g/D303656F 2007-05-18 [expires: 2015-05-16]

Red Hat Enterprise Linux 6 or Compatible

# wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
# gpg --quiet --with-fingerprint /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
pub  2048R/EC551F03 2010-07-01 Oracle OSS group (Open Source Software group) 
      Key fingerprint = 4214 4123 FECF C55B 9086  313D 72F9 7B74 EC55 1F03

Red Hat Enterprise Linux 7 or Compatible

# wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol7 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
# gpg --quiet --with-fingerprint /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
pub  2048R/EC551F03 2010-07-01 Oracle OSS group (Open Source Software group) 
      Key fingerprint = 4214 4123 FECF C55B 9086  313D 72F9 7B74 EC55 1F03

Browse the Repositories

Name	Last Modified	Size
beta/	25-Feb-2015 17:46	-
docker-images/	01-Dec-2014 18:25	-
repo/	05-Dec-2013 21:14	-
RPM-GPG-KEY-oracle-el4	26-Oct-2006 23:50	1.7 K
RPM-GPG-KEY-oracle-el5	11-Nov-2007 14:01	1.4 K
RPM-GPG-KEY-oracle-ol6	05-Feb-2011 06:07	1.0 K
RPM-GPG-KEY-oracle-ol7	22-Jul-2014 17:54	1.0 K
public-yum-el4.repo	19-Jul-2013 17:28	1.2 K
public-yum-el5.repo	20-Feb-2015 23:01	5.2 K
public-yum-ol6.repo	29-Jan-2015 21:15	4.9 K
public-yum-ol7.repo	11-Mar-2015 15:08	2.3 K
public-yum-openstack-ol6.repo	22-Sep-2014 20:19	0.4 K
public-yum-ovm2.repo	19-Jul-2013 17:28	1.4 K

Monday, May 18, 2015

ORA-27125: unable to create shared memory segment Linux-x86_64

This question has been Answered.

Edit two files

1. /etc/security/limits.conf

2. /etc/sysctl.conf

Example

# nano /etc/security/limits.conf

#<domain>

<value>

#*	soft	core	0
#*	hard	rss	10000
#@student	hard	nproc	20
#@faculty	soft	nproc	20
#@faculty	hard	nproc	50
#ftp	hard	nproc	0
#@student	-	maxlogins	4

#adding the following 2 entries as per SAP Note: 797084

*	hard	nofile	32800
*	soft	nofile	32800

# End of file

2. Find and edit sysctl.conf
Nano /etc/sysctl.conf
net.ipv4.icmp_echo_ignore_broadcasts = 1
net.ipv4.conf.all.rp_filter = 1
#net.ipv6.conf.all.forwarding = 1
fs.inotify.max_user_watches = 65536
net.ipv4.conf.default.promote_secondaries = 1
net.ipv4.conf.all.promote_secondaries = 1
#kernel.shmmax = -1
kernel.sem = 1250 256000 100 8192
#kernel.shmall = 1152921504606846720
vm.max_map_count = 300000
vm.hugetlb_shm_group = 1
kernel.threads-max = 8167
kernel.shmmax = 68719476736
kernel.shmall = 4294967296

database creation TNS04404 no error

database creation TNS04404 no error

1. delete tnsname.ora

Example
# del /home/oracle/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsname.ora

2.Edit hosts files with simply localhost.localdomain localhost

Example

$ nano /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

10.2.5.126 localhost localhost.localdomain localhost

3. Edit /etc/hostname

$ nano /etc/hostname

localhost.localdomain

Ctrl-O Enter (saves)
Ctrl-X (exits)

TNS-04404: no error caused by: oracle.net.config.ConfigException: TNS-04414: File error caused by: TNS-04612

This error is seen in Oracle 10gR2, on tnsnames.ora alias definition error during database creation. The error is likely to report SQL*Net alias in tnsnames.ora file.
Look for “DESCRIPTION” line in the alias, add a space if “DESCRIPTION” in line with alias and a space between “DESCRIPTION” and “=” sign.
Example:
DEV =
(DESCRIPTION =
/
(ADDRESS = (PROTOCOL = TCP)(HOST =dev-vip)(PORT = 1521))
Restart database creation.

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

0 down vote favorite

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

I'm having a problem with an Oracle database. Yesterday everything was working fine, I had an application that was using the database and there was no problem. At the end of the day I installed MySQL on the same server (I don't think it can be related but anyway..) and had to restart the server. Today when I was using my application to access the Oracle database I had a connection error:

Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error: 
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Then I went to the server. All the services are up and the database is down.
When I try to login normally, I get an error saying that Oracle is not available, and can only connect as sysdba. Then when I try to start the database up I get the following errors:
SQL Plus console display

Any help is apreciated. Thanks in advance!

asked May 13 '14 at 11:41

Pedro Mendes
113

migrated from stackoverflow.com May 13 '14 at 13:43

This question came from our site for professional and enthusiast programmers.

add a comment

2 Answers

active oldest votes

up vote 0 down vote

Did you set the ORACLE_SID? I think the problem is there

answered May 13 '14 at 17:38

eliatou
1846

This should be a comment. Unless you are sure it is the correct answer to the problem. – ypercube May 13 '14 at 17:59

Yes, I had the ORACLE_SID and ORACLE_HOME set. – Pedro Mendes May 14 '14 at 8:27

Ok sorry, I'm new here and don't know the exact rules to post! – eliatou May 14 '14 at 9:07

add a comment

up vote 0 down vote accepted

Well, my teammate found the answer to the problem.
He changed some details in the file 'tnsnames.ora' at ORACLE_HOME\NETWORK\ADMIN. He just replaced “hostname” by “localhost”.
WP5 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = WP5)
)
)
LISTENER_WP5 =  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
A new startup (without leaving sqlplus) made it work!
Oracle success console message

PS: We still have no ideia why/how it was working before, since the file updated date dates from about 2 weeks ago.

Tuesday, May 26, 2015

Database Administrator (DBA) Salary (United States)

Job Description for Database Administrator (DBA)

Database Administrator (DBA) Tasks

Common Career Paths for Database Administrator (DBA)

Database Administrator (DBA) Job Listings

Search for more jobs:

Popular Employer Salaries for Database Administrator (DBA)

Popular Skills for Database Administrator (DBA)

Pay by Experience Level for Database Administrator (DBA)

Pay Difference by Location

Database Administrator (DBA) Reviews

Related Job Salaries

Sunday, May 24, 2015

Oracle Linux Installation Pre-install package Public Yum Server

Public Yum Server

Introduction

Yum uses a configuration file at /etc/yum.conf.

Getting Started

Oracle Linux 7

Oracle Linux 6

Oracle Linux 5

Oracle Linux 4, Update 6 or Newer

Oracle VM 2

Oracle OpenStack for Oracle Linux

Frequently Asked Questions

Where can I learn more about Oracle Linux?

Where can I learn more about Oracle Linux Support?

Where can I learn more about Oracle VM?

Where can I learn more about Oracle OpenStack for Oracle Linux?

Where can I find the source code for these binaries?

Where can I get help getting this yum repository to work?

Where can I learn more about yum?

How can I be notified of Oracle Linux Errata?

How can I use public-yum to update Oracle VM 3 Server?

How can I convert an RHEL or RHEL-compatible system to Oracle Linux using public-yum?

Red Hat Enterprise Linux 4, Update 6 or Compatible

Red Hat Enterprise Linux 5 or Compatible

Red Hat Enterprise Linux 6 or Compatible

Red Hat Enterprise Linux 7 or Compatible

Browse the Repositories

Monday, May 18, 2015

ORA-27125: unable to create shared memory segment Linux-x86_64

database creation TNS04404 no error

TNS-04404: no error caused by: oracle.net.config.ConfigException: TNS-04414: File error caused by: TNS-04612

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

migrated from stackoverflow.com May 13 '14 at 13:43

2 Answers

Database Administrator (DBA) Salary
(United States)