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: Re:Enterprise Manager
#1486
luke_vickery (User)
Fresh Boarder
Posts: 15
graphgraph
User Offline Click here to see the profile of this user
Re:Enterprise Manager 13 Years, 3 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.
      Topics Author Date
    emo
Enterprise Manager Favorite
luke_vickery 2010/12/01 17:21
    thread link
thread linkthread link Re:Enterprise Manager
handsonerp 2010/12/06 15:18
    thread link
thread linkthread link Re:Enterprise Manager
luke_vickery 2010/12/18 17:39
    thread link
thread linkthread linkthread link Re:Enterprise Manager
handsonerp 2010/12/27 15:01
    thread link
thread linkthread linkthread linkthread link Re:Enterprise Manager
handsonerp 2010/12/27 15:04
    thread link
thread linkthread linkthread linkthread linkthread link Re:Enterprise Manager
luke_vickery 2010/12/28 12:32
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:Enterprise Manager
handsonerp 2010/12/31 21:31
    thread link
thread linkthread link Re:Enterprise Manager
luke_vickery 2011/01/01 20:36
    thread link
thread linkthread linkthread link Re:Enterprise Manager
handsonerp 2011/01/07 04:26
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop