[nick.polites]

Ok with that being said then your problem is with the database then. First thing I would review is the database import log. Make sure everything imported without any errors. I'm guessing this is where the problem really is.

If that checks out, then I would go back and re-run all of the post import scripts starting at @create_vpd_package.sql. Rerun each script and be sure you get 0 errors when you recompile_invalid_objects for both reportowner and glogowner.

When you import the database, even though CU4 was installed as part of the app/web server, the database dump is from GA and must be patched to the latest CU by running dbpatch_55.

The table view does not exist errors indicate that something is wrong in the database.

Nick

[dgoli]

Mr.Nick,

Thanks for your reply.

Pls apologise for the confusion I have already created and the one I am about to create in this reply.


We have a working OTM instance(OTM1) on Unix connected to DB instance(DATA1).

Now I have installed OTM(OTM2) on Windows and trying to connect to DB instance(DATA2). The installation is successful.
We have executed all the database related scripts,verified the database structure and finally executed “insert_security_roles.sql” as GLOGOWNER for DATA2.
Everything seems fine as per Admin guide.

Finally,I am getting the Login screen
When I try to login into OTM2,we are getting different errors for different users.

When correct Login information is provided :

For DBA.ADMIN

INFO | jvm 1 | 2008/06/11 12:56:07 | Authentication Failed for user DBA.ADMIN
INFO | jvm 1 | 2008/06/11 12:56:07 |
INFO | jvm 1 | 2008/06/11 12:56:07 | at jrockit.reflect.NativeConstructorInvoker.newInstan ce([Ljava.lang.ObjectLjava.lang.Object;(Unknown Source)

For GUEST.ADMIN and SERVPROV.ADMIN

INFO | jvm 1 | 2008/06/05 20:33:52 | java.sql.SQLException: ORA-00942: table or view does not exist


When I attempt to Login with WRONG information:

For DBA.ADMIN ,GUEST.ADMIN and SERVPROV.ADMIN

INFO | jvm 1 | 2008/06/05 20:33:52 | java.sql.SQLException: ORA-00942: table or view does not exist

We thought the problem is with the DATA2.
So we changed glog.properties and WL config.xml in OTM2 to connect to DATA1.

When CORRECT Login information is provided :

For DBA.ADMIN

INFO | jvm 1 | 2008/06/11 12:56:07 | Authentication Failed for user DBA.ADMIN
INFO | jvm 1 | 2008/06/11 12:56:07 |
INFO | jvm 1 | 2008/06/11 12:56:07 | at jrockit.reflect.NativeConstructorInvoker.newInstan ce([Ljava.lang.ObjectLjava.lang.Object;(Unknown Source)

For GUEST.ADMIN and SERVPROV.ADMIN

INFO | jvm 1 | 2008/06/11 12:57:14 | java.lang.NullPointerException
INFO | jvm 1 | 2008/06/11 12:57:14 | at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:592)


When I attempt to Login with WRONG information:

For DBA.ADMIN ,GUEST.ADMIN and SERVPROV.ADMIN

INFO | jvm 1 | 2008/06/11 12:57:14 | java.lang.NullPointerException
INFO | jvm 1 | 2008/06/11 12:57:14 | at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:592)


Until now we thought the problem is with current database DATA2.On connecting to the WORKING database DATA1,I am suspecting the problem might be somewhere with the WebLogic Connection Pool.

One issue that really confuses is that I am getting different error msg if I attempt to login with CORRECT info and WRONG info.
Pls provide some input as I am unable to conclude anything. Both DATA1 and DATA2 are running on differenet DB Servers.

I am attaching my glog.properties and WebLogic config.xml as text files in case you wish to look into. The domainName in the attached files isn’t actual domain value.I changed it.

glog.txt
config.txt

Thanks for your time,
Durga

[nick.polites]

Attach your weblogic console.log file. I still think that you have a problem in your database. At the same time, what you can do to confirm/rule this out is shut down both your Unix and Windows instances. Change the glog.properties database entries to point to the database server that your Unix instance is using and then try starting up the Windows environment. If you get a successful login, then you know where your problem is.

[dgoli]

Hi Nick,

Thanks for your patience in replying.

I restarted my Windows Database instance(Data2) and tried login from the Windows OTM instance(OTM2).
But ended up with the same error(I am not supposed to touch Unix Database.So just tried restart with Windows DB).

My colleague suggests there might be problem with the user access in VPD.

I am attaching the console log files from both Tomcat and WebLogic as text files for your reference.

Tomcat_console.txt
Weblogic_console.txt

I really appreciate any suggestions at this point.

Thanks for your time,
Durga

[nick.polites]

If you patched the database to CU4 and didn't recieve any error message then your import was not successful.

In the admin guide it states to run @object_count.sql. Check the results and compare them with what there is supposed to be. You can also attach your dbpatch log from your <<OTM Directory>>/glog/oracle/script8 and I can see if that looks clean.

You are missing at least one table so you won't be able to login until you fix it.

[dgoli]

Mr.Nick,

Thanks for your reply.

As mentioned in the Admin guide,I executed the following query

select object_owner, count(*) from dba_policies
where object_owner in ('GLOGOWNER','REPORTOWNER')
group by object_owner;

and the output is as follows..

GLOGOWNER 20184
REPORTOWNER 224

Upon executing "object_count.sql",I found the ARCHIVE section missing in the results displayed.Do you think this is where I am struck?

I dont see any dbpatch log file located under OTM_HOME\glog\oracle\script8.
I hope you are referring to "dbpatch_55.sql" and attaching the same.

dbpatch_55.txt

Thanks for your time,
Durga

[nick.polites]

If you are missing the archive schema then this is bad and your import log should show you why it wasn't imported.


If you don't have a dbpatch log file then that indicates you did not run the CU patch against the database. This needs to be executed as I have mentioned before bringing up your application.

[dgoli]

Mr.Nick,

Thanks again.

As you suggested,let's assume my current DB(Windows) isn't imported properly because of which I am unable to login.
My doubt is when I make use of other DB(Linux),why do I encounter the same error?
The DB(Linux) is already in being used by another OTM instance(Linux).We have stopped the OTM(Linux) while connecting with the OTM(Windows).

Pls correct me if I assumed anything illogical.

Thanks,
durga

[nick.polites]

I thought you mentioned that you can't point your Windows environment to your Unix DB.

"I restarted my Windows Database instance(Data2) and tried login from the Windows OTM instance(OTM2).
But ended up with the same error(I am not supposed to touch Unix Database.So just tried restart with Windows DB)."

At this point I'm probably more confused with what you did and what you didn't do. I would suggest that you log a ticket with Oracle support and have them do a web session so that they can to the bottom of your issue.

[dgoli]

Mr.Nick,

Sorry for the confusion I have created.
If you can invest some more time,this is what I have done.

"I restarted my Windows Database instance(Data2) and tried login from the Windows OTM instance(OTM2).
But ended up with the same error(I am not supposed to touch Unix Database.So just tried restart with Windows DB)."

Since you have suggested to shutdown both OTM instances,I thought that you are talking about both DB instances.So I restarted ONLY Windows DB instance.That is what I have mentioned in the above stmt.

I did exactly what you have suggested i.e I have shutdown both OTM instances,tried to connect my Windows OTM instance to the DB instance previously being used by Unix OTM instance.
But as before I am unable to login even though I am using previous DB.
But I am getting diff error with this DB instance.

Previously,I was gettting "Table or View doesn't exist/Access denied for DBA.ADMIN".
But this time I got
INFO | jvm 1 | 2008/06/11 12:57:14 | java.lang.NullPointerException
INFO | jvm 1 | 2008/06/11 12:57:14 | at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:592)

I hope I conveyed the info with less confusion now.

Appreciate any updates at this point..

Thanks,
Durga