ATI HD4650 is not supported by Ubuntu 9

Sigh , I wanted to support AMD, hence bought Gigabyte ATI 4650, however
-- laggy in centos, even is text content
-- black screen with ubuntu 9 live CD (installation CD) (intended to reinstall to ubuntu 9)
-- it looks ubuntu is sensitive ot ATI chipset. (had same experience with ATI 3450, which is not stable drived me to replace ATI3450)

no choice have to switch to nvidia, thanks to the shop to allow me to exchange to nvidia 9600GT.
-- wasting me 1 day time

plug it onto motherboard, everything goes smoothly.
to my surprise, no need to reinstall Ubuntu, and it already comes with its own version to drive the video card
nvidia-glx-180, which can even support 9800GT

not like CentOS need to download the driver from nvidia.com, which is also not tedious.
invoke "init 3 " to logout X windows
run the NVIDIAxxx.run

some things to take note
-- no need extra power for 9600, can run with my 450w power supperlier
-- need to occupy an extra PCI slot from huge fan, other than the PCI express lsot.
-- Looks still lacking of official centralized linux hardware compatible list, existing one is not update frequently and update-to-date.
-- big vendor should spend more effort to Linux community. Otherwise, less market share/lower stock price is their pay back.

centos yum fastestmirror

installed fastestmirror plugin , but still slow at 10kb/s.

check my root@localhost pluginconf.d]# cat /var/cache/yum/timedhosts.txt
ftp.riken.jp 0.161697864532
ftp.yz.yamagata-u.ac.jp 0.213155031204
ftp.oss.eznetsols.org 99999999998
ftp.iij.ad.jp 0.18056511879
mirror.averse.net 0.159833192825
mirror.nus.edu.sg 0.244224071503
ftp.nara.wide.ad.jp 0.163350105286
rsync.atworks.co.jp 0.171188831329
ftp.jaist.ac.jp 0.156664848328
www.ftp.ne.jp 0.525522947311
mirror.usonyx.net 0.160475969315

many sites are from Japan, while I am in singapore.

decide to exclude .jp sites by set "exclude=.gov, facebook, .jp" in
[root@localhost pluginconf.d]# cat fastestmirror.conf
[main]
enabled=1
verbose=0
socket_timeout=3
hostfilepath=/var/cache/yum/timedhosts.txt
maxhostfileage=10
maxthreads=15
exclude=.gov, facebook, .jp


cheers, now can see at least 150kb/s. that is 15 times.

also notice one site is available , will exclude it also.

22:04:54 : Downloading Packages:
22:05:26 : Failure getting http://mirror.averse.net/centos/5.3/os/x86_64/CentOS/gnome-keyring-devel-0.6.0-1.fc6.i386.rpm:
22:05:26 : --> [Errno 12] Timeout:
22:05:26 : Trying other mirror.

How do I connect to a non-default instance of SQL Server?

The convention of "Data Source" (for creating link server) or "Server Name" (called in management studio" is : ,/ or /,

Here is a connection string that attaches to an instance of SQL Server that is NOT the default instance.


cst = "Provider=SQLOLEDB;" & _
"Data Source=127.0.0.1\instanceName;" & _
"Initial Catalog=pubs;" & _
"Network=DBMSSOCN;" & _
"User ID=;" & _
"Password="

set conn = CreateObject("ADODB.Connection")
conn.open cst


If your instance is running on a non-default port (by default, SQL Server runs on 1433):


cst = "Provider=SQLOLEDB;" & _
"Data Source=127.0.0.1,1510\instanceName;" & _
"Initial Catalog=pubs;" & _
"Network=DBMSSOCN;" & _
"User ID=;" & _
"Password="

set conn = CreateObject("ADODB.Connection")
conn.open cst

about DBA_HIST_SEG_STAT

DBA_HIST_SEG_STAT displays historical information about segment-level statistics. This view captures the top segments based on a set of criteria and captures information from V$SEGSTAT. The total value is the value of the statistics since instance startup. The delta value is the value of the statistics from the BEGIN_INTERVAL_TIME to the END_INTERVAL_TIME in the DBA_HIST_SNAPSHOT view.

The DML counters from this view represent the number of DML operations since the last gather statistics.
The overhead on performance is not to be considerable since this mechanism work on memory and flush changes to DBA_TAB_MODOFICATIONS view periodically.

In 9i, tables should be implemented with monitoring by executing "alter table ... monitoring", but in 10g monitor is enabled by default.

The advantage of this feature is when gathering statistics.
Based on the dba_tab_modifications view we can gather statistics for only tables that have more than X% changes (compared to num_rows in user_tables) since last gather statistics.


exec dbms_stats.flush_database_monitoring_info; to refresh the view.

Error uploading configuration data to the repository

[ERROR MESSAGE]

Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Unlocked mgmt_view account
Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully unlocked mgmt_view account
Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: OCP11G, oracleHome: /apps/oracle/product/11.2.0, and user: SYS
Jul 11, 2009 9:33:34 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Jul 11, 2009 9:33:40 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: Passed listener validation check.Listener is up and running.
Jul 11, 2009 9:33:40 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Jul 11, 2009 9:33:40 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
CONFIG: Error uploading configuration data to the repository
oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions

at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:674)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:370)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /apps/oracle/cfgtoollogs/emca/OCP11G/emca_repos_config_.log for more details.
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error uploading configuration data to the repository
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error uploading configuration data to the repository
Refer to the log file at /apps/oracle/cfgtoollogs/emca/OCP11G/emca_2009_07_11_21_27_18.log for more details.
Jul 11, 2009 9:33:48 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error uploading configuration data to the repository
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:382)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)



[ROOT CAUSE]
try some solution from internet, related to password file, listener, ORACLE_HOSTNAME.

recalled recent there is block error & fixed duing Linux booting , which are related to 11.1.0.7 ORACLE_HOME.

[SOLUTION]
1. reinstall the oracle software
2. copy old PFILE, password file and listener.ora &tnsnames.ora
3.emca -deconfig dbcontrol db -repos drop
4. emca -config dbcontrol db -repos create
cheers, see the follow messages

INFO: >>>>>>>>>>> The Database Control URL is https://localhost:1158/em <<<<<<<<<<<
Jul 12, 2009 2:27:16 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /apps/oracle/product/11.1.0/localhost_OCP11G/sysman/config/emkey.ora. Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 12, 2009 2:27:16 PM
You have new mail in /var/spool/mail/oracle

How long does csscan take?

It took me near 6 hours, maybe because the database has tens of thousands user tables ...

Far away from our estimation based on number of convertible rows.
--This may not the right assumption.

So be prepared enough for downtime.