Home » RDBMS Server » Server Administration » How can I start oracle package in HP_UX (pls urgent)
How can I start oracle package in HP_UX (pls urgent) [message #204409] Mon, 20 November 2006 09:49 Go to next message
manicm
Messages: 11
Registered: August 2006
Location: SIngapore
Junior Member
Problem is
1.oracle 8i and HP_UX 11
2.when I try to Export 8 Gb table successfuly export.
3.Drop the particular table
4.Importing time I got err msg ie can not extent in datafile I chech it disk space not enough.
5. then terminate the imp process(CTRL+C)
6.I try to drop the table ora-00054 nowait err msg popup
7.I try to halt pkg oracle that one take long responce time
8.pkg yet show halted (never down)
7.now my problem is how can i bring up pkg oracle
8. I try cmrunpkg oracle/cmmod -e oracle but still halted this both commands take long response time

pls advicce me asap
thanks
manix
Re: How can I start oracle package in HP_UX (pls urgent) [message #204410 is a reply to message #204409] Mon, 20 November 2006 09:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not sure what you mean by 'package' here.
For the root issue,
always export with compress=n
Re: How can I start oracle package in HP_UX (pls urgent) [message #204411 is a reply to message #204409] Mon, 20 November 2006 09:54 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi manix,

I try to drop the table ora-00054 nowait err msg popup
Which table you trying to drop. i think you drop table already.


I try to drop the table ora-00054 nowait err msg popup

how was you trying to drop table through sqlplus or some using other tools.

hope this helps
Taj.

[Updated on: Mon, 20 November 2006 09:55]

Report message to a moderator

Re: How can I start oracle package in HP_UX (pls urgent) [message #204413 is a reply to message #204410] Mon, 20 November 2006 09:55 Go to previous messageGo to next message
manicm
Messages: 11
Registered: August 2006
Location: SIngapore
Junior Member
thanks for reply
yes I give cpompress=n
now my problem is how can i bring up oracle

regds
manic
Re: How can I start oracle package in HP_UX (pls urgent) [message #204415 is a reply to message #204413] Mon, 20 November 2006 09:56 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
now my problem is how can i bring up oracle

bring up Oracle ?

plz. post here.
select status from v$instance.


Taj.
Re: How can I start oracle package in HP_UX (pls urgent) [message #204416 is a reply to message #204413] Mon, 20 November 2006 09:58 Go to previous messageGo to next message
manicm
Messages: 11
Registered: August 2006
Location: SIngapore
Junior Member
DEAR Taj

s already drop hte particular table. now I got problem in importing time. so once again I try to drop the table.

regds
manic
Re: How can I start oracle package in HP_UX (pls urgent) [message #204417 is a reply to message #204416] Mon, 20 November 2006 10:01 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi manix.

if you drop table.

and you are not create table after drop. so why so drop again.

if you think ur import operation create table . yes but if import operation complete successfully. but in ur case you are terminated ur import operation so table is not created.

any way let check first then trying to drop .
select count(*) from "put_ur_table_name".

if exists then drop again.

and you get ora-00054.
ORA-00054: resource busy and acquire with NOWAIT specified

Cause: Resource interested is busy.

Action: Retry if necessary.

hope this helps
Taj.

Re: How can I start oracle package in HP_UX (pls urgent) [message #204419 is a reply to message #204417] Mon, 20 November 2006 10:14 Go to previous messageGo to next message
manicm
Messages: 11
Registered: August 2006
Location: SIngapore
Junior Member
Dear Taj

Once agin thanks for ur prompt reply
when I chech the table desc that show structure of table so that i decided to drop the table once again.
now my problem is I halt the package oracle( it take long responce time)how can I bring up this one.

Regards
manicm
Re: How can I start oracle package in HP_UX (pls urgent) [message #204420 is a reply to message #204419] Mon, 20 November 2006 10:21 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

ok now the question about which pkg. you are talking ...
sorry but i am not getting ur point.

hope this helps
Taj.
Previous Topic: A gift for all DBA's
Next Topic: cannot create $ORACLE_BASE/admin/$dbname/adump directory
Goto Forum:
  


Current Time: Thu Dec 08 16:42:30 CST 2016

Total time taken to generate the page: 0.05459 seconds