DBCA question

DBCA question

 

  

Hi,

I'm trying to run DBCA (database configuration assistant) using XMing
and receiving the following error:

Warning: Cannot convert string
"-*-lucida-medium-r-*-*-*-*-*-*-*-*-iso8859-1" to
type FontStruct
Exception in thread "main" java.lang.InternalError:
java/langNullPointerExceptio n
at sun.awt.motif.MComponentPeer.pSetFont(Native Method)
at sun.awt.motif.MComponentPeer.setFont(MComponentPeer.java:308)
at sun.awt.motif.MWindowPeer.init(MWindowPeer.java:144)
at sun.awt.motif.MFramePeer.<init>(MFramePeer.java:91)
at sun.awt.motif.MToolkit.createFrame(MToolkit.java:301)
at java.awt.Frame.addNotify(Frame.java:502)
at java.awt.Window.pack(Window.java:470)
at
oracle.sysman.assistants.util.SplashScreenWindow.init(SplashScreen.ja
va:206)
at
oracle.sysman.assistants.util.SplashScreenWindow.<init>(SplashScreen.
java:191)
at
oracle.sysman.assistants.util.SplashScreen.<init>(SplashScreen.java:1
10)
at
oracle.sysman.assistants.dbca.ui.UIHost.initialize(UIHost.java:237)
at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:138)
at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:202)

Has anyone come across the same issue? Java version is 1.5.0.06

-----Original Message-----
From: Terry Moutray
[mailto:oracledba-ezmlmshield-x35442201.[Email address protected]
Sent: Friday, February 29, 2008 9:49 AM
To: LazyDBA Discussion
Subject: RE: SwingBench...

Hi:


Another suggestion that I received was that I should recompile the
package
body, not just the package.


I did so in OEM and that is where the error resides -> in a procedure:


procedure sleep(min_sleep integer, max_sleep integer) is

sleeptime number := 0;

begin

if (((max_sleep - min_sleep) > 0) AND (min_sleep < max_sleep))
then

sleeptime := dbms_random.value(from_mills_to_secs(min_sleep),

from_mills_to_secs(max_sleep));

dbms_lock.sleep(sleeptime);

end if;

info_array(SLEEP_TIME) := (sleeptime * 1000) +
info_array(SLEEP_TIME);

end sleep;


The errors flagged are:


Line # = 67 Column # = 9 Error Text = PL/SQL: Statement ignored

Line # = 67 Column # = 9 Error Text = PLS-00201: identifier 'DBMS_LOCK'
must
be declared


Which equates to the "dbms_lock.sleep(sleeptime);" statement.


Any suggestions? Is this "dbms_lock" something that should be created
by
one of the auxillary sql scripts in rdbms/admin? If so, which one?


Thanks


Terry



-------Original Message-------



From: Terry Moutray

Date: 2/28/2008 7:14:59 PM

To: LazyDBA Discussion

Subject: RE: SwingBench...



Thanks for the suggestion - I tried recompiling and then showing the

Error(s), no luck...



SQL> alter package soe.orderentry compile;



Warning: Package altered with compilation errors.



SQL> show errors

No errors.



I can't use TOAD and it is not a RAC database (standalone).



I pulled up the package in OEM - it shows as status of valid but when I

Execute



Select owner, object_name from dba_objects where status = 'INVALID'



It comes back with this package listed.



I tried compiling it in OEM also and it just states that it compiled

Successfully - no errors listed here either.



-------Original Message-------



From: Terance W. Ebert

Date: 02/28/08 18:32:43

To: LazyDBA Discussion

Subject: RE: SwingBench...



When you compile it manually and it says compiled with errors, you enter


Show errors" and hopefully you can see the errors. Otherwise use

Sqldeveloper or toad and it will show you the errors. You can also see
the

Errors using OEM, DBCONTROL, or GRID CONTROL



-----Original Message-----

From: Terry Moutray [mailto:oracledba-ezmlmshield-x44841424.[Email
address

Protected]

Sent: Thursday, February 28, 2008 3:41 PM

To: LazyDBA Discussion

Subject: SwingBench...



Has anyone tried using a load tool called SwingBench available @
http://www

Dominicgiles.com/swingbench.HTML?



I tried using it - it requires that I create a data & index tablespace;
a

User; and the schema (tables, index, constraints, packages, functions,
etc)

For a order inventory system.



Everything appeared to be successfully installed but it doesn't work. I
did

A little investigation and it appears that the main package called

ORDERENTRY is invalid. I tried compiling it manually but it comes back
with

Compiled with errors" and is still invalid.



Unfortunately, it doesn't tell me what the errors are. And, even if it
did,

I don't know PL/SQL so I couldn't debug and resolve this problem but if
it

Told me that the package referenced something that it could not find - I


Could at least go out and check to see if that object / package /
function

(whatever) existed and try to get it created using the source SQL.



It is a very large package so I didn't necessarily want to include it in


This e-mail. I was just wondering if anyone else ran into this same
problem

And figured out how to resolve it.



I did try contacting the developer a few days ago but he has not replied


Back yet.



Regards



Terry Moutray


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



This message including any attachments contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. Mythics, Inc., Suite 201, 1439 North Great Neck Road, Virginia Beach, VA 23454, www.mythics.com




Oracle LazyDBA home page