Sysadmin password - forgotten
Date: Mon, 23 Aug 1999 15:05:16 +0400
From: Srinivas Sreepada satncr@emirates.net.ae
To: OraApps-L@cpa.qc.ca
Subject: SYSADMIN PASSWORD
Hi,
In one of our test environments the SYSADMIN responsibility is held only by
the user name SYSADMIN, the person holding the pasword for this has
forgotten the password and since it is a test environment the password is
not covered by the normal security procedures and no one else knows that
password.We have tried hacking the password but to no luck.
Can anyone please give me some clue as to how to access the sysadmin
responsibilty ? do i have to access the table which stores the password and
then change it ?
Thanks
Srinivas
Date: Mon, 23 Aug 1999 07:14:10 EDT
From: Kshri@aol.com
To: oraapps-l@cpa.qc.ca
Subject: Re: SYSADMIN PASSWORD
Try this - Pick a username and either add to/update (an existing resp) the
user responsibilities table for this user from SQL plus to include 'Sys
Admin' responsiblity. You should be able to access sys admin through this
user.
Date: Mon, 23 Aug 1999 11:26:39 GMT
From: manoj_bhatnagar/Polaris@POLARIS.CO.IN
To: oraapps-l@cpa.qc.ca
Subject: Re: SYSADMIN PASSWORD
Hi Srinivas
I am telling you the answer by assuming two things
1. You are on Release 11.0 or higher.
2. You are using Vision Demonstration Database.
If you satisfy these two criteria then
1. Supply the Username as Operations.
2. Supply the password as Welcome.
Enjoy!!!
Manoj Bhatnagar
Associate Consultant - Oracle Applications
Polaris Software Lab Ltd.
Noida, India.
Date: Mon, 23 Aug 1999 17:07:48 +0530
From: "GopalaKrishnan K" gopalak@wiproge.med.ge.com
To: oraapps-l@cpa.qc.ca
Subject: Re: SYSADMIN PASSWORD
Hi Srinivas !
The Usernames and passwords are stored in FND_USER and the responsibilities
are stored in
FND_RESPONSIBLITY. I am not sure about the internal relation between them
Try hacking these tables are do a try.
Let me know the outcome.
Gopal
Date: Mon, 23 Aug 1999 17:14:22 +0530
From: "GopalaKrishnan K" gopalak@wiproge.med.ge.com
To: oraapps-l@cpa.qc.ca
Subject: Re: SYSADMIN PASSWORD
I believe you can reset the sysadmin password thru some other user who has
sysadmin resp.
Oracle uses the standard encryption for encrypting the password.
so u can do the following things.
BEWARE: THIS IS ONLY A SUGGESTION. IT MAY BE WRONG OR DANGEROUS.
TRY THIS IF ALL YOUR ATTEMPT FAIL.
Dear LIST !
Please EXCUSE ME if it looks stupid Advice and please correct me if i am
wrong:
Set the SYSADMIN password as SYSADMIN in your TEST instance or Even your
prod insance.
get the encrypted password from TEST instance;
SQL select encrypted_foundation_password,encrypted_user_password from
fnd_user
2 where user_name='SYSADMIN';
ENCRYPTED_FOUNDATION_PASSWORD
-------------------------------------------------------------------
---------------------
ENCRYPTED_USER_PASSWORD
-------------------------------------------------------------------
---------------------
3F73DF5A01A6A87275F13439A35DDA0A0AAFF553F125C9FDEF84FD0FC6FE0F18
D6E0B6830686B0E7A2D24B023B13A1F086B45FDD8B7D1D4EA6CB702769B8364E
copy the encrypted password and update FND_USER by this vales;
Now your SYSADMIN password is SYSADMIN
Gopal
Date: Mon, 23 Aug 1999 09:21:31 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: SYSADMIN PASSWORD
Gopal,
What you are saying is correct.
If they are not worried about the users in that application,
they can even export and import FND_USER table from another
database.
This is what we did once upon a time when one guy messed up with the
SYSADMIN password on PRODUCTION.
We imported and exported from a Staging instance which was
refreshed one day before this happened.
AND THIS SOLUTION IS GIVEN BY ORACLE SUPPORT only.
Every user's passowrd is encrypted along with his user_id.
Hence if you change the order in creating users , this will not
be possible.
-chakrapani
Date: Mon, 23 Aug 1999 09:16:21 -0400
From: "Jagannathan, Ravi" RJagannathan@prcnet.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: SYSADMIN PASSWORD
Why don't you refresh the test database?
After refreshing you can use the production password....
Thanks
Ravi Jagannathan (MIS)
Tel : (305) 816 4831
Date: Mon, 23 Aug 1999 07:49:55 -0700
From: "Haseeb, Mohamed" Mohamed.Haseeb@Jacobs.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: SYSADMIN PASSWORD
Don't ever do that - - encryption logic is not the same in all the
instances. So don't play around with the encryption.
The easiest solution is to choose an existing user for which you have the
password and add a record into the FND_RESPONSIBILITY table for that user
for the sysadmin responsibility. If you don't know what to fill up in the
columns - just duplicate the row from the sysadmin user, by changing only
the user id.
If you still have a doubt on this - write to me. I can send you the SQL.
Regards... Haseeb
Date: Mon, 23 Aug 1999 07:52:59 -0700
From: "Haseeb, Mohamed" Mohamed.Haseeb@Jacobs.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: SYSADMIN PASSWORD
Chakrapani,
What you say is not correct.
1. The encyrption is not based on User ID
2. In your case it worked because it was the backup of the same instance
which was just refreshed one day before - so it is as good as restoring a
backup.
Regards.. Haseeb
Date: Mon, 23 Aug 1999 11:03:50 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: SYSADMIN PASSWORD
Haseeb,
Let me explain clearly how it works and what my assumption is.
Oracle stores passwords based on the userid in combination with user name.
Hence if user id differs it will not work. for ex:
In DEV database I created a APPS user chakra and I found user id is 1924.
In TEST database I created same APPS user charka and I found user id is
1935.
Here user id differs and I tried using the normal procedure you use
for SYSADMIN but it dod not work.
Same is the case with SQL Plus users. I tried by changing the order
in creation of users and tried "identified by values" clause.
It did not work.
Hence I came to this conclusion.
As per your words it should work.
Why the PROCEDURE for sYSADMIN and other SEEDED APPS users works is,
they all have same user_ids in any installation.
You can check in any other database.
I will appreciate your feedback on this.
Thanks,
-chakrapani
Date: Mon, 23 Aug 1999 10:18:42 -0500
From: "Alicia" ahoekstr@csac.com
To: oraapps-l@cpa.qc.ca
Subject: RE: SYSADMIN PASSWORD
The table you are actually suggesting inserting a record into is
FND_USER_RESPONSIBILITY. In any case, export or make a backup of
your tables before you attempt to alter the data.
Oracle Support does have scripts for resetting database and Applications
passwords if your various efforts fail.
Alicia
Date: Mon, 23 Aug 1999 17:15:32 +0200
From: LAVERACK Stephen stephen.laverack@eurocontrol.be
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: SYSADMIN PASSWORD
Srinivas,
A quick and dirty solution, but perhaps better than trying to change
passwords in sql:
Assuming you have the Apps password:
The table FND_USER_RESPONSIBILITY is the linking table between FND_USER and
FND_RESPONSIBILITY.
Insert a row into FND_USER_RESPONSIBILITY for the apps user you want to add
Sysadmin to.
User_id is the user_id fom FND_USER.
Application_id and responsibility_id are the corresponding columns from
FND_RESPONSIBILITY for the System Administrator responsibility (probably 1,
101).
Steve
Date: Mon, 23 Aug 1999 11:59:50 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: SYSADMIN PASSWORD
I think support can help you. Recently we have successfully hacked and
got out of similar situation.
Madhu
Date: Mon, 23 Aug 1999 09:52:34 -0700
From: McRaney Ronald-MCG32315 rmcraney@itexchsrv2.phx.mcd.mot.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: SYSADMIN PASSWORD
On MetaLink:
Oracle Corporate Support
Problem Repository
1. Prob# 1072328.6 HOW TO RESET ONLY THE SYSADMIN PASSWORD
2. Soln# 2117948.6 FOLLOW THESE STEPS TO RESET SYSADMIN PASSWORD
1. Prob# 1072328.6 HOW TO RESET ONLY THE SYSADMIN PASSWORD
Problem ID : 1072328.6
Affected Platforms : Generic: not platform specific
Affected Products : Oracle Application Object Library
Affected Components : APPCORE V11.00.02.XX
Affected Oracle Vsn : V08.00.04.XX
Summary:
HOW TO RESET ONLY THE SYSADMIN PASSWORD
Cheers.
User Exits - FND
Date: Mon, 23 Aug 1999 15:04:29 -0500
From: "Kanakam, Venkat (c)" vkanakam@Carlson.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: FND USER EXITs details
Hi All,
Where can I find detailed description about FND User Exits like
FORMAT_CURRENCY, FLEXIDVAL etc., used in Reports for Oracle Financials ?
TIA,
Venkat Kanakam
Consultant
CIBER, Inc.
Customize custom.pll for zoom functionality and Special Menu
Date: Tue, 24 Aug 1999 06:49:27 -0700 (PDT)
From: Binoy Raman binoypr@yahoo.com
Subject: AOL : CUSTOM.pll
Hi,
I trying to add a ZOOM to a form using the CUSTOM.pll library. I made
the modifications exactly as an example in the AOL Developers Guide,
when I open the form (APXVDMVD), I get an error :
FROM-40735:WHEN-CREATE-RECORD trigger raised unhandled exception
PROGRAM_ERROR.
Even if I remove the changes that I made and put back the CUSTOM.pll
(and compile on server), this error repeats. The only way to get around
is to copy the original CUSTOM.pll (or plx) to the directory.
I am also trying to add something under the SPECIAL menu, even this
does not work. I AM able to do some additional validations using the
CUSTOM.pll (in event WHEN-VALIDATE-RECORD), the only problem is that
once I change the CUSTOM.pll and get an error, I have to start all
over again.
Does any one have a solution to this ? Are we missing a patch ? We are
on Rel 11.0.2.
Binoy.
Date: Tue, 24 Aug 1999 15:44:35 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
Subject: Re: AOL : CUSTOM.pll
I had same kind of problem before. Make sure you are entering exactly same
function name in fnd_function.execute as it is defined. My problem solved
after entering right name.
Good luck.
Date: 24 Aug 99 10:44:30 MDT
From: vv vv venvivek@usa.net
Subject: Re: [AOL : CUSTOM.pll ]
Hi,
Please check for the parameters on the fnd_execute fn, And inside the
custom.pll dont try to use any embadded sql statments in ur validation if ur
goin to use that is goin to give u some problem.
regards.
Vivek.
Concurrent Manager - how to stop system sending notice by email of shutdown
Date: Tue, 24 Aug 1999 10:08:24 -0700
From: Ramana Kondaveeti Ramana.Kondaveeti@hds.com
Subject: CM issue
Hello Folks,
When ever we shut down our CM in any instance we are getting an email from
applmgr saying
""The DEV internal concurrent manager has terminated successfully -
exiting.
Shutting down Internal Concurrent Manager : 23-AUG-1999 09:10:45""
How can we block this email ...??
TIA.
Ramana
Date: Tue, 24 Aug 99 10:27:46 -0800
From: guru_pal@guthy-renker.com
Subject: Re: CM issue
Check the "cm start" script
Date: Tue, 24 Aug 1999 13:46:05 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: CM issue
Are you getting mail to your e-mail address
(or)
getting message " you have mail in /var/mail" whenever you are in APPLMGR
user
-chakrapani
Date: Wed, 22 Sep 99 11:10:14 -0800
From: sagarwal@guthy-renker.com
Subject: Re[2]: CM issue
yes
Date: Tue, 24 Aug 1999 23:14:18 -0400
From: fushan@gamma.aei.ca
Subject: Re: CM issue
How did you shut down your concurrent manager??? Are
you issue unix command CONSUB .... ?? or you have a shell
scritp to shutdown the CM? If you are using CONSUB, then I
cannot give you too much help. I wonder Consub will able to send
you a email about this. If a shell script is run to shutdown the CM,
check it first.
Fu-shan Louisa Leong
Oracle DBA, Oracle Financial Application
Andersen Consulting
OAS and J Initiator upgrades
From: Kathy Largay [mailto:klargay@bhe.com]
Sent: Tuesday, August 24, 1999 7:09 AM
Subject: OAS and J Initiator upgrades
Right now, we are operating with versions of OAS (3.0.1.0.0) and J Initiator
(1.1.5.21.1) that will be desupported (and not Y2K compliant?). Can anyone
tell me where to go to get information and upgrades? OAS is supported at
3.0.1.1, but all I can find is ver. 4, and I can't find anything on J
Initiator. Thanks!
From: Logan, Ernie [mailto:Ernie_Logan@bmc.com]
Sent: Tuesday, August 24, 1999 8:32 AM
Subject: RE: OAS and J Initiator upgrades
WWS will ship 3.0.2 for Oracle Apps use. As far as JInitiator is concerned,
find the latest at:
http://www.oracle.com/products/tools/dev_server/dn.html
1.1.5.21.1 is the latest available version currently. Where did you get the
information that it would be de-supported due to Y2K compliance issues?
From: Kathy Largay [mailto:klargay@bhe.com]
Sent: Tuesday, August 24, 1999 10:21 AM
Subject: RE: OAS and J Initiator upgrades
The Oracle Y2K White Papers say that, for Oracle J Initiator 1.1.7.11 and
above are compliant and supported. From that I assumed that the version we
have is not.
Date: Tue, 24 Aug 1999 14:30:44 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: OAS and J Initiator upgrades
Check with WWS. I believe the only certified version for Oracle Apps is the
current 1.1.5.21.1.
Date: Wed, 25 Aug 1999 08:39:40 +0930
From: Hilary Soloff Hilary.Soloff@santos.com.au
Subject: RE: OAS and J Initiator upgrades
Kathy,
We've just been through the process of confirming which version of
Jinitiator is certified Y2K compliant for 10.7NCA, as we saw the same info
on 1.1.7.11 in the White Paper.
After talking to Support we have confirmed that version 1.1.5.21.1 is
certified.
Regards,
Hilary
Date: Wed, 25 Aug 1999 06:52:56 -0500
From: "Alicia" ahoekstr@csac.com
Subject: RE: OAS and J Initiator upgrades
Did your Oracle Support Analyst provide you with where it is documented on
MetaLink that 1.1.5.21.1 is certified?
Thanks,
Alicia
Concurrent Requests - SQL spooling errors after RDBMS upgrade
Date: Tue, 24 Aug 1999 19:27:46 -0700 (PDT)
From: Scott Van Bebber svanbebb@yahoo.com
Subject: Gen: SQL*Plus Scripts Fail After Upgrade
We are on ver 10.7 Apps. Recently we upgraded our server to 7.3.4.4
from 7.3.3, and have been getting some odd behavior. Some of our
concurrent jobs with an execution method of SQL*Plus and which have
been in production for months, no longer work. These jobs create
datasets which are transmitted to a legacy system. The problem seems
to be related to spooling output to a file using a variable for the
file name. Has anyone else experienced this kind of problem?
Scott
Application Top - customization
Date: Tue, 24 Aug 1999 22:30:49 -0700 (PDT)
From: FMT firas70@yahoo.com
Subject: Defining Customization APPLICATION TOP
Hi All,
I am looking for the steps required to define a
customization application top to be used for the tailored
reports.
We are using 10.7SC on Windows NT 4.0
Any help is appreciated.
Firas Al Tamimi
ADWEA
UAE
firas70@yahoo.com
FND_FILE - use of function
Date: Tue, 24 Aug 1999 22:35:29 -0700 (PDT)
From: sai narayan sai_narayan@yahoo.com
Subject: Concurrent Programs : FND_FILE
Hi folks,
I have a query regarding the concurrent programs. In Rel. 11, Oracle
has come out with fnd_file package for file IO on request and output
log files which can be used within PL/SQL stored procedure concurrent
programs.
My question is : Is it possible for 10.7 SC users like myself to use
these fnd_file functions by any way like say some updgrade ?
regards
Sai
Date: Wed, 25 Aug 1999 13:56:09 +0200
From: LAVERACK Stephen stephen.laverack@eurocontrol.be
Subject: Concurrent Programs : FND_FILE
Sai,
FND_FILE is only available on R11. I don't think it would be possible to
utilise the package within 10.7, since although the package is performing a
simple task (writing to a temporary file using UTL_FILE), R11's concurrent
manager copies the file created from $APPLTMP to $APPLCSF/$APPLOUT or
$APPLCSF/$APPLLOG
However, you could leverage the basic concept in 10.7, to produce log and
output files from plsql conc programs:
Write a package which uses UTL_FILE to write to the files held in the
columns LOGFILE_NAME and OUTFILE_NAME in FND_CONCURRENT_REQUESTS for the
request FND_GLOBAL.CONC_REQUEST_ID
As in R11, you will need the utl_file_dir parameter setting up in the
init.ora file, though it should point to your out and log directories,
rather than APPLTMP.
NB: The UNIX owner of files created by UTL_FILE is oracle, not applsys.
Therefore, you will need to set write permissions for the directory
accordingly, and ensure the umask allows reading from others.
Steve
Concurrent Requests - Output Files save in specific directories
Date: Wed, 25 Aug 1999 11:34:20 +0100
From: "Sabarad, Sateesh (GEAE, Caledonian)" Sateesh.Sabarad@ae.ge.com
Subject: concurrent Request Output Files.
Hi Friends,
One of the requirements at this implementation site is to enable the user to
copy the Output file of one Concurrent Request onto a disk. This needs the
Output files to be FTPed across. With huge number of output files present in
the OUT directory, it is painful to search for one file and then transfer
it.
Is there a way to direct a particular set of Output files( User / Request
etc.,) to a specified directory on the system?
I appreciate any help in this. I use Apps 11.0.200.
Regards,
Sateesh Sabarad
g GE Caledonian
Concurrent Request - error on submitting PL/SQL stored procedure as a
Date: Wed, 25 Aug 1999 14:03:32 -0400
From: Rangaraju_Krishna@tmac.com
Subject: PL/SQL Stored Procedure Concurrent Program
Hi Folks:
I am setting up a Stored Procedure as a Concurrent Request. I am getting the
following error while I am submitting the request:
ORA-06550 : line 1, column 7:
PLS - 00201: identifier procedure name mu
Does any one know what might be the problem?
any help is appreciated.
thx
Date: Wed, 25 Aug 1999 13:02:56 -0500
From: "Ramana Jessu (ns)" rjessu@cap.org
Subject: RE: PL/SQL Stored Procedure Concurrent Program
Do you have the following parameters in your procedure?
1. errbuf varchar2,retcode varchar2
Ramana Jessu
Date: Wed, 25 Aug 1999 11:16:27 -0700
From: Radha.Krishna@Notes.airtouch.com
Subject: RE: PL/SQL Stored Procedure Concurrent Program
Check for the two 'out' parameters viz
errbuf out varchar2( )
retcode out varchar2( )
Radhakrishna
Date: Wed, 25 Aug 1999 11:14:54 -0700
From: "Prasad Sanikommu" prasad.sanikommu@sentrol.com
Subject: RE: PL/SQL Stored Procedure Concurrent Program
Hi,
I think there is an error in the pl/sql stored procedure.
try executing that procedure from sql plus and you might be able to see the
same error there.
Prasad
Date: Wed, 25 Aug 1999 14:39:19 -0400
From: "Klosterman, Lisa H." KlosLH@jea.com
To: "'Rangaraju_Krishna@tmac.com'" Rangaraju_Krishna@tmac.com,
Subject: PL/SQL Stored Procedure Concurrent Program
If the stored procedure was created under a schema other than APPS, you must
grant privilege to APPS to execute the procedure, and create a synonym to
the procedure.
-- Liza Klosterman
PORT Consulting, Inc
Date: Wed, 25 Aug 1999 14:36:47 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: PL/SQL Stored Procedure Concurrent Program
Hi,
As you say, this might be problem with SYNONYM only.
PLS 201 error is referring to Synonym.
Please check this.....
-chakrapani
Concurrent Program - Rep 1212 error
Date: Thu, 26 Aug 1999 11:47:26 -0400
From: "Potluri, Venu" VPotluri@exchange.ml.com
To: "OraAppsDBA List (E-mail)" OraApps-DBA@cpa.qc.ca,
Subject: Concurrent Program Error
We were running a concurrent request and it completed with error. Here is
the log:
REP-1212: Object 'M_2_GRPFR' is not fuly enclosed by its enclosing body
APP-00969 Program exited with status 1
APP-01125 Concurrent manager got error running Oracle Reports for request ID
Has anyone seen such errors before? What might be the causes? What can we do
about this? Thanks.
V Potluri
Date: Thu, 26 Aug 1999 09:00:11 -0700
From: "Prasad Sanikommu" prasad.sanikommu@sentrol.com
Subject: RE: Concurrent Program Error
Hi,
This is a reports error.
It means some fields in the report are not enclosed by the body.
You can increase the page width or decrease the size of the fields.
Hope this solves your problems.
Prasad
Date: Thu, 26 Aug 1999 13:03:39 EDT
From: "Mark Thomas" appsora@hotmail.com
Subject: Re: Concurrent Program Error
Hi Venu,
These errors occur if the executable is written in Developer 2000. It
means that the particular group frame or repeating frame is not fully
enclosed by it's parent frame.
The way to fix it is FTP the report into desktop and fix the report
using developer 2000.
Contact me if u have any further questions.
Regards,
Mark
NT User id for Db trigger - how to get
Date: Wed, 25 Aug 1999 14:24:04 -0400
From: "Goyal, Sanjay, CFCTR" goyal@att.com
Subject: NT user id in oracle
Please Help
How can I get Window NT userid in a stored procedure. I need to write
a database trigger for audit purpose and in that I need to get userid
from Windows NT.
Thanks
Sanjay
Date: Wed, 25 Aug 1999 14:13:55 -0500
From: bmoreland@living.com
Subject: RE: NT user id in oracle
You can select os_user from v$session for the current session.
Thanks,
Brad Moreland
Date: Thu, 26 Aug 1999 08:47:40 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: NT user id in oracle
Hi,
If you want to see the current session's OSUSER, try this:
select osuser from v$session where audsid=userenv('SESSIONID');
Hope this helps.
-chakrapani
NT user id for Print queues
Date: Thu, 26 Aug 1999 14:06:50 -0500
From: "Anil Kumar (ns)" akumar@cap.org
Subject: RE: NT user id in oracle
I have a related problem.
I want to see OSuser name or id in the print queues. Can we do this?
I mean, when we submit print jobs all the jobs will be in the queue waiting
for the other running jobs to be printed. To identify a job in this print
queue, we are planning to use apps userid or OS userid. Right now, all jobs
are showing applmgr as the user who submitted the job to the printer.
Anil
akumar@cap.org