Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

HandsonERP - Oracle E-Business Suite Training
Welcome, Guest
Please Login or Register.    Lost Password?
Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.
Go to bottom Post Reply Favoured: 1
TOPIC: Enterprise Manager
#1366
luke_vickery (User)
Fresh Boarder
Posts: 15
graphgraph
User Offline Click here to see the profile of this user
Enterprise Manager 8 Years, 10 Months ago  
Hi All

Anyone know how to access the enterprise manager or install it on Linux.

I have completely installed EBS on Linux using the excellent step by step guide on this website.
Please give complete beginnner step as my knowledge of Linux is worse than 'basic'!!!!
Thanks in Advance
Luke
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1375
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Enterprise Manager 8 Years, 10 Months ago  
Here is the installation guide: http://download.oracle.com/docs/cd/E11857_01/index.htm

Here is the forum for Oracle Enterprise Manager support: http://forums.oracle.com/forums/forum.jspa?forumID=220&start=0

My 2 cents: If you wish to become expert on Oracle Financials implementation, then forgot by Enterprise Manager and focus on learning the setups of EBS. Consider learning Oracle Enterprise manager if you wish to move forward more on DBA route.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1447
luke_vickery (User)
Fresh Boarder
Posts: 15
graphgraph
User Offline Click here to see the profile of this user
Re:Enterprise Manager 8 Years, 10 Months ago  
Hi Hasan,

Thanks for your input and I think you are right and I am getting ahead of myself.
Alternatively I would like use SQLplus or isqlplus but I can't seem to connect through the linux terminal. Any suggestions?

Thanks Luke
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1461
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Enterprise Manager 8 Years, 9 Months ago  
Sorry for the late reply.
You need to source the .env file first found in your application root folder. Then type sqllplus. It should work.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1462
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Enterprise Manager 8 Years, 9 Months ago  
cd PROD
cd apps
cd apps_st
. PROD_linux.env
sqlplus
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1486
luke_vickery (User)
Fresh Boarder
Posts: 15
graphgraph
User Offline Click here to see the profile of this user
Re:Enterprise Manager 8 Years, 9 Months ago  
Hi Hasan,

Thank you for your reply but I am still unable to access SQLPLUS.
I have added below the terminal listing to show the various solutions I have tried.

Thanks Luke



[Oracle@linux appl]$ ../PROD_linux.env
bash: ../PROD_linux.env: No such file or directory
[Oracle@linux appl]$ .PROD_linux.env
bash: .PROD_linux.env: command not found
[Oracle@linux appl]$ cd
[Oracle@linux ~]$ cat .profile
cat: .profile: No such file or directory
[Oracle@linux ~]$ which sqlplus
/usr/bin/which: no sqlplus in (/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/Oracle/bin)
[Oracle@linux ~]$ /usr/bin/sqlplus
bash: /usr/bin/sqlplus: No such file or directory
[Oracle@linux ~]$ find / -name sqlldr -print 2> /dev/null
/home/Oracle/PROD/db/tech_st/11.1.0/bin/sqlldr
/home/Oracle/PROD/db/tech_st/11.1.0/md/demo/network/examples/sqlldr

/home/Oracle/PROD/apps/tech_st/10.1.2/bin/sqlldr
[Oracle@linux ~]$
Checked the access rights to file
-rw-r--r-- 1 Oracle Oracle 17284 Jun 14 2010 PROD_linux.env



Started database, listerner and ran master script

[Oracle@linux ~]$ cd
[Oracle@linux ~]$ cd PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_linux
[Oracle@linux PROD_linux]$ ./addbctl.sh start PROD

You are running addbctl.sh version 120.1


Starting the database PROD ...


SQL*Plus: Release 11.1.0.7.0 - Production on Sun Dec 26 16:06:25 2010

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected to an idle instance.
ORACLE instance started.

Total System Global Area 523108352 bytes
Fixed Size 1314492 bytes
Variable Size 427819332 bytes
Database Buffers 79691776 bytes
Redo Buffers 14282752 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

addbctl.sh: exiting with status 0

[Oracle@linux PROD_linux]$ ./addlnctl.sh start PROD

You are running addlnctl.sh version 120.1.12010000.2

Logfile: /home/Oracle/PROD/db/tech_st/11.1.0/appsutil/log/PROD_linux/addlnctl.txt

Starting listener process PROD ...


addlnctl.sh: exiting with status 0
[Oracle@linux PROD_linux]$ cd
[Oracle@linux ~]$ cd PROD/inst/apps/PROD_linux/admin/scripts
[Oracle@linux scripts]$ ./adstrtal.sh apps/apps

You are running adstrtal.sh version 120.15

The logfile for this session is located at /home/Oracle/PROD/inst/apps/PROD_linux/logs/appl/admin/log/adstrtal.log
Executing service control script:
/home/Oracle/PROD/inst/apps/PROD_linux/admin/scripts/adopmnctl.sh start
script returned:
****************************************************

You are running adopmnctl.sh version 120.6

Starting Oracle Process Manager (OPMN) ...

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /home/Oracle/PROD/inst/apps/PROD_linux/logs/appl/admin/log/adopmnctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/home/Oracle/PROD/inst/apps/PROD_linux/admin/scripts/adalnctl.sh start
script returned:
****************************************************

adalnctl.sh version 120.3

Checking for FNDFS executable.
Starting listener process APPS_PROD.

adalnctl.sh: exiting with status 0


adalnctl.sh: check the logfile /home/Oracle/PROD/inst/apps/PROD_linux/logs/appl/admin/log/adalnctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/home/Oracle/PROD/inst/apps/PROD_linux/admin/scripts/adapcctl.sh start
script returned:
****************************************************

You are running adapcctl.sh version 120.7.12010000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...

adapcctl.sh: exiting with status 150

adapcctl.sh: check the logfile /home/Oracle/PROD/inst/apps/PROD_linux/logs/appl/admin/log/adapcctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/home/Oracle/PROD/inst/apps/PROD_linux/admin/scripts/adoacorectl.sh start
script returned:
****************************************************

You are running adoacorectl.sh version 120.13

Starting OPMN managed OACORE OC4J instance ...

adoacorectl.sh: exiting with status 150

adoacorectl.sh: check the logfile /home/Oracle/PROD/inst/apps/PROD_linux/logs/appl/admin/log/adoacorectl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/home/Oracle/PROD/inst/apps/PROD_linux/admin/scripts/adformsctl.sh start
script returned:
****************************************************

You are running adformsctl.sh version 120.16

Starting OPMN managed FORMS OC4J instance ...

adformsctl.sh: exiting with status 150

adformsctl.sh: check the logfile /home/Oracle/PROD/inst/apps/PROD_linux/logs/appl/admin/log/adformsctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/home/Oracle/PROD/inst/apps/PROD_linux/admin/scripts/adoafmctl.sh start
script returned:
****************************************************

You are running adoafmctl.sh version 120.8

Starting OPMN managed OAFM OC4J instance ...

adoafmctl.sh: exiting with status 150

adoafmctl.sh: check the logfile /home/Oracle/PROD/inst/apps/PROD_linux/logs/appl/admin/log/adoafmctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/home/Oracle/PROD/inst/apps/PROD_linux/admin/scripts/adcmctl.sh start
script returned:
****************************************************

You are running adcmctl.sh version 120.17.12010000.3

Starting concurrent manager for PROD ...
Starting PROD_1226@PROD Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0


adcmctl.sh: check the logfile /home/Oracle/PROD/inst/apps/PROD_linux/logs/appl/admin/log/adcmctl.txt for more information ...


.end std out.

.end err out.

****************************************************


Executing service control script:
/home/Oracle/PROD/inst/apps/PROD_linux/admin/scripts/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 120.3

Validating Fulfillment patch level via /home/Oracle/PROD/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for PROD on port 9300 ...

jtffmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************



adstrtal.sh: Exiting with status 4

adstrtal.sh: check the logfile /home/Oracle/PROD/inst/apps/PROD_linux/logs/appl/admin/log/adstrtal.log for more information ...



TRY AGAIN

[Oracle@linux scripts]$ cd
[Oracle@linux ~]$ cd PROD
[Oracle@linux PROD]$ ls
apps db inst
[Oracle@linux PROD]$ cd apps
[Oracle@linux apps]$ ls
apps_st tech_st
[Oracle@linux apps]$ cd apps_st
[Oracle@linux apps_st]$ ls
appl comn
[Oracle@linux apps_st]$ cd comn
[Oracle@linux comn]$ ls
admin cz java _pages _TldCache webapps
clone exclude.xml mvtaglib temp util
[Oracle@linux comn]$ cd PROD/apps/apps_st/appl
bash: cd: PROD/apps/apps_st/appl: No such file or directory
[Oracle@linux comn]$ cd
[Oracle@linux ~]$ cd PROD/apps/apps_st/appl
[Oracle@linux appl]$ ls
ad ast crp ddr fpa hri igf jtf ont PROD_linux.env wps
admin au cs dna frm hxc igi jtm opi prp wsh
ahl ax csc dom fte hxt igs lns ota psa wsm
ak az csd dpp ftp ia igw mfg ozf psb xdo
alr ben cse dt fun ibc imc mrp pa psp xdp
ame bic csf eam fv ibe inl msc pay pv xla
ams bil csi ebi gcs ibp inv msd per qa xle
amv bim csl ec ghr ibu ipa mso pft qot xnb
amw bis csm ecx gl ibw ipm msr pji qp xnp
ap biv csp edr gma iby irc mst pjm qpr xtr
APPSPROD_linux.env bix csr ego gmd icx isc mth pmi qrm zpb
ar bne cua eng gme ieb ita mwa pn rg zx
as bom cuf eni gmf iec itg oe po rlm
asf bsc cug fa gmi iem izu okc poa rrs
asg cct cui fem gml ieo ja oke pom sht
asl ce cup ff gmo ies je oki pon ssp
asn chv cus fii gmp ieu jg okl pos vea
aso cln cz flm gms iex jl oks pqh wip
asp cn ddd fnd gr igc jmf okx pqp wms
[Oracle@linux appl]$ .PROD_linux.env
bash: .PROD_linux.env: command not found
[Oracle@linux appl]$ sqlplus
bash: sqlplus: command not found
[Oracle@linux appl]$ ../PROD_linux.env
bash: ../PROD_linux.env: No such file or directory
[Oracle@linux appl]$

_linux.env
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1508
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Enterprise Manager 8 Years, 9 Months ago  
Looks like you are not entering the command properly to source the environment file.
You are entering ".PROD_linux.env"
While you need to enter ". PROD_linux.env" (look at the space)
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1515
luke_vickery (User)
Fresh Boarder
Posts: 15
graphgraph
User Offline Click here to see the profile of this user
Re:Enterprise Manager 8 Years, 9 Months ago  
Found the problem:
It was the db PROD_linux.env file I needed not the apps.
Found another file at PROD/db/tech_st/11.1.0/
Thanks for your input
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1540
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Enterprise Manager 8 Years, 9 Months ago  
It works with apps file as well, at least for me.
Good to know that your SQLPLUS is working now.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop