tips and tricks, examples,code snippet and links about Java, JavaScript, jquery, css, html, unix/linux, oracle, mysql, php and web designs that related to my interest
Monday, February 14, 2011
Yii how to pass parameters from the action to the view.
reference: http://www.jnieto.org/article/passing_parameters_from_the_action_to_the_view_symfony_vs_yii
Tuesday, February 8, 2011
Some Oracle commands
1.set the oracle xmltoollite instance (windows cmd)
e.g. set ORACLE_SID
>set ORACLE_SID=xmltoollite
2.login to sqplus as dba in xmltoollite instance
>sqlplus sys/mypassword as sysdba
3.stop db : force shutdown
e.g. shutdown
SQL>shutdown immediate
4. start db
SQL>startup
5.logout from sqlplus
SQL>quit
check connectivity (windows cmd)
--------------------------------
e.g. tnsping
>tnsping XMLTOOL_
listener (windows cmd)
---------------------
e.g. lsnrctl
1. see services attached to this listener
>lsnrctl services LISTENER
2. see status of services attached to this listener
>lsnrctl status LISTENER
3. start the listener
>lsnrctl start LISTENER
4.stop the listener
>lsnrctl stop LISTENER
how to setup multiple listeners
-------------------------------
http://blogs.sun.com/rtsai/entry/how_to_configure_multiple_oracle
e.g. set ORACLE_SID
>set ORACLE_SID=xmltoollite
2.login to sqplus as dba in xmltoollite instance
>sqlplus sys/mypassword as sysdba
3.stop db : force shutdown
e.g. shutdown
SQL>shutdown immediate
4. start db
SQL>startup
5.logout from sqlplus
SQL>quit
check connectivity (windows cmd)
--------------------------------
e.g. tnsping
>tnsping XMLTOOL_
listener (windows cmd)
---------------------
e.g. lsnrctl
1. see services attached to this listener
>lsnrctl services LISTENER
2. see status of services attached to this listener
>lsnrctl status LISTENER
3. start the listener
>lsnrctl start LISTENER
4.stop the listener
>lsnrctl stop LISTENER
how to setup multiple listeners
-------------------------------
http://blogs.sun.com/rtsai/entry/how_to_configure_multiple_oracle