Friday, August 16, 2013

OVD start problem: java.net.BindException: Address already in use

We had this issue where we got this error 2 -3 times before we could start OVD.Its due to Port is being left in TIME_WAIT state.So port will be busy till TCP times it out.Error will be as below.

[2013-08-14T00:04:41.496-06:00] [octetstring] [NOTIFICATION] [] [com.octetstring.vde.frontend.LDAP] [tid: 10] [ecid: 0000K1vRExO6MQRVMY^QsA1I2lrj000000,0] Listening on Port=11,539 Mode=Blocking
[2013-08-14T00:04:41.508-06:00] [octetstring] [NOTIFICATION] [OVD-20203] [com.octetstring.vde.frontend.LDAP] [tid: 10] [ecid: 0000K1vRExO6MQRVMY^QsA1I2lrj000000,0] Port allocated for LDAP SSL Endpoint:LDAP.
[2013-08-14T00:04:41.672-06:00] [octetstring] [ERROR] [OVD-60216] [com.octetstring.vde.VDEServer] [tid: 10] [ecid: 0000K1vRExO6MQRVMY^QsA1I2lrj000000,0] Cannot start Oracle Virtual Directory server: Address already in use.[[
java.net.BindException: Address already in use
       at java.net.PlainSocketImpl.socketBind(Native Method)
       at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:383)
       at java.net.ServerSocket.bind(ServerSocket.java:328)
       at com.octetstring.vde.frontend.LDAP.doAllocatePort(LDAP.java:236)
       at com.octetstring.vde.frontend.LDAP.startListener(LDAP.java:481)
       at com.octetstring.vde.frontend.ListenerHandler.addListener(ListenerHandler.java:100)
       at com.octetstring.vde.frontend.ListenerHandler.init(ListenerHandler.java:91)
       at com.octetstring.vde.VDEServer.startServer(VDEServer.java:181)
       at com.octetstring.vde.VDEServer.main(VDEServer.java:359)

]]
[2013-08-14T00:04:41.672-06:00] [octetstring] [NOTIFICATION] [OVD-20052] [com.octetstring.vde.VDEServer] [tid: 10] [ecid: 0000K1vRExO6MQRVMY^QsA1I2lrj000000,0] Oracle Virtual Directory Server is shutting down.


Seems like it can be fixed 11.1.12 onwards as below.

- In the em
- Under "identity and access", select ovd1
- Right click the mouse and select administration > listeners
- Select LDAP endpoint ,LDAP SSL Endpoint and Admin gateway select one by one and edit
- Under socket options, select "reuse address".Check it.Save it
 - Restart OVD.

Thursday, August 15, 2013

Opatch lock

[Aug 14, 2013 10:37:22 PM]   Stack Description: java.lang.RuntimeException: Lock file left by a different patch, OPatch will not try re-using the lock file.


While applying a patch was getting this error, this happens when patch session is terminated and old session still hangs around.

Go to ORACLE_HOME/.patch_storage

Rename the file patch_locked and retry applying patch.

Saturday, August 10, 2013

Database relink: Could Not Locate $ORACLE_HOME/network/admin/shrept.lst

We moved database to new host, so did a relink all on database,

/prod/112/bin/genclntsh
genclntsh: genclntsh: Could not locate  /prod/112/network/admin/shrept.lst
make: *** [client_sharedlib] Error 1
Error in invoking target 'client_sharedlib' of makefile '/prod/112/rdbms/lib/ins_rdbms.mk'. See '/prod/112/install/relinkActions2013-08-10_08-25-07-AM.log' for details.



INFO: /prod/112/bin/genclntsh

INFO: genclntsh: genclntsh: Could not locate  /prod/112/network/admin/shrept.lst

INFO: make: *** [client_sharedlib] Error 1

INFO: End output from spawned process.
INFO: ----------------------------------
SEVERE: oracle.sysman.oii.oiil.OiilActionException: Error in invoking target 'client_sharedlib' of makefile '/prod/112/rdbms/lib/ins_rdbms.mk'. See '/prod/112/install/relinkActions2013-08-10_08-25-07-AM.log' for details.
        at oracle.sysman.oii.oiis.OiisMakeDeps.invokeMakefile(OiisMakeDeps.java:544)
        at oracle.sysman.oii.oiis.OiisMakeDeps.doRelink(OiisMakeDeps.java:621)
        at oracle.sysman.oii.oiis.OiisMakeDeps.doOperation(OiisMakeDeps.java:802)
        at oracle.sysman.oii.oiis.OiisMakeDeps.main(OiisMakeDeps.java:812)

INFO:


Solution:
======

For 9.2 or 10.2, if the file is missing, create $ORACLE_HOME/network/admin/shrept.lst with a text editor and put the following lines into it.

network : snaumihi_inithostinfo
network : snaumbg_gmt
network : naedpwd_encrypt
network : naumbsb_bld_singlebyte
network : ztapis

For 11.1.0.6.0, 11.1.0.7.0, 11.2.0.1.0 and 11.2.0.2.0  if the file is missing, create $ORACLE_HOME/network/admin/shrept.lst with a text editor and put the following lines into it.

network : snaumihi_inithostinfo
network : snaumbg_gmt
network : naedpwd_encrypt
network : naumbsb_bld_singlebyte
network : ztapis
network : nlgh

For 11.2.0.3.0, if the file is missing, create $ORACLE_HOME/network/admin/shrept.lst with a text editor and put the following lines into it.

network : snaumihi_inithostinfo
network : snaumbg_gmt
network : naedpwd_encrypt
network : naumbsb_bld_singlebyte
network : ztapis
network : nlgh
network : ztvp52

 Using the 'ls -al' command, check that the file has 644 permissions:
-rw-r--r-- $ORACLE_HOME/network/admin/shrept.lst
If necessary, change the permissions using the command:
chmod 644 $ORACLE_HOME/network/admin/shrept.lst
Now manually relink using the command 'relink all'

Wednesday, August 7, 2013

Unable to activate JDBC store(BEA-280077)

Some customer was trying to activate JDBC store,i checked the logs and found this.

<Aug 7, 2013 4:03:23 AM CDT> <Warning> <Store> <BEA-280076> <Database table "WLStore" for store "test" is currently owned by "[name={server=osb_server1!host=140.85.192.10!domain=soa_domain!store=AHSOSBJDBCStore!table=WLStore}:random=5697096127807814759:timestamp=1375866194364]". Trying to wait for ownership.>
<Aug 7, 2013 4:03:43 AM CDT> <Error> <Store> <BEA-280077> <JDBC store "test" in this server is not the owner of database table "WLStore". Unexpected current owner is "[name={server=osb_server1!host=140.85.192.10!domain=soa_domain!store=AHSOSBJDBCStore!table=WLStore}:random=5697096127807814759:timestamp=1375866214386]", expected current owner is "[name={server=osb_server1!host=140.85.192.10!domain=soa_domain!store=test!table=WLStore}:random=-1796623192164004707:timestamp=1375866203282]".>
<Aug 7, 2013 4:03:43 AM CDT> <Error> <Store> <BEA-280072> <JDBC store "test" failed to open table "WLStore".
weblogic.store.io.jdbc.JDBCStoreException: [Store:280064]280077 (server="osb_server1" store="test" table="WLStore")
       at weblogic.store.io.jdbc.JDBCStoreIO.checkTableOwnership(JDBCStoreIO.java:2621)
       at weblogic.store.io.jdbc.JDBCStoreIO.getTableOwnershipLogical(JDBCStoreIO.java:2734)
       at weblogic.store.io.jdbc.JDBCStoreIO.open(JDBCStoreIO.java:495)
       at weblogic.store.internal.PersistentStoreImpl.recoverStoreConnections(PersistentStoreImpl.java:436)
       at weblogic.store.internal.PersistentStoreImpl.open(PersistentStoreImpl.java:423)
       Truncated. see log file for complete stacktrace>
<Aug 7, 2013 4:03:43 AM CDT> <Error> <Store> <BEA-280061> <The persistent store "test" could not be deployed: weblogic.store.io.jdbc.JDBCStoreException: open failed

weblogic.store.io.jdbc.JDBCStoreException: open failed

Cause:
 The cause of this issue is that the database table representing the store is locked by another JMS server at the same time, as is indicated by the error message. This setup of using the same underlying database table to represent more than one JDBC Store is not recommended or supported.  

Solution:
Please ensure that for each JDBC Store you set the prefix for the store to a unique value for each configured JDBC store table, as mentioned in the URL http://download.oracle.com/docs/cd/E12839_01/web.1111/e13701/store.htm#i1143431. This will ensure that each store has its own table.

Friday, August 2, 2013

Case Insensitive Searching in WebCenter Content (UCM) 11g

A customer said if i search a document named "Test" it is searchable.But searching it as "test" doesnot give any results.So they wanted to enable case insensitive searching.This was on Webcenter content 11g .We discarded the idea that  10g OracleCaseInsensitiveSearch component will work for 11g as oracle doesnot support it.But its known to be used for those customers that refuse to implement OTS(Oracle Text serach).

So i gave below plan to fix their issue.

1)cd <clusterhome>/ucm_cluster/cs/config/config.cfg
add this,

SearchIndexerEngineName=OracleTextSearch
MaxIndexableFileSize=0

save and exit the file.

2)Restart WLS_WCC1 and WLS_WCC2(as this was cluster)

3)login to content server

In the WebCenter Content browser page, navigate to Administration --> Admin Applets --> Repository Manager.

Select the Indexer tab.

In the Automatic Update Cycle panel, click the Configure button.

Uncheck the Enabled box.

Click the OK button.

In the Collection Rebuild Cycle panel, click the Start button.

Uncheck the Use fast rebuild box.

Click the OK button.

After the rebuild has completed, click the Configure button in the Automatic Update Cycle panel.

Check the Enabled box.

Click the OK button.