Oracle XE installation problem

Have a problem with Oracle Database 10g Express Edition?
Oracle is installed but doesn't work?

This is caused by that your account is given from domain server or your system has non-English locale.

HowTo resolve this problem:

1. Create local user (this user should not be a domain account).



2. Set OS system locale to English (US or UK, via Regional and Language Options), reboot.



3. Install Oracle XE under local user (via runas console program or via Run as... from Windows Explorer popup menu).



4. Open file "Oracle\app\oracle\product\10.2.0\server\NETWORK\ADMIN\sqlnet.ora
   and comment (via # symbol) or remove line SQLNET.AUTHENTICATION_SERVICES = (NTS)



5. Open shell, type sqlplus oracle_user/oracle_password and work with Oracle XE.

MySQL shell scripting

MySQL is the best. The best database server. I love it.
I like and appreciate its simplicity, efficiency, small size, good help, cool shell utilities. And its price :-)

I've worked with MySQL many years. And I can't understand some another database systems like Oracle, that big, heavy and high-priced. I can't stand theirs complexity.



You can use this server as you want. You can embed it into your application.
MySQL also pretty good in the console.

You can execute sql script from file e.g.:

---

data.sql

insert into Sample (name, address) values ('sample name', 'sample address');



with the simple command:

---

exec.cmd

@echo off
SET DATABASE_HOST=localhost
SET DATABASE_NAME=db
SET DATABASE_USER=root
SET DATABASE_PASSWORD=********

mysql -h %DATABASE_HOST% -u %DATABASE_USER% -p%DATABASE_PASSWORD% -e "source data.sql" %DATABASE_NAME%


and dump data from database with this command:

---

dump.cmd

@echo off
SET DATABASE_HOST=localhost
SET DATABASE_NAME=db
SET DATABASE_USER=root
SET DATABASE_PASSWORD=********

md tables
mysqldump --compact --no-create-info --tab=tables -h %DATABASE_HOST% -u %DATABASE_USER% -p%DATABASE_PASSWORD% %DATABASE_NAME%


For these purposes you should have only 2 files from mysql: mysql.exe and mysqldump.exe

Power Designer - the best UML and database modeling tool

The best software modeling tool which I've ever used is Power Designer from Sybase.
I've got acquainted with this program some years ago (it was a repackaged version "QDesigner" by Quest Software).



I've really enjoyed developing with this tool.
This tool is very useful and usable, flexible, easy to use and pretty good.

Power Designer CD contains some visual samples.



Object Oriented Model

It is possible to create UML diagrams (classes, sequence, deployment, etc.) and generate source codes (for many programming languages) from the model.



Physical Data Model

Development of a database turns to pleasure. Power Designer can generate SQL scripts with databases and tables definitions. Also it can create test data sets.



I've tested and evaluated some trial versions of Power Designer and I may say "it is the best".



You may download free evaluation copy of Power Designer or buy it.