Oracle UTF-8

Hello,

Most of times when we deployed our projects in some Cyrillic supported country we meet with problem to display properly. Thats why I am posting this solution here may be it saved your time.

Do not hesitate  to commenting :)

1) Enter from sqlplus / as sysdba
2)shutdown immediate

Database closed.
Database dismounted.
ORACLE instance shut down.
3) startup restrict
ORACLE instance started.

Total System Global Area 2.0602E+10 bytes
Fixed Size                  3842760 bytes
Variable Size            2751466808 bytes
Database Buffers         1.7784E+10 bytes
Redo Buffers               63262720 bytes
Database mounted.
Database opened.

4)alter database character set INTERNAL_USE AL32UTF8;

Database altered.

5)alter database character set AL32UTF8;

Database altered.

6) shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
7) startup
ORACLE instance started.

Total System Global Area 2.0602E+10 bytes
Fixed Size                  3842760 bytes
Variable Size            2751466808 bytes
Database Buffers         1.7784E+10 bytes
Redo Buffers               63262720 bytes
Database mounted.
Database opened.

Port forward in Windows

Hi, again problem with connection between VMWare and Cisco router, router allow connection just from one machine but we have to use also second server.

So our solution is NETSH in Windows, we will create this rules in first Windows machine which have access to Cisco:

Command for port forwarding
netsh interface portproxy add v4tov4 listenaddress=192.168.28.30 listenport=8099 connectaddress=192.168.20.96 connectport=8083

Command for check result
netsh interface portproxy show all

Command for delete rule
netsh interface portproxy delete v4tov4 listenport=8099 lictenaddress=192.168.1.30

ORA-39006: internal error; ORA-39213: Metadata processing is not available;

Oracle 11.2.0.3 - 64 bit on Windows

When using IMPDP you get the error :

ORA-39006: internal error

ORA-39213: Metadata processing is not available

Workaround 

sqlplus / as sysdba

SQL> execute sys.dbms_metadata_util.load_stylesheets;

ORA-39006: internal error; ORA-39213: Metadata processing is not available;

Oracle 11.2.0.3 - 64 bit on Windows

When using IMPDP you get the error :

ORA-39006: internal error

ORA-39213: Metadata processing is not available

Workaround 

sqlplus / as sysdba

SQL> execute sys.dbms_metadata_util.load_stylesheets;

Port 80 already in use

Port 80 already in use
Hi Dears, always after installation XAMP or other WEB server we meet with problem when Apache can not start properly because port 80 busy now, so below I write little and fast guide I hope it will save time for somebody.

1) Press Start and type "cmd"  then click right button of mouse and start as Administrator
2) After type "netstat -a -n -o"
3) On fields PID you see pid of process which used port 80
4) In cmd type tasklist /svc /FI "PID eq 1348" where is PID your PID of process which used port 80
5) Open Task Manager and in Processes find needed process and kill and start Apache

ERROR 1045 (28000) Access denied for user 'root'@'localhost'

Запускаем в режиме без проверки прав доступа: /usr/bin/mysqld_safe --skip-grant-tables & Соединяемся как root без пароля: mysql --user=root mysql Обновляем пароль: mysql> update user set Password=PASSWORD('новый пароль') WHERE User='root'; mysql> flush privileges; Перезапускаем БД и пробуем войти под рутом с паролем mysql -u root -p

Tajik MAC, Таджикский язык в МАК-е, Забонӣ тоҷики дар МАК

https://dl.dropbox.com/u/46870715/k/tajik.zip  --ин нишони барнома

Барои истифода архив-ро кушода папкаи tajik-ро дар Home/Library/Keyboard Layouts  гузоред, баъд аз он МАК-ро хомуш карда аз нав гирон кунед. Барори кор :)

https://dl.dropbox.com/u/46870715/k/tajik.zip  --path for download


Download and unpack then put in  Home/Library/Keyboard Layouts. Restart your MAC and can use Tajiki language