Jun 18, 2007

what is #tmpDBCCinputbuffer?

I often see an active process in Activity Monitor in SSMS, its detail likes the following.
What's that?

create table #tmpDBCCinputbuffer ([Event Type] nvarchar(512), [Parameters] int, [Event Info] nvarchar(512))
insert into #tmpDBCCinputbuffer exec ('DBCC INPUTBUFFER(72)')
select [Event Info] from #tmpDBCCinputbuffer

It is the process of Activity Monitor itself.

Jun 7, 2007

Windows Vista First Touch

My new desktop comes with Windows Vista. It's cool. I would like to try if things I need work or not.

1. Oracle 10g client
10.2.3.0 is cetified by Oracle. However, Vista still popped up incompatible warning. It works fine.

2. Oracle 9i client
I need Oracle 9i client to access some greatgrand-level databases(ex.8.1.6, as the new baby 11g is coming). I used 9.2.0.1.0, it got incompatible warning too, but it seems working fine.

3. PL/SQL Deveoper

When I run PL/SQL Developer 6, I got OCI error message. I thought of this issue occuring before. After granding full control permission of Oracle files to my domain user, it works.

4. SQL Server 2005

As I need to set up SQLH2, which requires SQL Server and Reporting service.
When I tried to install SQL Server 2005, I saw IIS warning message during system configuration checking. After searched in google, the workaround is found:

4.1. From Microsoft Support Site:
"You receive a warning message on the System Configuration Check page of the SQL Server 2005 Setup program on a computer that is running Windows Vista or a Server Core installation of Windows Server "Longhorn"" http://support.microsoft.com/kb/920201

4.2. Martin Poon's blog:
http://msmvps.com/blogs/martinpoon/archive/2006/12/08/installation-of-sql-server-2005-in-windows-vista-warning-message-on-iis-feature-requirement-during-system-configuration-check.aspx

After reconfigured and restarted IIS 7 on Vista, system config checking is all passed. SQL Server is installed successfully with Reporing Service.
For Vista, it required SQL Server 2005 SP2.

Other Notes:

To install IIS 7 or the IIS 7 components in Windows Vista, visit the following IIS Web site:
http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=957

To install IIS 7 or the IIS 7 components in a Server Core installation of Windows Server "Longhorn," visit the following IIS Web site:
http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=956

How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer
http://support.microsoft.com/kb/934164

Running SQL Server on "Microsoft Windows Server Longhorn" or Microsoft Windows Vista
http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx

Oracle Application Server Control 10g page not found

After installed Oracle application server 10g 10.1.3.1.0, ascontrol and applications were working properly. However after sysadmin rebooted the server, ascontrol got 404 error "The page cannot be found" .http://yourhost:7777/em/ Application got the error:

Fatal error
Webapplication did not initialize properly during startup - please try again later

--
--Fix:
--
1. in the file default-web-site.xml under OracleAS home ~/j2ee/home/config/
ohs-routing default is false, change it to true.

2. in the file server.xml under OracleAS home ~/j2ee/home/config/
change start attribute for application ascontrol to true. Default is false.

3. restart the servers

$ opmnctl status
$ opmnctl stopall
$ opmnctl startall
$ opmnctl status