- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- OUTLN user exists during upgrade
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-03-2004 07:26 AM
тАО02-03-2004 07:26 AM
I'm upgrading from version 8.1.6.2 to version 8.1.7.4.0. I'm going through the oracle checklist of steps and one steps is to make sure there are no users or roles called OUTLN or MIGRATE.
Well, OUTLN exists is my database but oracle doesn't say what to do if the user is already there.
So I have a two part question?
1) what does the user do?
2) should I remove the user?
Thanks
Jeff
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-03-2004 07:44 AM
тАО02-03-2004 07:44 AM
SolutionIf you've done a lot with that user you may have to change ownership of objects to another user.
My recollection is the OUTLN user is created and used to migrate data.
You have to remove it to run the migrate. You must first see what that user owns. It might be left over from a past migration, which means you can remove the users and objects with the cascade function.
You need to be sure though and back up that database before you start.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-03-2004 07:57 AM
тАО02-03-2004 07:57 AM
Re: OUTLN user exists during upgrade
Note: If you are upgrading from an 8.1 release, then you do not need to perform this check because the OLTLN user should have already been created when you installed the previous 8.1 release. Therefore, if you are upgrading from an 8.1 release, then go to Step 7 now. DO NOT DROP the OUTLN user if you are upgrading from a previous 8.1 release.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-03-2004 08:52 AM
тАО02-03-2004 08:52 AM
Re: OUTLN user exists during upgrade
what does this User do ?
This user owns the objects that are needed to provide the use of "stored outlines".
Here is an example:
www.jlcomp.demon.co.uk/04_outlines.rtf
I always wanted to try to attach the executionplan of
SELECT Salery from USER_DATA where type='MANAGER';
to the one from
SELECT 'No Money today!' as Salery from dual;
But I never made it so far. Do not know if it would be possible at all.
Have fun
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-03-2004 04:34 PM
тАО02-03-2004 04:34 PM
Re: OUTLN user exists during upgrade
The OUTLN should not be dropped. This user owns the package OUTLN_PKG which is used to manage stored outlines and their outline categories. There are other tables (base tables), indexes, grants, and synonyms related to this package and problems can be encountered should this schema be dropped.
regards
yogeeraj