Oracle 10g Rel 2 on SLES 10.0
Installation Prepation
Hardware and Software check
Software Installation
Patch Oracle Database Software
Create Database
Install Oracle HTTP Server
Next Posts:
Install BI Publisher
Automate Startup/Shutdown
Install Oracle Workflow
The Installation of Oracle Application Express consists of Installation of PL/SQL Packages and other DB Objects (Users, Tables, Indexes ...) and Configuration of Oracle HTTP Servers modplsql module.
Download the Installation and Documentation Files:
Oracle Application Express 3.0.1
Following Steps will be executed as user oracle.
Connect to Linux Box as user oracle:
vl094:~ # ssh -Xl oracle vl094
Password:
Last login: Tue Sep 25 17:26:20 2007 from vl094.fla.net
oracle@vl094:~>
Unzip the file apex_3.0.1.zip and change directory to apex.
You cann access the Documentation using the HTML file welcome.html.
Start SQLPLUS and install Apex in the database.
oracle@vl094:~/apex> sqlplus
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Sep 25 19:06:55 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> @apexins qwertz SYSAUX SYSAUX TEMP /i/
Check the spool file install
Following steps will be executed as user orahs - Oracle HTTP Server software owner.
Connect to Linux Box as User orahs:
vl094:~ # ssh -Xl orahs vl094
Password:
Last login: Tue Sep 25 17:48:34 2007 from vl094.fla.net
orahs@vl094:~>
Copy the Image File to Apach Directory:
orahs@vl094:~> cp -rf /appl/home/oracle/apex/images/ $ORACLE_HOME/Apache/Apache/
Create the tnsnames.ora file with connection string to DB094.
orahs@vl094:~> cat /appl/orahs/product/10.2.0/db_1/network/admin/tnsnames.ora
DB094 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vl094.fla.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB094.fla.net)
)
)
Check the connection with the DB:
orahs@vl094:~> sqlplus system/qwertz@DB094
SQL*Plus: Release 10.1.0.3.0 - Production on Tue Sep 25 20:04:23 2007
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
orahs@vl094:~>
Modify the dads.conf file:
orahs@vl094:~> cat /appl/orahs/product/10.2.0/db_1/Apache/modplsql/conf/dads.conf
# ============================================================================
# mod_plsql DAD Configuration File
# ============================================================================
# 1. Please refer to dads.README for a description of this file
# ============================================================================
# Note: This file should typically be included in your plsql.conf file with
# the "include" directive.
# Hint: You can look at some sample DADs in the dads.README file
# ============================================================================
Alias /i/ "/appl/orahs/product/10.2.0/db_1/Apache/Apache/images/"
AddType text/xml xbl
AddType text/x-component htc
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString DB094 TNSFormat
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword qwertz
Allow from all
</Location>
Restart the Oracle HTTP Server:
orahs@vl094:~> /appl/orahs/product/10.2.0/db_1/opmn/bin/opmnctl stopall
opmnctl: stopping opmn and all managed processes...
orahs@vl094:~> sleep 60
orahs@vl094:~> /appl/orahs/product/10.2.0/db_1/opmn/bin/opmnctl startall
opmnctl: starting opmn and all managed processes...
Connect to APEX on http://vl094:7780/pls/apex/apex_admin.
Form: Application Express Administration Service
Enter Usename ADMIN, Password qwertz.
Press Login.
-----------------------------------------------------------------------------------
Form: Change Password.
I entered 3 times the value qwertz.
Press "Apply Changes".
-----------------------------------------------------------------------------------
form: Change Password.
Press "Return"
-----------------------------------------------------------------------------------
Form: Application Express Administration Services.
Enter username ADMIN and password qwertz.
Press "Login".
-----------------------------------------------------------------------------------
Form: Application Express Administration.
Press "Logout".
-----------------------------------------------------------------------------------
Congratulation: Oracle Application Axpress is installed!
Regards,
Flavio
10 comments:
Hi, I tried to follow the installation steps for the Oracle Http server - so made a new user ( seperate from the Oracle user etc), unzip the companion cd .
But when I run the runInstaller, I get an error saying can not write to the directory /opt/oracle/....
That dir opt/oracle is where I installed the 10g db in. But why is a totally new user "orahs" referring to the place where Oracle db was installed ? how is/does it pick up this reference ?
managed to install Apex but when I do opmn startall then then tey and access the apex_admin page, I get the error Service Temporarily down.
I looked in the Apache log files and in there is says http-503 ORA-604.
I dont know how to resolve this . anyone have any ideas of what this could be ?
managed to install Apex but when I do opmn startall then then tey and access the apex_admin page, I get the error Service Temporarily down.
I looked in the Apache log files and in there is says http-503 ORA-604.
I dont know how to resolve this . anyone have any ideas of what this could be ?
Got it working.
The issue is the NLS_LANG setting .
You need to set the NLS_LANG in the actual Linux console you use to issue opmnctl startall command.
So doing this ;
export NLS_LANG=American_America.AL32UTF8
and then having the same line in the dads.conf file in the folder
Apache/modplsql/conf
fixed it.
TARA REID DESNUDA
[url=http://www.projectopus.com/user/58283]TARA REID DESNUDA[/url]
TARA REID DESNUDA
[url= http://www.projectopus.com/user/58283 ] TARA REID DESNUDA [/url]
OLSEN TWINS NUDITY
[url=http://www.projectopus.com/user/58285]OLSEN TWINS NUDITY[/url]
OLSEN TWINS NUDITY
[url= http://www.projectopus.com/user/58285 ] OLSEN TWINS NUDITY [/url]
WOMEN CELEBRITIES EXPOSED
[url=http://www.projectopus.com/user/58287]WOMEN CELEBRITIES EXPOSED[/url]
WOMEN CELEBRITIES EXPOSED
[url= http://www.projectopus.com/user/58287 ] WOMEN CELEBRITIES EXPOSED [/url]
KATE MARA NAKED
[url=http://www.projectopus.com/user/58289]KATE MARA NAKED[/url]
KATE MARA NAKED
[url= http://www.projectopus.com/user/58289 ] KATE MARA NAKED [/url]
OLSEN TWINS VIRGINS
[url=http://www.projectopus.com/user/58293]OLSEN TWINS VIRGINS[/url]
OLSEN TWINS VIRGINS
[url= http://www.projectopus.com/user/58293 ] OLSEN TWINS VIRGINS [/url]
Good day
Use http://www.BuySellDirect.net as a FREE home based ebay to make money at home. It is 100% free.
http://www.BuySellDirect.net 100% free service is all you need to make money every month.
Hi!
One of my friends sends me an email telling me that I can sell some of used clothing on http://www.BuySellDirect.net FREE service and make money at home, tell know I made over one thousand dollar, and it is time to tell you, why you should use Ebay to sell your things when you can use http://www.BuySellDirect.net free.
http://www.BuySellDirect.net is what Ebay users need to save paying charges when they sell or not.
CELEBRITY UPSKIRTS
[url=http://videoexclg71.vidiLife.com]CELEBRITY UPSKIRTS[/url]
CELEBRITY UPSKIRTS
[url= http://videoexclg71.vidiLife.com ] CELEBRITY UPSKIRTS [/url]
DENISE RICHARDS PLAYBOY
[url=http://videoexclg72.vidiLife.com]DENISE RICHARDS PLAYBOY[/url]
DENISE RICHARDS PLAYBOY
[url= http://videoexclg72.vidiLife.com ] DENISE RICHARDS PLAYBOY [/url]
JENNIFER ANNISTON NUDE
[url=http://videoexclg73.vidiLife.com]JENNIFER ANNISTON NUDE[/url]
JENNIFER ANNISTON NUDE
[url= http://videoexclg73.vidiLife.com ] JENNIFER ANNISTON NUDE [/url]
JENNIFER LOPEZ ASS
[url=http://videoexclg74.vidiLife.com]JENNIFER LOPEZ ASS[/url]
JENNIFER LOPEZ ASS
[url= http://videoexclg74.vidiLife.com ] JENNIFER LOPEZ ASS [/url]
CHRISTINA AGUILERA NAKED
[url=http://videoexclg75.vidiLife.com]CHRISTINA AGUILERA NAKED[/url]
CHRISTINA AGUILERA NAKED
[url= http://videoexclg75.vidiLife.com ] CHRISTINA AGUILERA NAKED [/url]
CARMEN ELECTRA PLAYBOY
[url=http://videoexclg76.vidiLife.com]CARMEN ELECTRA PLAYBOY[/url]
CARMEN ELECTRA PLAYBOY
[url= http://videoexclg76.vidiLife.com ] CARMEN ELECTRA PLAYBOY [/url]
MARISA MILLER NUDE
[url=http://videoexclg77.vidiLife.com]MARISA MILLER NUDE[/url]
MARISA MILLER NUDE
[url= http://videoexclg77.vidiLife.com ] MARISA MILLER NUDE [/url]
SARAH MICHELLE GELLAR NUDE
[url=http://videoexclg78.vidiLife.com]SARAH MICHELLE GELLAR NUDE[/url]
SARAH MICHELLE GELLAR NUDE
[url= http://videoexclg78.vidiLife.com ] SARAH MICHELLE GELLAR NUDE [/url]
MINI ME SEX TAPE
[url=http://videoexclg79.vidiLife.com]MINI ME SEX TAPE[/url]
MINI ME SEX TAPE
[url= http://videoexclg79.vidiLife.com ] MINI ME SEX TAPE [/url]
ADRIANA LIMA NUDE
[url=http://videoexclg80.vidiLife.com]ADRIANA LIMA NUDE[/url]
ADRIANA LIMA NUDE
[url= http://videoexclg80.vidiLife.com ] ADRIANA LIMA NUDE [/url]
[b][url=http://wiki.mangotele.com/index.php?title=hermes_purses_outlet_at_mlovebag.com]designer handbags for less[/url][/b] mentioned within your provincial city of La Plata, Fernández de Kirchner was trainees activist inside the 1970s who actually promoted the Perónist costume party as well as,while compared with a navy dictatorship which in fact had ' fortitude for the purpose of dissent. she achieved her life partner during legal requirement training center there, as well as wedding ceremony two traveled using them in the direction of Patagonian province regarding father christmas johnson, these guys put together an connections that will early took over the area's political surface. He was elected each of our province's governor, and she in order to become its actual senator.
[b][url=http://eyeuser.com/blogs/viewstory/1256268]hermes shop[/url][/b] although enroll in, that you are required so as to outline an interest plan online survey,Bvlgari the world with tasks in addition to model could be most like your very own? more and more deciphering navigators, sincerely turn up in the same way if appendage of the send. along with analyzing affiliate products and programs to get your web-service,Louis Vuitton totes prompted you don't get from carried out moreover systematically think do you know the alternatives 're varied supplies. you you noticed.
[b][url=http://socialnetwork.stock-options-picks.com/blogs/viewstory/105304]chanel bags for sale[/url][/b] If you are searching for good ways to attract a female you now the right place. with time share with you best teasing regarding men. an ideal plan depending on how to flirt with a girl and how to seduce women. because, humans thrived, predominately by using goodhealth, however just up until the exact seventies. that whenever health professionals ascertained all their promote area of interest by way of pretendingthey wore located ldl cholesterol. abruptly that you had a cure for everybody,especially people who endured by no means asked eating better.
Post a Comment