Oracle pulls 100 Programmers From Unfinished Cover Oregon Health insurance Exchange

Oracle Practice Exams

Oracle Corp., the giant technology company at the center of controversy which covers Oregon, has greatly reduced his army of software developers who are trying to save the site health insurance exchange in Oregon.
What it means for the Oregon Exchange – which has been riddled with errors and remains largely unfinished – is an open question. Acting Director Bruce Goldberg Exchange did not respond to a request for comment Wednesday afternoon.
Last week, about 100 employees of Oracle have emerged from the project covering Oregon, leaving about 65 in place. State officials have repeatedly accused his exchange website health failed in Oracle shoddy work and missed deadlines.
Even if the State had failed to pay Oracle, the two sides have maintained a truce with the company agreeing to substantially fix the most serious mistake free, records show. Now, however, the remaining employees of Oracle, according to multiple sources, that only works in the maintenance and operations. This means that the work of the company at the end of the site largely stopped – permanently or not remains unclear.
The coverage change Oregon still allows individual to enroll in health insurance on your own Oregonians , and is available in 49 states and Washington, DC Recently, agents and assistants certified applications earned the use of a password-protected site for beta enroll people in one sitting . Since last Friday, more than 700 people had registered online.
It is unclear whether the extension of Oracle has been mutually agreed by exchange officials and society. A red flag means that exchange officials reportedly had little or no say in where we were Oracle staff and left. This means that the change had little control over what skills will be maintained, including the skills necessary to complete the unfinished project parties.

Several of the functions considered crucial to the site are not done despite being part of Oracle’s initial promises:

  •  Public enrollment was supposed to allow 10,000 people to self-enroll online at the same time. The site has not been certified for public access.
  •  The interfaces with private insurers have not been finished. That means even if an agent enrolls you and gets a success message, in most cases your information still must be sent to insurers using an old-fashioned spreadsheet, for them to upload. The Patient Protection and Affordable Care Act known as Obamacare envisioned the insurer interface as a crucial part of the enrollment process.
  •  The exchange’s interface with the state Medicaid program to get people enrolled in the Oregon Health Plan is also not done. Instead, a backup system in which Cover Oregon sends information to the Oregon Health Authority for manual entry is in place. The backup system has been riddled with problems and reports of applications gone missing or delayed for months.
  •  The portion of Cover Oregon intended for small businesses and their employees to enroll and qualify for tax credits remains unfinished and on hold indefinitely. Much of the programming is untested and was done early on, before problems with allegedly shoddy Oracle programming were discovered by Cover Oregon.
  •  Interfaces with tribal health plans, much like SHOP, remain unfinished and on hold indefinitely.

Cover this fall Oregon has emerged as a political disaster and business, both Oregon and Oracle. Exchange of Oracle stopped paying in September, after it became clear that he could not deliver the change in functional health promised time. The company had already paid more than $ 90 million.

Other politicians have called for the leaders of Oracle solves the problem with the company money. Critics have criticized to be in touch on the cover of Oregon. He admitted that he was in contact, praising the deployment exchange of good Oregon in a speech at the end of October, three weeks after the failure of the launch site.

The state was forced to pay millions of dollars in additional manual application rather than a functional change, recruitment and transfer of more than 400 state employees and processes for the implementation of temporary work.
Oracle has released more bodies at the problem, including some of its experts in high technology. By December, according to the bills of Oracle, which had about 170 companies working on the project covering Oregon, many of billing more than $ 300 per hour.
The company has repeatedly declined to comment.

Goldberg, director of change, said that if the site cannot offer complete self- registration to the public March 31, the exchange should consider alternatives to proceed with Oracle to complete the site. These options could include hiring a different firm to complete the site, or get systems and from other states or the federal government.

This analysis is conducted by the consulting firm Deloitte Technology Inc., which is expanding its presence in Oregon as contracts covering Oracle.
Deloitte served as a systems integrator, or CEO of several exchanges in the state with more success. Oregon made the fateful decision not to hire a systems integrator to monitor your business, instead of putting the project into the hands of Oracle.The state has hired a law firm in Portland to explore possible litigation against Oracle.

 

 

Oracle Patches 144 New Security Vulnerabilities to Start 2014

The New Year starts with a bang Oracle, at least in terms of security updates. In stark contrast to Microsoft, which today published only four security bulletins, Oracle set a staggering 144 new vulnerabilities spread across its range of software as part of its quarterly Critical Patch Update (CPU).

Topping the list of vulnerabilities and the impact of widespread fixed 36 security fixes for Oracle Java. Oracle has started to include security measures as part of the Java version of their main CPU in October 2013. At that time, Oracle has established a total of 127 vulnerabilities in Java that represents 51 of the same.

With the increasing vulnerability of Java January 34 of the 36 defects are remotely exploitable without authentication of the user, then one of the most dangerous types of software defects. Going a step further, Oracle has classified five new vulnerabilities in Java to have the highest possible Common Vulnerability Scoring System (CVSS) score of 10.

Java is one of the pieces more targeted and more suitable software in use today. Several manufacturers, including Hewlett – Packard and Kaspersky Lab, have reported an increase in attacks against Java in 2013. According to Kaspersky , between March and August 2013, there were at least 8.54 million Java exploits attacks. Responsible for the Zero Day Initiative, Hewlett – Packard Safety Research, spoke at length about the exploits of Java during a Black Hat USA 2013. Although Java zero-day exploits are responsible for some of the attacks, most of the attacks are against vulnerabilities that Oracle has patched in a public update, even if users have not updated their systems.

” Unfortunately, being an enterprise Java platform , there are many software vendors that only support older versions ( usable) of Java, ” Tommy Chin , Technical Support at Core Security , told eWEEK . “The companies that own and depend on this type of software are blocked by reordering, because the update will break their existing production Java applications.”

Chin suggests that for those who cannot perform the upgrade, you must check the access control lists are tightly controlled and access to Java applications are facing internal and exposed only through virtual private networks (VPNs).

In addition to Java, Oracle Fusion Middleware Suite is patches for multiple vulnerabilities. Overall, Oracle patched 22 security vulnerabilities in the merger, including 19 remotely exploitable without authentication of the user and a single defect leads to a CVSS score of 10.

The suite of Oracle and Sun Systems products, including the Solaris operating system UNIX, receiving 11 patches, only one of which is remotely exploitable. Oracle breaks now separate corrections for the MySQL database, which came to Oracle through the acquisition of Sun in 2010. MySQL has been scheduled for 18 security vulnerabilities, only one receives the highest CVSS score of 10.
Unlike MySQL, the database with the same name is always just five security patches from Oracle, and only one of the faults is remotely exploitable without authentication of the user.

While Java updates are a priority, so other corrections, Ken Pickering, director of engineering at Core Security, told eWEEK .
” The truth is that many of Oracle’s products are found in many places, holding or standing in front of a lot of critical data. “It’s important to keep these particular applications to date, as many of them are critical to the business.”
Pickering said the fact that Oracle applications are business-critical implementations, in general, it is even more difficult to perform maintenance

Oracle Agrees to Buy Cloud-Based Service

Oracle said Tuesday it had agreed to buy corente , a company based in the cloud, in a move that pushes the time when the technology giant shy elsewhere in the Internet age .

Oracle expects that the ‘ deal to close in the first half of 2014, subject to regulatory approval, according to a presentation on the company’s website. Terms of the acquisition were not disclosed.

It is at least the third major purchase of a cloud-based platform for Oracle, which is a gradual change in strategy in recent years. The company has historically generated most of its revenue from the sale of hardware and software installed, and hesitated in the past to support a business model of competition.

” Oracle customers need solutions that include data center networks and global networks, “Edward Screven, Oracle’s chief corporate architect, said in a statement.”Combining Oracle’s technology portfolio with industry leading network platform corente software-defined global network extends, companies will be able to provide a simple and secure applications and cloud services for their offices distributed throughout the world. ”

Representatives from Oracle are not being reached for further comment.Companies have increasingly turned to cloud-based strategies, enabling companies to streamline various operations into a single digital hub. Oracle, led by billionaire Lawrence J. Ellison, Oracle Public Cloud began in 2011, announcing that the subscription based service provided to customers, ” high performance, a reliable, resilient and secure their business-critical applications.”Corente , a privately held company headquartered in New Jersey, provides technologies for cloud-based companies such as British Telecom and Illinois Tool Works , a manufacturer of equipment delivery , according to the company’s website .

Oracle bought Taleo , a maker of software for human resources in line , for $ 1.9 billion in 2012. Last year, it acquired RightNow Technologies, a maker of customer service software web based, for $ 1.43 billion.The company has purchased the technology companies more than half a dozen last year, including enterprise software company Responsys in December.

Oracle SQL Developer 4.0 Enhances Support for Oracle Database 12c

News Summary

To effectively manage the data needs of today’s changing, developers and database administrators have easy to use tools to speed up and simplify the development and management of data. The latest version of the IDE, Oracle SQL Developer 4.0, accelerates the adoption of Oracle Database 12c and helps to increase productivity for a list of all the activities of the development of databases that organizations can take advantage of the full power of enterprise data.

Oracle Databass

News Facts

  • Oracle today announced the release of Oracle SQL Developer 4.0, enhanced with new functionality to simplify the development and management of Oracle Database environments.
  •  Supporting new innovations in Oracle Database 12c, including its multitenant architecture and data redaction, Oracle SQL Developer 4.0 helps developers and database administrators increase productivity and performance.
  • The latest generation of the world’s #1 database, Oracle Database 12c is designed for the cloud with an innovative, multitenant architecture.
  • By leveraging the migration tooling included in Oracle SQL Developer 4.0, customers can realize a significant decrease in the cost of migrating legacy systems and applications as less custom coding and database development is required.

Updates to SQL Developer Tool Drive Database Adoption and Productivity

Oracle SQL Developer 4.0 incorporates significant new functionality, enabling users to:

  • Managing Databases pluggable data: new tools to effectively manage multi-user architecture 12c Oracle Database developers can create, manage and connect databases in the cloud.
  • Improves Report: Dozens of additional graphics options allow developers to deliver rich, easy to interpret reports for internal users and partners.
  • Accelerate development: an improved interface for reporting and testing from the command line allows developers to create functions directly in the processes and automated tasks, accelerating the development process.
  • Improved Code: Developers enjoy technology Source Control GIT popular support as well as many new features to support code to identify syntax errors before running the code.
  • Migration rate: a new tool for managing SQL translation framework initially be available for Microsoft SQL Server and Sybase ASE T-SQL SAP to help developers to quickly migrate from third-party platforms for Oracle Database 12c with a native version of SQL .

The standard development tool of choice for Oracle Database customers, Oracle SQL Developer 4.0 is downloadable today from the Oracle Technology Network (OTN).
Supporting Quote

“Harnessing the power of business data has never been easier to over 3.3 million developers using Oracle SQL Developer, “said Michael Hichwa, vice president of software development at Oracle.” Leveraging Oracle SQL Developer 4.0 free support in Oracle Database 12c, organizations can be the basis of world’s most powerful data quickly and easily. ”

  • Oracle SQL Developer 4.0
  • Oracle Database 12c
  •  Podcast: What’s New in Oracle SQL Developer 4.0
  • Podcast: Oracle SQL Developer 4.0 in Action at the City of Atlanta

About Oracle
Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE: ORCL), visit www.oracle.com
Trademarks
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owner

Oracle’s Ellison gives up $500m to settle Pillar Data Systems claim

Oracle Chief Executive Larry Ellison has agreed to give up a payout reaching potentially $500 million to settle a dispute based around conflict of interest when Oracle purchased a firm that he controlled.

Oracle

In 2011 , Oracle has agreed to buy Pillar Data Systems. The company was controlled by Oracle CEO Ellison founded in 2005 and has personally contributed $ 150 million to start the business .

Instead of paying cash up front , Oracle has agreed to buy data storage company through certain future payments based on performance Pillar Data Systems ” until 2014 . A part of the transaction, Ellison would receive the first $ 562 million of any payments related to the acquisition , according to court documents consulted by Reuters.

However, the case against the acquisition – launched by shareholders and pension funds of the Retirement System City of Employees and Transport Authority of Southeastern Pennsylvania – said the deal was ” contaminated by conflicts of interest and that it was unfair Oracle ” . During a hearing in August last year, concerns have been raised about the fact that “it was a legitimate business and if anyone can get a better deal . “

Oracle Announces CX @ OpenWorld at Oracle San Francisco 2013

With key technological trends, such as, furniture, large social data and cloud transform how organizations interact with their customers, it is more important than ever for managers to understand how to apply the customer experience and CRM best practices. To help executives stay up to date with the latest trends and become leaders in their field, will CX @ Oracle OpenWorld Oracle OpenWorld San Francisco 2013. Through a combination of technology and strategy sessions, mini-presentations, workshops, demonstrations and interactive journey mapping, CX @ OpenWorld help organizations in their efforts to provide the customer experience.

Oracle Certification

News Facts

  • To help its customers to become a leader in customer experience, CX @ OpenWorld Oracle announced to be held in San Francisco, September 23 – 26, 2013 during the Oracle OpenWorld 2013.
  • Bringing together leading brands and experts to address the challenges that organizations face with your customer experience program, CX @ OpenWorld include informative lectures, group seminars, demonstrations and networking opportunities.
  • With over 140 sessions across the CX strategy and design, marketing, sale, trade, services, industry and social signals, CX @ OpenWorld equips organizations with a combination of strategy and technology to deliver the business results they want, with the ‘experience that customers want.
  • Oracle executives and strategic partners of Oracle presented complete cloud portfolio and on-premise applications that offers the most comprehensive customer experience in the industry, allowing companies to differentiate into all channels and interactions.
  • In addition, participants will have the opportunity to learn more about Oracle CX vision of Oracle and how it is addressing the major trends in the management of the customer experience, including mobile, social and big data cloud.
  • Sponsorship and exhibition opportunities CX @ OpenWorld are available on the event website:
  • http://www.oracle.com/openworld/exhibit/index.html#cx.
  • Registration for Oracle OpenWorld is now open.

Oracle Exam

 

Supporting Quote

  • “CX @ OpenWorld help leaders from all sectors of the industry to implement best practices and take advantage of the latest technologies in its facilities and in the cloud to create the best customer experience,” said Ken Fox, Senior Vice President Product Development, Oracle. “With a combination of interactive workshops, the main information, demonstrations and networking opportunities, participants will have the opportunity to learn how they can take advantage of trends such as big data and the cloud to develop and execute successful strategies from experience customer’s mobile society “.

Short Guide to install Oracle 10 on Linux

This guide is a short description how to install Oracle 10.2.0.x on Linux (32 or 64 Bit).

In this guide we use the following ORACLE_BASE, ORACLE_HOME and ORACLE_SID.

  • ORACLE_BASE=/export/home/oracle
  • export ORACLE_HOME=$ORACLE_BASE/product/10.2.0
  • export ORACLE_SID=GENTIC

Download

Download the following software from the Oracle Download or Metalink Site

  • 10201_database_linux32.zip (Base Software)
  • 10201_companion_linux32.zip (Companion Software)
  • p6810189_10204_Linux-x86.zip (Patchset)

After downloading check the CKSUM / MD5SUM as described on Oracle’s Site.

cksum 10201_database_linux32.zip
md5sum
 p6810189_10204_Linux-x86.zip

Requirements

Checking Memory and Swap Space

Oracle says that the system must have at least 1GB of physical RAM and 1GB of swap space or twice the size of RAM. And for systems with more than 2 GB of RAM, the swap space can be between one and two times the size of RAM. You might also want to check out sizing swap space.

To check the size of physical memory, execute:

grep MemTotal /proc/meminfo
MemTotal: 515700 kB

To check the size of swap space, execute:

grep SwapTotal /proc/meminfo
SwapTotal: 1004052 kB

You also can add temporary swap space to your system by creating a temporary swap file instead of using a raw device. Here is the procedure:

su – root
c
d /root
dd if=/dev/zero of=/root/tmpswp bs=1k count=500000

500000+0 records in
500000+0 records out

chmod 600 tmpswp
mkswap tmpswp

Setting up swapspace version 1, size = 511995 kB
swapon tmpswp
grep SwapTotal /proc/meminfo
SwapTotal: 1504044 kB

Checking /tmp Space

The Oracle Universal Installer requires up to 400 MB of free space in the /tmp directory. If you do not have enough space in the /tmp filesystem, you can temporarily create a tmp directory in another filesystem. Here is how you can do this (/u01 is another filesystem)

su – root
mkdir /u01/tmp
chown root:root /u01/tmp
chmod 1777 /u01/tmp
export TEMP=/u01

export TMPDIR=/
u01

When you are done with the Oracle installation, shutdown Oracle and remove the temporary /tmp directory:

su – root
rmdir /u01/tmp
unset TEMP
unset TMPDIR

Checking Kernel Parameters (Values from Oracle Site for 10.2.0.x)

To see all kernel parameters, execute:

su – root
sysctl -a

Make sure that the core shown in the following Table is set to a value greater than or equal to the recommended value is displayed. Do not change the value of any kernel parameter to a system where it is already higher than listed as minimum requirement.

Parameter Value File
semmsl

semmns

semopm

semmni

250

32000

100

128

/proc/sys/kernel/sem
shmall 2097152 /proc/sys/kernel/shmall
shmmax Half the size of physical memory (in bytes) /proc/sys/kernel/shmmax
shmmni 4096 /proc/sys/kernel/shmmni
file-max 65536 /proc/sys/fs/file-max
ip_local_port_range Minimum:1024

Maximum: 65000

/proc/sys/net/ipv4/ip_local_port_range
rmem_default 1048576 /proc/sys/net/core/rmem_default
rmem_max 1048576 /proc/sys/net/core/rmem_max
wmem_default 262144 /proc/sys/net/core/wmem_default
wmem_max 262144 /proc/sys/net/core/wmem_max

 

We added the following lines to the /etc/sysctl.conf file which is used during the boot process:

# Kernel Parameters for Oracle 10.2.0
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144

Adding these lines to the /etc/sysctl.conf file will cause the system to change these kernel parameters after each boot using the /etc/init.d/bootmisc script which is invoked by /etc/inittab. But in order that these new added lines or settings in /etc/sysctl.conf become effective immediately, execute the following command:

Configuring kernel parameters:

su – root
sysctl -p

Creating Oracle User Account

To create the oracle account and group(s), execute the following commands:

su – root
groupadd -g 400 dba
useradd -u 400 -g 400 -d /export/home/oracle -s /bin/bash -c “Oracle Owner” oracle

Members of the dba group can administer Oracle databases, for example starting up and shutting down databases. In this guide, we are creating the oracle user account to have this responsibility.

Note on the «oinstall» Group

The oinstall group is often needed for those organizations who have separate groups that maintain the software and the database. In this scenario, the group membership prevents unauthorized access to the database by personnel who maintain the software, and it prevents the database administrators from making changes to the software and the installations inventory directory.

When using oinstall during the install of the software, one must set their default group to the one that will be maintaining the database before creating the database or permission problems will arise.

Oinstall is not needed when the same people will be maintaining the software and the database. In this situation, it will create more work and add an extra layer of complexity to the maintenance of the installation.

Recommendation: if you don’t need the oinstall group for added security,  just install using the dba group.

Setting Shell Limits for the Oracle User

Most shells like Bash provide control over various resources like the maximum allowable number of open file descriptors or the maximum number of processes available to a user.

To see all shell limits, run:

ulimit -a

Setting Limits for the Oracle User

After you changed and increased /proc/sys/fs/file-max, there is still a per user limit of open file descriptors which is set to 1024 by default:

su – oracle
ulimit -n
1024

To change this, you have to edit the file /etc/security/limits.conf as root and make the following changes or add the following lines, respectively:

# To increase the shell limits for Oracle 10
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

The «soft limit» in the first line defines the number of file handles or open files that the Oracle user will have after login. If the Oracle user gets error messages about running out of file handles, then the Oracle user can increase the number of file handles like in this example up to 63536 («hard limit») by running the following command:

ulimit -n 63536

Note that we do not recommend to set the «hard limit» for nofile for the oracle user equal to/proc/sys/fs/file-max. If you do that and the user uses up all the file handles, then the system would run out of file handles. This could mean that you won’t be able to initiate new remote logins any more since the system won’t be able to open any PAM modules which are required for performing a login. That’s why we set the hard limit to 63536 and not to 65536.

You also need to make sure that pam_limits is configured in the file /etc/pam.d/system-auth. This is the PAM module that will read the /etc/security/limits.conf file. The entry should read like:

session required pam_limits.so
session required pam_unix.so

Now login to the oracle account again since the changes will become effective for new login sessions only.

su – oracle
ulimit -n
4096

Make Settings Permanent

For the Bourne, Bash, or Korn shell, add the following lines to the $HOME/.bash_profile

if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ]; then
ulimit -p 16384
ulimit -n 63536
else
ulimit -u 16384 -n 63536
fi
fi

Setup Environment

Before installing the Oracle software, set the environment in $HOME/admin/.GENTIC, this file will be sourced each time after login. In the example below, gentic is the SID of the database which we will create.

cd $HOME
. ./.gentic

ls -l
drwxr-xr-x   4 oracle dba  4.0K Sep 26 14:51 admin
lrwxrwxrwx   1 oracle dba    15 Oct  2 10:18 .gentic -> admin/.gentic

cat .gentic

#!/bin/bash

unset TWO_TASK

export ORACLE_SID=GENTIC
export LISTENER_NAME=$ORACLE_SID
export ORACLE_BASE=/export/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0
export ORACLE_DOC=$ORACLE_HOME/doc
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export TNS_ADMIN=/export/home/oracle/admin/sqlnet

export PATH=$ORACLE_HOME/bin:$PATH
export NLS_LANG=american_america.al32utf8
export ORA_NLS10=$ORACLE_HOME/nls/data
export TEMP=/tmp
export TMPDIR=/tmp
export EDITOR=vi

ulimit -u 16384 -n 63536

Installing Oracle Base, Companion and Patch

This is only a brief description of the installation, the screenshots are not shown, however note the following important issues.

  • Order of the Installation
  1. Install Base Product (10.2.0.1)
  2. Install Companion Disk to avoid NCOMP error
  3. Install Patch (10.2.0.4)
  • Do not create a Database using Oracle installer, this is an extra step, install software only.
  • Create the Oracle Inventory in $ORACLE_BASE/product.
  • Choose «Oracle Database 10g Products 10.2.0.1.0» option when installing companion

Create Oracle Home Directories

Oracle Installer does not create Oracle Base / Oracle Home directories.

mkdir -p /export/home/oracle/product/10.2.0

Start Installer

As Oracle10g is certified only on some Linux editions you may get the following error when you run Oracle’srunInstaller, and installation will stop:

Checking operating system version: must be redhat-2.1,
UnitedLinux-1.0 or redhat-3
Failed <<<<

Solution: Use the option -ignoreSysPrereqs or edit/create the file /etc/redhat-release.

cd <unpacked directory>
DISPLAY=<my X-Window Host>:0.0
export DISPLAY
./runInstaller

Create Inventory in: /export/home/oracle/product

The location of the Oracle Inventory can always be checked in the file /etc/oraInst.loc

cat /etc/oraInst.loc

inventory_loc=/export/home/oracle/product
inst_group=dba

Oracle Companion Products

Choose «Oracle Database 10g Products 10.2.0.1.0» option, to avoid NCOMP error.

Cleanup $ORACLE_HOME/bin

After the installation some non used files in $ORACLE_HOME/bin can be removed.

cd $ORACLE_HOME/bin
rm *O
rm *0

Create the Listener

You can generate the needed files or you can create them manually. Put them in $TNS_ADMIN, but create symbolic links from $ORACLE_HOME/network/admin to these files, because some tools do not consult$TNS_ADMIN environment variable.

Example of LISTNER.ORA

# ————————————————————————–
# File:        listener.ora
#
# Purpose:     Configuration file for Net Listener
#
# Location:    $TNS_ADMIN
#
# Certified:   Oracle 10.2.0.3 on Oracle Enterprise Linux 5
# ————————————————————————–

GENTIC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBHOST.EXAMPLE.COM)(PORT = 25000))
(ADDRESS = (PROTOCOL = IPC)(KEY = GENTIC.EXAMPLE.COM))
)
)

SID_LIST_GENTIC  =
(SID_LIST =
(SID_DESC =
(SID_NAME = GENTIC)
(GLOBAL_DBNAME = GENTIC.EXAMPLE.COM)
(ORACLE_HOME = /export/home/oracle/product/10.2.0)
)
)

LOG_DIRECTORY_GENTIC = /export/home/oracle/admin/sqlnet
TRACE_FILE_GENTIC = gentic.trc

Example of TNSNAMES.ORA

# ————————————————————————–
# File:        tnsnames.ora
#
# Purpose:     Configuration File for all Net Clients
#
# Location:    $TNS_ADMIN
#
# Certified:   Oracle 10.2.0.3 on Oracle Enterprise Linux 5
# ————————————————————————–

GENTIC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBHOST.EXAMPLE.COM)(PORT = 25000))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GENTIC.EXAMPLE.COM)
)
)

Example of SQLNET.ORA

# ————————————————————————–
# File:        sqlnet.ora
#
# Purpose:     Configuration File for all Net Clients
#
# Location:    $TNS_ADMIN
#
# Certified:   Oracle 10.1.0.3 on RedHat Enterprise 5
# ————————————————————————–

NAMES.DIRECTORY_PATH= (TNSNAMES)

Create Symbolic Links

cd $ORACLE_HOME/network/admin

lrwxrwxrwx 1 oracle dba listener.ora -> /export/home/oracle/admin/sqlnet/listener.ora
lrwxrwxrwx 1 oracle dba sqlnet.ora -> /export/home/oracle/admin/sqlnet/sqlnet.ora
lrwxrwxrwx 1 oracle dba tnsnames.ora -> /export/home/oracle/admin/sqlnet/tnsnames.ora

Start and show status of Listener GENTIC

lsnrctl start GENTIC
lsnrctl status GENTIC

Create Database

We recommend to generate the create scripts using Oracle DBCA. These scripts should be verified because they show man important issues – important to know for every DBA. Based on these scripts, we created our own initSID.sql and initSID.ora to create the database. In the subdirectory addons all optional parts of the database can be found and installed using install-addons.bash

Edit initSID.ora and initSID.sql for your needs

Adjust and check the parameters for your environment, for example all PATH must be changed, the value ofSGA_TARGET and SGA_MAX_SIZE must be set according your physical memory, etc.

The files can be found in:

$ORACLE_BASE/admin/GENTIC/scripts/initGENTIC.sql
$ORACLE_BASE/admin/GENTIC/pfile/initGENTIC.ora

Enable Remote Administration with SYSDBA Privileges

If you want to manage all of your Oracle databases from one place and not have to log on to each host, you must do it via a network connection. For example to remotely administer RMAN through a network connection, you need such an environment. To enable remote administration you have to two things:

1. Create a password file on each target database.
2. Enable remote logins for password file users.

To create the password file, as the Oracle software owner or as a member of the DBA group:

cd $ORACLE_BASE/admin/GENTIC/pfile
orapwd file=orapwGENTIC password=xxxx entries=5 force=y

After you create a password file, you need to enable remote logins. To do this, set the instance’sREMOTE_LOGIN_PASSWORDFILE initialization parameter in INIT.ORA to exclusive, as shown:

remote_login_passwordfile = exclusive

Setting this parameter to exclusive signifies that only one database can use the password file and that users other than SYS can reside in it. You can now use a network connection to connect to your target database as SYSDBA.

sqlplus “sys/xxxx@<SERVICE> as sysdba”

Create Symbolic Links

Create symbolic links from $ORACLE_HOME/dbs as follows:

cd $ORACLE_HOME/dbs
lrwxrwxrwx  orapwGENTIC -> /export/home/oracle/admin/GENTIC/pfile/orapwGENTIC
lrwxrwxrwx  initGENTIC.ora -> /export/home/oracle/admin/GENTIC/pfile/initGENTIC.ora

Create the Database

First start the Instance, just to test your INIT file for correct syntax and system resources.

cd $ORACLE_BASE/admin/GENTIC/scripts
sqlplus /nolog
SQL> connect / as sysdba
SQL> startup nomount
SQL> shutdown immediate

Now you can create the database

SQL> @initGENTIC.sql
SQL> @shutdown immediate
SQL> startup

Check the Logfile: initGENTIC.log

Create additional Products in the Database (optional)

If you do not want all additional products to be installed, uncomment them in install-addons.bash.

cd $ORACLE_BASE/admin/GENTIC/scripts/addons
./install-addons.bash

Create Server Parameter File

Server parameter files let you make persistent changes to individual parameters. When you use a server parameter file, you can specify in an ALTER SYSTEM SET parameter statement that the new parameter value should be persistent. This means that the new value applies not only in the current instance, but also to any instances that are started up subsequently. Traditional client-side parameter files do not let you make persistent changes to parameter values.

cd $ORACLE_HOME/dbs
rm initGENTIC.ora

sqlplus / as sysdba
SQL> create spfile = ‘/export/home/oracle/admin/GENTIC/pfile/spfileGENTIC.ora’
        from pfile = ‘/export/home/oracle/admin/GENTIC/pfile/initGENTIC.ora’;
File created.
SQL> exit;

ln -s /export/home/oracle/admin/GENTIC/pfile/spfileGENTIC.ora spfileGENTIC.ora
sqlplus / as sysdba
SQL> shutdown immediate;
SQL> startup;
SQL> exit;

Automatically Start / Stop the Database and Listener

If you want to start the database automatically on boot-time perform the following steps:

  1. Copy standard oracle scripts dbstart and dbshut to $ORACLE_BASE/admin
  2. Create start/stop script in /etc/init.d
  3. Activate this start/stop script with chkconfig
  4. Edit /etc/oratab to start/stop the desired Databases

Copy standard oracle scripts dbstart and dbshut to $ORACLE_BASE/admin

cd $ORACLE_HOME/bin
cp dbstart dbshut $ORACLE_BASE/admin

Create start/stop script in /etc/init.d as user root.

#!/bin/bash
#
# chkconfig: 12345 99 10
# description: Oracle auto start-stop script
# --------------------------------------------------------------------------
# File:        oracle
#
# Purpose:     Oracle auto start-stop script
#
# Location:    /etc/init.d
#
# Certified:   Oracle 10.2.0.3 on Enterprise Linux 5
# --------------------------------------------------------------------------
# Variables
ORACLE_OWNER=oracle; export ORACLE_OWNER
ORACLE_BASE=/export/home/oracle; export ORACLE_BASE
ORACLE_SCRIPTS_DIR=$ORACLE_BASE/admin; export ORACLE_SCRIPTS_DIR
ORACLE_HOME=$ORACLE_BASE/product/10.2.0; export ORACLE_HOME
# Source function library.
. /etc/rc.d/init.d/functions
# Source networking configuration.
[ -f /etc/sysconfig/network ] && . /etc/sysconfig/network
RETVAL=0
prog="oracle"
start() {
   echo -n $"Starting $prog: "
   if [ ! -f $ORACLE_SCRIPTS_DIR/dbstart ]
   then
        echo "Oracle not started (no dbstart script)"
   else
        # Start RDBMS
        su - $ORACLE_OWNER -c $ORACLE_SCRIPTS_DIR/dbstart
        # Start Enterprise Manager Console
        # su - $ORACLE_OWNER $ORACLE_HOME/bin/emctl start dbconsole
        # Start iSQL*Plus
        # su - $ORACLE_OWNER $ORACLE_HOME/bin/isqlplusctl start
   fi
   RETVAL=$?
   [ $RETVAL -eq 0 ] && touch /var/lock/subsys/oracle
   return $RETVAL
}
stop() {
   echo -n $"Shutting down $prog: "
   if [ ! -f $ORACLE_SCRIPTS_DIR/dbshut ]
   then
        echo "Oracle not stopped (no dbshut script)"
   else
        # Stop iSQL*Plus
        # su - $ORACLE_OWNER $ORACLE_HOME/bin/isqlplusctl stop
        # Stop Enterprise Manager Console
        # su - $ORACLE_OWNER $ORACLE_HOME/bin/emctl stop dbconsole
        # Stop RDBMS
        su - $ORACLE_OWNER -c $ORACLE_SCRIPTS_DIR/dbshut
   fi
   RETVAL=$?
   [ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/oracle
   return $RETVAL
}
# See how we were called.
case "$1" in
  start)
        start
        ;;
  stop)
        stop
        ;;
  *)
        echo $"Usage: $0 {start|stop}"
        exit 1
esac
exit $RETVAL

Activate this start/stop script with chkconfig as root as follows

su – root
chkconfig –add oracle
chkconfig –list oracle

Edit /etc/oratab to start/stop the desired databases

su – root
cat /etc/oratab

# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:

GENTIC:/export/home/oracle/product/10.2.0:Y

Activate Enterprise Manager Console

Create the repository for the enterprise manager console as follows:

emca -repos create
emca -config dbcontrol db

Try to connect to the database control as follows:

http://<db-host&gt;:1158/em

Automatically start and stop the DB-console

emctl start dbconsole
emctl stop dbconsole
emctl status dbconsole