Alan,

Wow, I did not expect to receive a response so quickly. And you are
absolutely correct. The database scripts were not run at all.
Thanks a bunch!!!

Alan Cuartero wrote:
> Zara,
>
> Yes, the default password for the glogdba user is glogdba. Either this was
> changed by whoever setup your 5.5 database instance or the user doesn't
> exist. Normally the database users would be created by the
> create_glog_users.sql script located in the /opt/otm/glog/oracle/script8
> directory. If you can login to your database as the system user you can
> check to make sure the users exist with.
>
> SELECT USERNAME
> FROM ALL_USERS
> WHERE USERNAME IN
> ('GLOGOWNER','GLOGDBA','GLOGDEV','GLOGLOAD','ARCHI VE','REPORTOWNER');
>
> Of course if these users don't exist then you need to run through the
> database setup in the admin guide to create the users, tablespaces and
> import the database structure and default data.
>
> Hope this helps.
>
> Regards,
> Alan Cuartero
> Cuartero Consulting, LLC
>
> On 12/11/06 6:51 PM, "idqpbi" <idqpbi (AT) gmail (DOT) com> wrote:
>
>
>> Hi OTM/Glog experts,
>>
>> As a green horn, I would really appreciate if anybody could help me
>> point to some further info. or answer my questions below:
>>
>> 1) Other than the OTM official documents, are there any other useful
>> information on OTM, any archive of past G-Log forum?
>>
>> 2) I just installed OTM 5.5.1 on RHEL AS 4 using WebSphere as the
>> application server, everything seems to be installed and configured.
>> However when I tried to start OTM application server, I got the
>> following in the terminal window:
>> ================================================== ============
>> [root@otm init.d] # ./otmapp55 start
>> Waiting for DB Server to finish startup
>> nohup: appending output to 'nohup.out'
>> WebSphere startup initiated
>> [root@otm init.d] #
>> ================================================== ============
>>
>> And I monitored the "*/opt/otm/logs/websphere/console_out.log*" file, at
>> the end, I got this:
>>
>> ------------------------------------------------------------------------------
>> -------------------------------
>>
>> NMSV0018I: Name server available on bootstrap port 2809.
>> SystemOut O *Fatal Error: Realm Initialization failed !!*
>> ------------------------------------------------------------------------------
>> --------------------------------
>>
>>
>> And in the "*console_err.log*" file in the same directory, here I got
>> more details:
>>
>> ------------------------------------------------------------------------------
>> ---------------------------------
>>
>> SystemErr R java.sql.SQLException: ORA-01017: invalid
>> username/password; logon denied
>>
>> java.sql.SQLException: *ORA-01017: invalid username/password; logon
>> denied*
>>
>> at
>> oracle.jdbc.dbaccess.DBError.throwSqlException (DBError.java:134)
>> at oracle.jdbc.ttc7.TTIoer.processError
>> (TTIoer.java:289)
>> at oracle.jdbc.ttc7.o3log.receive2nd
>> (O3log.java:510)
>> at oracle.jdbc.ttc7.TTC7Protocol.logon
>> (TTC7Protocol.java:279)
>> at
>> oracle.jdbc.driver.OracleConnection.<init> (OracleConnection.java:36
>> ...........
>> ...........
>> ------------------------------------------------------------------------------
>> -----------------------------------
>>
>>
>> So it seems that it could not connect to the Oracle database on the
>> remote server because of a bad username/password pair, however my
>> question is, is the default username/pwd for this JDBC datasource
>> "glogdba/glogdba" as specified in the "resource.properties" file and the
>> "glog.properties" file?
>>
>> I tried to connect to the db server using glogdba/glogdba and it failed
>> with same "invalid username/pwd" error.
>>
>> Please help me by give me some hints how to further troubleshoot this. I
>> am new to the Oracle stack as I mentioned. Hope I could learn as quickly
>> as possible.
>>
>> Thank you very much for reading this far. Wish you all a happy and warm
>> holiday!
>>
>> Zara
>>
>> You are receiving this mail as a subscriber of the Oracle Transportation
>> Management SIG List Server. This list is provided by Solution Beacon,
>> LLC for the Oracle Transportation Management SIG to facilitate distribution
>> of issues and topics related to Oracle Transportation Management. If you
>> do not want to receive future mail from the list, send email to
>> majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
>> quotes) in the body of the email.
>> If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
>> Thank you!
>>
>
>
>
> You are receiving this mail as a subscriber of the Oracle Transportation
> Management SIG List Server. This list is provided by Solution Beacon,
> LLC for the Oracle Transportation Management SIG to facilitate distribution
> of issues and topics related to Oracle Transportation Management. If you
> do not want to receive future mail from the list, send email to
> majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
> quotes) in the body of the email.
> If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
> Thank you!
>
>


You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!