понедельник, 14 ноября 2011 г.

Oracle: change user password

From SYSDBA
alter user username identified by NEWpassword password expire;
When user username login SQL asked to change password

alter user username identified by NEWpassword;

From user
SQL>password
Old password:
New password:
Retype password:
Password changed
SQL>

воскресенье, 13 ноября 2011 г.

PHP Info


<?php
phpinfo();
phpinfo(INFO_MODULES);
?>

Ручной старт Oracle Instance

Старт листнера
$ lsnrctl start

Запуск SQLPLUS без коннекта
$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 — Production on Sun Nov 13 12:04:01 2011

Copyright © 1982, 2005, Oracle. All rights reserved.

SQL>

Коннект к идле-шной бд и стартап инстанса
SQL>conn / as SYSDBA
Enter password:
Connected.

SQL>startup
ORACLE instance started.
Total System Global Area  603979776 bytes
Fixed Size                1220796 bytes
Variable Size             167776068 bytes
Database Buffers          427819008 bytes
Redo Buffers              7163904 bytes
Database mounted.
Database opened.

Google-chrome + CentOS 6

При запуске Google Chrome выдает ошибку с таким вот содержанием:
/usr/bin/google-chrome: /lib/libz.so.1: no version information available (required by /usr/bin/google-chrome)
/usr/bin/google-chrome: /lib/libz.so.1: no version information available (required by /usr/bin/google-chrome)
/opt/google/chrome/chrome: error while loading shared libraries: cannot restore segment prot after reloc: Permission denied

Решение довольно таки простое, необходимо просто изменить политику SELinux для файла chrome-sandbox:
chcon -t usr_t /opt/google/chrome/chrome-sandbox
TNX автору

воскресенье, 23 октября 2011 г.

How to simple create backup for all packages in FreeBSD

Create and go to the folder where you want create backup packages
# mkdir /BACKUP && cd /BACKUP

Create list file packages for next editing to our script
# ls -1 /var/db/pkg/ > list.sh

Edit list.sh
replace "\n" to " && pkg_create -v -b "
move last " && pkg_create -v -b " to begin file
remove first " && " from the begin
go to start line
insert "#!/usr/local/bin/bash"
create new line

Make file executable
chmod +x list.sh

Execute script
# ./list.sh

©by Kuzzya