quick start oracle database

> lsnrctl start LISTENER_REPORT
> sqlplus "/as sysdba"
SQL> startup
--------
LISTENER_REPORT - listener name

oracle create user

Create oracle scheme and user with useful rights

execute by DBA

create user my_user_name identified by User0paSS12wOrd;

alter user my_user_name
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON users
ACCOUNT UNLOCK;

GRANT
create session,
CONNECT,
--RESOURCE,  
--DBA,
CREATE DATABASE LINK,
CREATE MATERIALIZED VIEW,
CREATE PROCEDURE,
CREATE PUBLIC SYNONYM,
--CREATE ROLE,
CREATE SEQUENCE,
CREATE SYNONYM,
CREATE TABLE,  
CREATE TRIGGER,
CREATE TYPE,
CREATE VIEW,
CREATE JOB
to my_user_name;

windows install php apache mysql

1) apache from http://apache.org/dist/httpd/binaries/win32/
2) add to httpd.conf

LoadModule php5_module "d:/development/PHP/php-5.4.11/php5apache2_2.dll"
AddHandler application/x-httpd-php .php
PHPIniDir "d:/development/PHP/php-5.4.11"
3) create virtualhost like this


<VirtualHost 127.0.0.7:80>
ServerAdmin devki@gmail.com
ServerName dev.ki
ServerAlias dev.ki
ServerAlias www.dev.ki
DocumentRoot "d:/development/www/ki/site"
       <Directory />
Options All
AllowOverride All
   </Directory>
ErrorLog "d:/development/httpd/httpd2.2/logs/dev.ki.error.log"
CustomLog "d:/development/httpd/httpd2.2/logs/dev.ki.access.log" combined
LogLevel warn
</VirtualHost>
4) start mysql in log / debug mode
mysqld --general-log

5)  in skype uncheck the check box for Use port 80 and 443 as an alternatives for incoming connections option

to be continued...

All except this is pretty clear

[Windows] instantclient + SQL Navigator

1) install only 32 bit instantclient. (instantclient_folder). download all packages. basic, sqlplus, etc.
2) install SQL Navigator not in .\Program Files (x86)\. Only in .\Program Files\. or d:\***\
3) set %ORACLE_HOME%=%TNS_ADMIN%=%LD_LIBRARY_PATH%=instantclient_folder. add to %PATH%
4) set %NLS_LANG% = *** (for new db for russia RUSSIAN_CIS.RU8PC866)
5) create tnsnames.ora in %ORACLE_HOME%

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.44)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

6) if you want use tnsnames, you need to set ORACLE_HOME as path to oracle client in SQL Navigator.
??