Tuesday, 31 January 2017

screen commands

›
screen -> start the tool ctrl + a -> control screen ctrl + a + c -> define new screen ctrl + a + n -> s...

How to remove datafile carefully?

›
find datafile path; SQL>  select file_name from dba_data_files; before run rm; $ cd /oradata $ lsof * $ rm -f alper_data_01.dbf
Monday, 30 January 2017

ORA-27137 Solution

›
Error ORA-27137: unable to allocate large pages to create a shared memory segment Solution Comment out this in pfile; ###*.use_large_p...
Wednesday, 25 January 2017

How to define/use Oracle domain index?

›
What is domain index?: Oracle says that domain indexes reformed beyond to the basic types of hash, bitmapped, and B-tree indexes that deve...

How to list/define/delete shared folder in Windows?

›
Check shared folder CMD> net share Share a folder CMD>   net share Alperinko$=D:\Oracle /grant:everyone,FULL /users:25 -> Al...
Monday, 23 January 2017

How to configure login options in Oracle?

›
Apply the option permanently sec_case_sensitive_logon=FALSE or sec_case_sensitive_logon=TRUE Check the parameter SQL> show parame...
Friday, 20 January 2017

How to start/stop/configure vnc service?

›
install tool: yum install tigervnc-server configure settings: vi /etc/sysconfig/vncservers e.g. VNCSERVERS="2:root 3:oracle 4:a...
Thursday, 19 January 2017

output columns of top command

›
Columns: PID     -> Process ID    USER    -> Process owner    PR      -> Priority of process  NI      -> Nice value of proc...
Wednesday, 18 January 2017

ORA-29885 solution

›
Error ORA-29885: domain index is defined on the column to be modified Solution Find problematic index; SQL> SELECT *   FROM dba_i...

How to calculate IP range?

›
e.g.  Address:     10.10.10.0/24             00001010 0 0001010 0 0001010 00000000 Netmask:     255.255.255.0              11111111 1...
Friday, 13 January 2017

An example of PL/SQL collection for nested table

›
DECLARE    TYPE employee IS TABLE OF VARCHAR (5);    employees   employee := employee ('A',  'B',  'C',  'D...

How to change table read-write mode?

›
Set read only mode: SQL> ALTER TABLE HR.EMPLOYEES READ ONLY ; Set read/write mode: SQL> ALTER TABLE HR.EMPLOYEES READ WRITE ; ...
Thursday, 12 January 2017

How to see load averages on linux?

›
$ top or  $ uptime e.g. load average: 0.35. 0.23, 0.25 First column; last one minute Second column; last five minutes Third column;...

How to kill inactive session for non-background oracle processes?

›
At first, check the sessions SQL> SELECT DISTINCT spid, b.username, osuser     FROM sys.dba_ddl_locks a, sys.v_$session B, v$process ...
Wednesday, 11 January 2017

How to learn linux distribution?

›
See all info $ lsb_release -a a - all See only distro info $ lsb_release -i -r i - id, r - release

How to define timeout setting for auto logout users in linux system?

›
Configure it # vi /etc/profile add following parameter at the end of the profile file: # this parameter runs as seconds and affects all...
Monday, 9 January 2017

How to configure display format of sqlplus ?

›
e.g. set linesize 200 set pagesize 100 column object_name  format a30 column object_type  format a106 -- optional column owner format ...
Friday, 6 January 2017

ORA-02020 Solution

›
Error ORA-02020 – Too many database links in use  Solution Current setting: SQL> show parameter open_links ; -- default is "4...

How to import/export ZOC profile, options and all settings?

›
e.g. Export/Import Copy "My Documents/ZOC7 Files" folder then import this folder to desired new path
Thursday, 5 January 2017

How to define redo log files?

›
e.g. check current redo log file select member from v$logfile; --redo log files add log group and its members SQL> ALTER DATABASE ...