Not Equal C && !=C && 不等于西
RSS icon Email icon Home icon
  • One Script to Backup All SQL Databases

    Posted on August 15th, 2011 Sean Add comments

         It’s a nightmare for backup your DB if you have 100+ DB’s in SQL server. Just simply run a script while you taking a coffee:

  • 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading...Loading...
    262 views
  • Visual Studio Website Administration Tool & SQL Server Express

    Posted on June 24th, 2010 Sean 1 comment

          In Visual Studio the Website Administration Tool lets you view and manage the Web site configuration through a simple Web interface. But sometimes there is problem which is when using the Website Administration Tool to make a new connection for a new website, for example, using the security tab of the Website Administration Tool to manage rules for securing specific resources in the web application or website, it will display an error message “Unable to connect to SQL Server database”, even you have SQL Server Express installed and no problem to connect to it.
          To solve this problem, try one or more of the following ways:
    Read the rest of this entry »

  • 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading...Loading...
    871 views
  • ORACLE databse can not start by missing tablespace file

    Posted on February 13th, 2010 Sean 1 comment

         Today, as usual, trying to login to Oracle database do something, but when typing “sqlplus” and username/password, it showing:

         It seems like Oracle database was not starting somehow. After connect the database as SYSDBA, type some command for trying to restart the datadase:

         Now finally realized what happened and how this happened. There is a tablespace file “XXX.dbf” missing. To solve this issue, connect database as SYSDBA, then:

  • 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading...Loading...
    558 views
  • Create tablespace on NFS based LINUX + Oracle

    Posted on February 8th, 2010 Sean Add comments

         When the first time to create tablespace on SQLplus, it shows:

    “ORA-27040: file create error, unable to create file. Linux-x86_64 Error: 13: Permission denied”

    So I just change my home directory to “777”, then getting the error

    “ORA-27054: NFS file system where the file is created or resides is not mounted with correct options”

         After check the “autofs” settings, I found the content of file “auto.home” has problem which is something wrong with NFS mount options. The solutions is change the original content

    * -fstype=nfs,soft,intr,rsize=8192,wsize=8192,nosuid,tcp oracle.server.com:/users/&

    to

    * -rw,bg,hard,intr,rsize=32768,wsize=32768,suid,nfsver=3,tcp oracle.server.com:/users/&

  • 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading...Loading...
    913 views