I'd like to reassert the question asked by Wenlong Wang last week
concerning problems we are having connecting Netview to our Oracle
database. I will excerpt pertinent segments of his mail.
> We created the TME 10 NetView Database in the database server and used
> the following command to create the RIM object:
>
> wcrtrim -v Oracle -h jupiter.caps.maine.edu -d UMSB -u jupiter -H
> /usr/OV/oracle/product -s saturn_tcp_UMSB netview
>
> note: /usr/OV/oracle/product is in
> jupiter.caps.maine.edu side
Ken Garst suggests that the -u jupiter should be -u netview as evidenced
by the wgetrim output seen below:
>
> This command was successful. By using 'wgetrim netview', we got:
>
> RIM Host: jupiter.caps.maine.edu
> RDBMS User: jupiter
> RDBMS Vendor: Oracle
> Database ID: UMSB
> Database Home: /usr/OV/oracle/product
> Server ID: saturn_tcp_UMSB
> Instance Home:
However, our RDBMS user is indeed jupiter, so I'm not sure changing to
-u netview will help, will it? Of concern and confusion to us are the 2
parameters supplied for Database Home and Server ID. Is Database Home
where the rdbms resides or where the oracle tree (clients only) on the
local machine is? And what (in Oracle-speak) is desired for Server ID.
We have specified the service name used in the tnsnames.ora file to
connect Oracle clients to the rdbms.
Finally, when we attempt to connect using nvColTabl, amongst the errors
is these lines:
> Could not open database
>
> Unable to open database with DB type = RIM, login ID = , Server name =
> netview@jupiter.
I have trouble correlating the information in the error message with
that from wgetrim output above and I'm perplexed that the login ID
appears to be NULL.
I'm getting the feeling our error is easily corrected, but I can't see
what I need to do differently. Any help would be very much appreciated.
-John
--
---------------------------------+--------------------------------------
John Grover | Operations Manager,
UNET, Technology Services | Senior Technical Support Specialist
University of Maine System | JGrover@Maine.edu
Computing Center | phone: (207) 581-3510
Orono, ME 04469 | fax: (207) 581-3531
|