- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Problem dropping user cascade !!!
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
тАО03-03-2003 06:38 AM
тАО03-03-2003 06:38 AM
Problem dropping user cascade !!!
did the patch install. Running
oracle 8.1.7.4 ( 64 bit )on hpux 11 64 bit OS
created DB fine, using scripts from $ORACLE_HOME/assistant/dbca that I have been using from other boxes.
logged in to DB, created user, try toload dump and it failed. Fixed the problem (additional system roll back segment was needed ) and when I was trying to drop the user to load the dump again, I get this error :
SQL> drop user someuser cascade;
drop user someuser cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
re-run catalog.sql and catproc.sql to make sure it was not missing any data dictionary views.
tried again and same problem.
B4 I get rid of this instance and create a new one, I was wondering if anybody is seen such a problem, and if they know if I need to run something else.
This instance was created on this box, and it was not copied over from some other box.
Oh, I also relinked the binaries this morning, before running the sql scripts.
Thanks,
Henrique Silva
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2003 06:46 AM
тАО03-03-2003 06:46 AM
Re: Problem dropping user cascade !!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2003 06:49 AM
тАО03-03-2003 06:49 AM
Re: Problem dropping user cascade !!!
Cheryl
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2003 06:50 AM
тАО03-03-2003 06:50 AM
Re: Problem dropping user cascade !!!
Regards,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2003 01:33 PM
тАО03-03-2003 01:33 PM
Re: Problem dropping user cascade !!!
This is not a database migration as that bring other factors into it.
You should also verify all database objects in sql.
Not a likely cause but.
To run this version of Oracle, they recomend the December 2002 patch set plus the patches recommended by OS on metalink.com in document.
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=43507.1
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
тАО03-03-2003 01:50 PM
тАО03-03-2003 01:50 PM
Re: Problem dropping user cascade !!!
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2003 08:27 PM
тАО03-03-2003 08:27 PM
Re: Problem dropping user cascade !!!
the output of the following can shed some light:
exp someuser/password file=someuser.dmp rows=no
hth
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-03-2003 11:07 PM
тАО03-03-2003 11:07 PM
Re: Problem dropping user cascade !!!
If those are due to the AQ tables do not run catnoqueue.sql.
Try stopping the queue's and then dropping them and then dropping those tables.
You can do a query on
select * from all_queues
to find any queues that are running.
Revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2003 03:40 AM
тАО03-04-2003 03:40 AM
Re: Problem dropping user cascade !!!
I tried a few suggestions but nothing. So, I bit the bullet, dropped the database and recreated.
everything is fine now. Not sure what went wrong at DB creation B4. It had failed in the middle of the DBNAMErun1.sh script, but I had gone back, fixed the problem and re-run the creation scriptfromthat point on, and no more problems were there.
Now, can you explain to me what is the purpose of these queues ? I have not heard of them B4.
Thanks,
Henrique
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2003 03:49 AM
тАО03-04-2003 03:49 AM
Re: Problem dropping user cascade !!!
Regards,
John