Sharepoint 3.0 , Search not working

One of our sharepoint 3.0 which comes with the Project server has a search problem, some users cannot search at all . After testing at UAT we find that to resolve it need to run the sharepoint update (infrastructureupdateforwindowssharepointservices3.0-kb951695-fullfile-x86)

This is how we do it,

Backup the sharepoint using stadm
Run the Sharepoint Update ( at this point we have the error that it cannot upgrade due to the the The B2B upgrader timer job failed ) which is at the steps 8.

To resolve this we follow the link here http://blog.mediawhole.com/2009/05/sharepoint-sp2-upgrade-fails-b2b.html , at this part

Here is what I did:

I copied web.config file from 12\CONFIG to 12\TEMPLATE\LAYOUTS.

The I did run:
psconfig -cmd upgrade -inplace b2b -force -wait

That's it.

After this, we manage to upgrade we find that the search is working fine. But then we have the exception error in SQL server 2005
the mssql dump looks like due from sharepoint search sql

From the sql server logs,
SqlDumpExceptionHandler: Process 71 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION

SQLDUMPER_UNKNOWN_APP.EXE, ValidateModule: Potential image problem at 0x77E64841: read 0xE9 instead of 0x8B (module C:\WINDOWS\system32\kernel32.dll)

From the sharepoint logs,
CSqlCrawl::ExecuteCommand fails Error 0x80004005 - File:d:\office\source\search\search\gather\server\gathersql.cxx Line:408

Based on the error , suspect due to the SQL Server 2005. We upgrade it to SP4 and the issue resolve perfectly.

Linux, finding out the hidden process that is using the port

Follow this link, http://tldp.org/HOWTO/Security-Quickstart-HOWTO/appendix.html

netstat -tapn

Active Internet connections (servers and established)

Local Address Foreign Address State PID/Program name
*:printer *:* LISTEN 988/inetd
bigcat:8000 *:* LISTEN 1064/junkbuster
*:time *:* LISTEN 988/inetd
*:x11 *:* LISTEN 1462/X
*:http *:* LISTEN 1078/httpd
bigcat:domain *:* LISTEN 956/named
bigcat:domain *:* LISTEN 956/named
*:ssh *:* LISTEN 972/sshd
*:631 *:* LISTEN 1315/cupsd
*:smtp *:* LISTEN 1051/master

which will be able to show the process

Windows 7, 32bit/64bit running Virtual Box and VPN

If you're using a virtual Machine under virtual box and using the software cisco checkpoint VPN-

1 Secure Client NGX R60 to connect to your office vpn

1. First you need to setup your VM network connection as bridge connection.

2. If facing problem in the phase 1 of the vpn connection while defining your site you can do this. From another PC with good working VPN connection, export out the registry including subfolder

HKLM\Software\checkpoint\SecureRemote\5.0\sites

then shutdown the good vpn client services. After that copy the folder C:\Program files\CheckPoint\SecureRemote\database

Then , in the VM while shutting down the vpn client services register the reg that you copy from the good PC and also replace the original database folder in the VM

After that restart back the secureremote services. The site now exists for you to run.

Resolving ORA-24005 Queue error ,when dropping a schema or a table

Follow this link,

http://decipherinfosys.wordpress.com/2007/05/16/resolving-ora-24005-when-dropping-a-schema-or-a-table/

SQL> execute DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => ‘DECIPHER_AQ_DEMO’, force => true);

Same can be used on getting ORA-24005 while dropping table

Resolving tempdb log file is full in SQL2000

In SQL 2000, if you have the error,

"The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space."

To resolve this you need to truncate the log file by using

dump log tempdb with truncate_only

the normal backup log command won't work in this case

sendmail, Solving ‘host name lookup failure’ at name server

This summary is not available. Please click here to view the post.

Logical Standby with Apply Process Fails With ORA-308

Recently, we encounter the Logical Standby Apply Process Fails With ORA-308 while testing the logical standby. Due to the archive log in Logical is automatically delete after a while.

To solve it, we first stop the automatically delete archivelog
exec dbms_logstdby.apply_set('LOG_AUTO_DELETE', 'FALSE');


Then, We check the ASM diskspace for the archivelog that is needed by standby.
Then we copy the archive log to the local folder for transfering it to standby by issuing below . The FLASH_DIR and EXPORT_DUMP_DIR is oracle directory, FLASH_DIR is the ASM disk space like +FLASHGRP/TESTDB/archivelog/

dbms_file_Transfer.copy_file('FLASH_DIR','1_3470_694714878.dbf','EXPORT_DUMP_DIR','1_3470_694714878.dbf');


After copying the file to standby, then we need to register the archivelog using below method.

Register the log file in standby

SQL> alter database register logfile '/TESTDB/archive/1_3470_694714878.dbf';

alter database register logfile '/TESTDB/archive/1_3470_694714878.dbf'

*

ERROR at line 1:

ORA-01289: cannot add duplicate logfile

If failed , then we have to update the logmnr table manually,

Stopped the logical standby.

SQL> alter database stop logical standby apply;

SQL> select file_name from system.logmnr_log$ where sequence#=3470;

FILE_NAME

------------------------------------------------------------------------------------------------------------------------------------------------------

+FLASHGRP/testdb/archivelog/2010_09_22/thread_1_seq_3470.3572.730402825

SQL> UPDATE SYSTEM.LOGMNR_LOG$ SET

FILE_NAME= 2 '/TESTDB/archive/1_3470_694714878.dbf' where sequence#=3470;

1 row updated.

SQL> commit;

Commit complete.

SQL> alter database start logical standby apply;

Database altered.

References:-
Logical Standby Apply Process Fails With ORA-308 [ID 274676.1]