Hi,
I'm running Oracle 9.2.0.1 on Windows 2k. After I initially
installed it, everything seemed to work fine. However, now ( a couple
of weeks later) whenever I try to connect to a database in Enterprise
Manager, nothing happens. I launch standalone - no Oracle Manager
Server, and when I click OK in the Database Connect Information box,
absolutely nothing happens. Or, if I save the credentials and try to
expand a database icon - same thing, no error messages or anything at
all. tnsnames should be OK, I can connect fine using SQLPlus. I tried
uninstalling and reinstalling Enterprise Manager but that didn't help.
Has anyone else encountered this or have any ideas? I would love to
at least see an error message.
Thanks,
Scott

"scottgp" <s_parmelee@hotmail.com> wrote in message
news:1122576274.608193.58190@g14g2000cwa.googlegro ups.com...
> Hi,
> I'm running Oracle 9.2.0.1 on Windows 2k. After I initially
> installed it, everything seemed to work fine. However, now ( a couple
> of weeks later) whenever I try to connect to a database in Enterprise
> Manager, nothing happens. I launch standalone - no Oracle Manager
> Server, and when I click OK in the Database Connect Information box,
> absolutely nothing happens. Or, if I save the credentials and try to
> expand a database icon - same thing, no error messages or anything at
> all. tnsnames should be OK, I can connect fine using SQLPlus. I tried
> uninstalling and reinstalling Enterprise Manager but that didn't help.
> Has anyone else encountered this or have any ideas? I would love to
> at least see an error message.
> Thanks,
> Scott
>

Is the service running ? Any errors in the eventlog ? Trace files in the
$ORACLE_HOME/network/admin/udump folder ?

Hi,
Thanks for replying.
Yes, the services are running. I can connect using other tools such
as SQLPlus, SQLPlus Worksheet, TOAD, etc. I don't see anything
mentioned in any trc files or the alert file. It seems to be all
client side. I managed to figure out how to run Enterprise Manager in
trace mode (oemapp.bat console trace - or something like that) and I
see some sort of Java null exception when clicking on the button to
connect:
NVFactory: _readNVPair expected )
[Thread-4][2005-7-28:15:24:43:680] Exception! null
NVFactory: _readNVPair expected )

but I have no idea what that means. Later on a stack trace includes:
at oracle.net.nl.NLParamParser.<init>(NLParamParser.j ava)
at oracle.sysman.vdb.VdbUtil.findInTNSFile(VdbUtil.ja va:756)
at oracle.sysman.vdb.VdbUtil.findInTNSNAMES(VdbUtil.j ava:723)
So I have a feeling it might have something to do with parsing out the
TNS file, although the TNS file seems to work fine with the other
utilities.
Thanks,
Scott

"scottgp" <s_parmelee@hotmail.com> wrote in message
news:1122668897.154557.125610@g44g2000cwa.googlegr oups.com...
> Hi,
> Thanks for replying.
> Yes, the services are running. I can connect using other tools such
> as SQLPlus, SQLPlus Worksheet, TOAD, etc. I don't see anything
> mentioned in any trc files or the alert file. It seems to be all
> client side. I managed to figure out how to run Enterprise Manager in
> trace mode (oemapp.bat console trace - or something like that) and I
> see some sort of Java null exception when clicking on the button to
> connect:
> NVFactory: _readNVPair expected )
> [Thread-4][2005-7-28:15:24:43:680] Exception! null
> NVFactory: _readNVPair expected )
>
> but I have no idea what that means. Later on a stack trace includes:
> at oracle.net.nl.NLParamParser.<init>(NLParamParser.j ava)
> at oracle.sysman.vdb.VdbUtil.findInTNSFile(VdbUtil.ja va:756)
> at oracle.sysman.vdb.VdbUtil.findInTNSNAMES(VdbUtil.j ava:723)
> So I have a feeling it might have something to do with parsing out the
> TNS file, although the TNS file seems to work fine with the other
> utilities.
> Thanks,
> Scott
>

It's only a client problem ? Which client are you using ? 9i ? Maybe you
could try installing the latest patch set (9.2.0.6.0), this fixes a number
of EM bugs.


Matthias

Yes, it only seems to be EM. It's version 9.2.0.1. I'll check on
patches, but what is driving me crazy is the fact that it worked fine
for a week or two. I may just uninstall everything, and download and
install 9.2.0.2. It's only a local install for development and
learning.
Thanks,
Scott

"scottgp" <s_parmelee@hotmail.com> wrote in message
news:1122672081.918802.110440@z14g2000cwz.googlegr oups.com...
> Yes, it only seems to be EM. It's version 9.2.0.1. I'll check on
> patches, but what is driving me crazy is the fact that it worked fine
> for a week or two. I may just uninstall everything, and download and
> install 9.2.0.2. It's only a local install for development and
> learning.
> Thanks,
> Scott
>

Is there enough free disk space on the server ? No full tablespaces ?

Hi Matthias,
I got it working. It was nothing like that. Somehow the "database
tree" in EM got corrupted. I tried recreating all of the tns entries
but that didn't help. I then removed all of the databases listed in
the "tree", re-added them, and it seems to be working. Thanks for
replying, though.
Scott

Me again. I'd hate to leave an erroneous solution out here. I came
across the correct solution in Metalink. The real fix is that no entry
in tnsnames.ora should have the last right parenthesis at the begining
of the line. Out of my 40+ entries in tnsnames.ora, one had the final
right parenthesis at the beginning of the line - I spaced it over by
one and everything works.
Scott

"scottgp" <s_parmelee@hotmail.com> wrote in message
news:1123082988.158239.5930@o13g2000cwo.googlegrou ps.com...
> Me again. I'd hate to leave an erroneous solution out here. I came
> across the correct solution in Metalink. The real fix is that no entry
> in tnsnames.ora should have the last right parenthesis at the begining
> of the line. Out of my 40+ entries in tnsnames.ora, one had the final
> right parenthesis at the beginning of the line - I spaced it over by
> one and everything works.
> Scott
>

Or : always modify the tnsnames.ora file with the Net Manager ...