NAME
ldd - print shared library dependencies
ldd `which svn`
reference
http://old.nabble.com/svn-error,-cannot-find-libsvn_client-1.so.0-td23407998.html
Wednesday, November 30, 2011
svn
--subversion is a tool for version control
svn --version #check version
svn help # find help for command
svn checkout (co)
svn update (up)
svn --version #check version
svn help
svn checkout (co)
svn update (up)
change password with harsh value in oracle 11g
1. get ddl to recreate the user.
select dbms_metadata.get_ddl('USER','COSKAN') from dual;
Attn: set long 200 if you read in sqlplus
example of results:
DBMS_METADATA.GET_DDL('USER','COSKAN') ------------------------------------------------------------------------------------------------------------------------------------
CREATE USER "COSKAN" IDENTIFIED BY
VALUES 'S:1F0648E7E665F0A0EE44B1E9BD4B626A77CA25B376A49177F9E97DF98BFA;26EB15F771A78542'
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
2. check hash value from sys.user$
select password, spare4 from sys.user$ where name = 'COSKAN';
alter system set sec_case_sensitive_logon=true;
S:1F0648E7E665F0A0EE44B1E9BD4B626A77CA25B376A49177F9E97DF98BFA -- for sensitive
26EB15F771A78542 -- for non-sensitive
if set up only non-sensitive, sec_case_sensitive_logon=true will not work.
3. change password
alter user "COSKAN" IDENTIFIED BY
VALUES 'S:1F0648E7E665F0A0EE44B1E9BD4B626A77CA25B376A49177F9E97DF98BFA;26EB15F771A78542';
4. practical use
if you need extend an expired account, the only way I know is to change user to default profile and reset password with harsh value (if you don't know what it is)
then change back to previous profile.
reference:
http://riaschissl.blogspot.com/2010/07/oracle-unexpire-and-unlock-accounts.html
http://coskan.wordpress.com/2009/03/11/alter-user-identified-by-values-on-11g-without-using-sysuser/
select dbms_metadata.get_ddl('USER','COSKAN') from dual;
Attn: set long 200 if you read in sqlplus
example of results:
DBMS_METADATA.GET_DDL('USER','COSKAN') ------------------------------------------------------------------------------------------------------------------------------------
CREATE USER "COSKAN" IDENTIFIED BY
VALUES 'S:1F0648E7E665F0A0EE44B1E9BD4B626A77CA25B376A49177F9E97DF98BFA;26EB15F771A78542'
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
2. check hash value from sys.user$
select password, spare4 from sys.user$ where name = 'COSKAN';
alter system set sec_case_sensitive_logon=true;
S:1F0648E7E665F0A0EE44B1E9BD4B626A77CA25B376A49177F9E97DF98BFA -- for sensitive
26EB15F771A78542 -- for non-sensitive
if set up only non-sensitive, sec_case_sensitive_logon=true will not work.
3. change password
alter user "COSKAN" IDENTIFIED BY
VALUES 'S:1F0648E7E665F0A0EE44B1E9BD4B626A77CA25B376A49177F9E97DF98BFA;26EB15F771A78542';
4. practical use
if you need extend an expired account, the only way I know is to change user to default profile and reset password with harsh value (if you don't know what it is)
then change back to previous profile.
reference:
http://riaschissl.blogspot.com/2010/07/oracle-unexpire-and-unlock-accounts.html
http://coskan.wordpress.com/2009/03/11/alter-user-identified-by-values-on-11g-without-using-sysuser/
ps
SYNOPSIS
ps [options]
DESCRIPTION
ps displays information about a selection of the active processes. If you want a repetitive update of the
selection and the displayed information, use top(1) instead.
This version of ps accepts several kinds of options:
1 UNIX options, which may be grouped and must be preceded by a dash.
2 BSD options, which may be grouped and must not be used with a dash.
3 GNU long options, which are preceded by two dashes.
Options of different types may be freely mixed, but conflicts can appear. There are some synonymous options, which
are functionally identical, due to the many standards and ps implementations that this ps is compatible with.
Note that "ps -aux" is distinct from "ps aux". The POSIX and UNIX standards require that "ps -aux" print all
processes owned by a user named "x", as well as printing all processes that would be selected by the -a option. If
the user named "x" does not exist, this ps may interpret the command as "ps aux" instead and print a warning. This
behavior is intended to aid in transitioning old scripts and habits. It is fragile, subject to change, and thus
should not be relied upon.
By default, ps selects all processes with the same effective user ID (euid=EUID) as the current user and
associated with the same terminal as the invoker. It displays the process ID (pid=PID), the terminal associated
with the process (tname=TTY), the cumulated CPU time in [dd-]hh:mm:ss format (time=TIME), and the executable name
(ucmd=CMD). Output is unsorted by default.
The use of BSD-style options will add process state (stat=STAT) to the default display and show the command args
(args=COMMAND) instead of the executable name. You can override this with the PS_FORMAT environment variable. The
use of BSD-style options will also change the process selection to include processes on other terminals (TTYs)
that are owned by you; alternately, this may be described as setting the selection to be the set of all processes
filtered to exclude processes owned by other users or not on a terminal. These effects are not considered when
options are described as being "identical" below, so -M will be considered identical to Z and so on.
Except as described below, process selection options are additive. The default selection is discarded, and then
the selected processes are added to the set of processes to be displayed. A process will thus be shown if it meets
any of the given selection criteria.
EXAMPLES
To see every process on the system using standard syntax:
ps -e
ps -ef
ps -eF
ps -ely
To see every process on the system using BSD syntax:
ps ax
ps axu
To print a process tree:
ps -ejH
ps axjf
To get info about threads:
ps -eLf
ps axms
To get security info:
ps -eo euser,ruser,suser,fuser,f,comm,label
ps axZ
ps -eM
To see every process running as root (real & effective ID) in user format:
ps -U root -u root u
To see every process with a user-defined format:
ps -eo pid,tid,class,rtprio,ni,pri,psr,pcpu,stat,wchan:14,comm
ps axo stat,euid,ruid,tty,tpgid,sess,pgrp,ppid,pid,pcpu,comm
ps -eopid,tt,user,fname,tmout,f,wchan
Print only the process IDs of syslogd:
ps -C syslogd -o pid=
Print only the name of PID 42:
ps -p 42 -o comm=
ps [options]
DESCRIPTION
ps displays information about a selection of the active processes. If you want a repetitive update of the
selection and the displayed information, use top(1) instead.
This version of ps accepts several kinds of options:
1 UNIX options, which may be grouped and must be preceded by a dash.
2 BSD options, which may be grouped and must not be used with a dash.
3 GNU long options, which are preceded by two dashes.
Options of different types may be freely mixed, but conflicts can appear. There are some synonymous options, which
are functionally identical, due to the many standards and ps implementations that this ps is compatible with.
Note that "ps -aux" is distinct from "ps aux". The POSIX and UNIX standards require that "ps -aux" print all
processes owned by a user named "x", as well as printing all processes that would be selected by the -a option. If
the user named "x" does not exist, this ps may interpret the command as "ps aux" instead and print a warning. This
behavior is intended to aid in transitioning old scripts and habits. It is fragile, subject to change, and thus
should not be relied upon.
By default, ps selects all processes with the same effective user ID (euid=EUID) as the current user and
associated with the same terminal as the invoker. It displays the process ID (pid=PID), the terminal associated
with the process (tname=TTY), the cumulated CPU time in [dd-]hh:mm:ss format (time=TIME), and the executable name
(ucmd=CMD). Output is unsorted by default.
The use of BSD-style options will add process state (stat=STAT) to the default display and show the command args
(args=COMMAND) instead of the executable name. You can override this with the PS_FORMAT environment variable. The
use of BSD-style options will also change the process selection to include processes on other terminals (TTYs)
that are owned by you; alternately, this may be described as setting the selection to be the set of all processes
filtered to exclude processes owned by other users or not on a terminal. These effects are not considered when
options are described as being "identical" below, so -M will be considered identical to Z and so on.
Except as described below, process selection options are additive. The default selection is discarded, and then
the selected processes are added to the set of processes to be displayed. A process will thus be shown if it meets
any of the given selection criteria.
EXAMPLES
To see every process on the system using standard syntax:
ps -e
ps -ef
ps -eF
ps -ely
To see every process on the system using BSD syntax:
ps ax
ps axu
To print a process tree:
ps -ejH
ps axjf
To get info about threads:
ps -eLf
ps axms
To get security info:
ps -eo euser,ruser,suser,fuser,f,comm,label
ps axZ
ps -eM
To see every process running as root (real & effective ID) in user format:
ps -U root -u root u
To see every process with a user-defined format:
ps -eo pid,tid,class,rtprio,ni,pri,psr,pcpu,stat,wchan:14,comm
ps axo stat,euid,ruid,tty,tpgid,sess,pgrp,ppid,pid,pcpu,comm
ps -eopid,tt,user,fname,tmout,f,wchan
Print only the process IDs of syslogd:
ps -C syslogd -o pid=
Print only the name of PID 42:
ps -p 42 -o comm=
nslookup
nslookup 192.168.1.2
nslookup name.col.com
Non-interactive mode is used when the name or Internet address of the host to be looked up is given as the first
argument. The optional second argument specifies the host name or address of a name server.
nslookup name.col.com
Non-interactive mode is used when the name or Internet address of the host to be looked up is given as the first
argument. The optional second argument specifies the host name or address of a name server.
refresh materialized view in oracle
1. procedure to execute
REFRESH Procedures
This procedure refreshes a list of materialized views.
Syntax
DBMS_MVIEW.REFRESH (
{ list IN VARCHAR2,
| tab IN DBMS_UTILITY.UNCL_ARRAY,}
method IN VARCHAR2 := NULL,
rollback_seg IN VARCHAR2 := NULL,
push_deferred_rpc IN BOOLEAN := true,
refresh_after_errors IN BOOLEAN := false,
purge_option IN BINARY_INTEGER := 1,
parallelism IN BINARY_INTEGER := 0,
heap_size IN BINARY_INTEGER := 0,
atomic_refresh IN BOOLEAN := true,
nested IN BOOLEAN := false);
exec dbms_mview.refresh('schema_owner.mview_name,schema_owner.mview_name1')
exec dbms_mview.refresh('schema_owner.mview_name', atomic_refresh=> fails)
2. refresh methods
a. fast refresh as f
b. complete refresh as c
c. default value can be force ( which try fast if possible otherwise us complete)
3. atomic_refresh parameter.
when you do complete refresh, oracle trancate table and insert /* append */ if atomic_refresh was set false). Oracle will delete and insert if atomic_refresh was set true (which is the default value).
for quick refreseh set atomic_refresh to false.
for data availability , user default value.
reference:
http://askdba.org/weblog/2009/07/mview-complete-refresh-and-atomic_refresh-parameter/
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::p11_question_id:15695764787749
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_mview.htm#i997194
REFRESH Procedures
This procedure refreshes a list of materialized views.
Syntax
DBMS_MVIEW.REFRESH (
{ list IN VARCHAR2,
| tab IN DBMS_UTILITY.UNCL_ARRAY,}
method IN VARCHAR2 := NULL,
rollback_seg IN VARCHAR2 := NULL,
push_deferred_rpc IN BOOLEAN := true,
refresh_after_errors IN BOOLEAN := false,
purge_option IN BINARY_INTEGER := 1,
parallelism IN BINARY_INTEGER := 0,
heap_size IN BINARY_INTEGER := 0,
atomic_refresh IN BOOLEAN := true,
nested IN BOOLEAN := false);
exec dbms_mview.refresh('schema_owner.mview_name,schema_owner.mview_name1')
exec dbms_mview.refresh('schema_owner.mview_name', atomic_refresh=> fails)
2. refresh methods
a. fast refresh as f
b. complete refresh as c
c. default value can be force ( which try fast if possible otherwise us complete)
3. atomic_refresh parameter.
when you do complete refresh, oracle trancate table and insert /* append */ if atomic_refresh was set false). Oracle will delete and insert if atomic_refresh was set true (which is the default value).
for quick refreseh set atomic_refresh to false.
for data availability , user default value.
reference:
http://askdba.org/weblog/2009/07/mview-complete-refresh-and-atomic_refresh-parameter/
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::p11_question_id:15695764787749
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_mview.htm#i997194
Wednesday, November 16, 2011
oracleasm
oracleasm configure --display current configuration
oracleasm configure -i --change current configuration
oracleasm createdisk diskname /dev/sdb1
oracleasm init --load asm lib driver
oracleasm status -- check asm lib driver status.
oracleasm configure -i --change current configuration
oracleasm createdisk diskname /dev/sdb1
oracleasm init --load asm lib driver
oracleasm status -- check asm lib driver status.
Subscribe to:
Posts (Atom)