justwired.blogspot.com
just wired: September 2012
http://justwired.blogspot.com/2012_09_01_archive.html
Sunday, September 16, 2012. I know it's been a while since I've posted on here (since I don't post on this blog anymore), but I thought I'd let the followers of this blog about the existence of the new blog I created a couple of weeks ago. The link is: http:/ hashtagpedro.blogspot.com/. Please follow me there, or subscribe to the RSS feed! Subscribe to: Posts (Atom). Verse of the day. Visitors to this page.
vivekag.wordpress.com
ORA-10635 error when shrinking a table | Just Oracle
https://vivekag.wordpress.com/2013/04/23/ora-10635-error-when-shrinking-a-table
When Things Go Wrong, Don't Go With Them. ORA-10635 error when shrinking a table. April 23, 2013 by vivekag. SQL alter table table name enable row movement;. SQL alter table table name shrink space compact;. Alter table table name shrink space compact. ERROR at line 1:. ORA-10635: Invalid segment or tablespace type. There are two possibilities:. A) The SHRINK clause is not valid on a compressed table. And you will get ORA-10635 . A) In case of a table being compressed table, can resolve issue like this:.
vivekag.wordpress.com
dbora.sh script to auto start/stop db on server reboot for password protected listener | Just Oracle
https://vivekag.wordpress.com/2013/02/13/dbora-sh-script-to-auto-startstop-db-on-server-reboot-for-password-protected-listener
When Things Go Wrong, Don't Go With Them. Dborash script to auto start/stop db on server reboot for password protected listener. February 13, 2013 by vivekag. ORA HOME=/oracle/app/oracle/product/10.2.0. Case “$1” in. F $ORA HOME/bin/dbstart -o! D $ORA HOME ]. Echo “Oracle startup : cannot start”. Su – $ORA OWNER -c $ORA HOME/bin/dbstart $ORA HOME. Su – $ORA OWNER. ORA HOME/bin/lsnrctl /tmp/yes$ .tmp. Su – $ORA OWNER. Set current listener TEST. Su – $ORA OWNER -c $ORA HOME/bin/dbshut $ORA HOME. Optimal Re...
vivekag.wordpress.com
Script to kill session inactive for more than 60 minutes | Just Oracle
https://vivekag.wordpress.com/2013/04/26/script-to-kill-session-inactive-for-more-than-60-minutes
When Things Go Wrong, Don't Go With Them. Script to kill session inactive for more than 60 minutes. April 26, 2013 by vivekag. Include below three lines in your shell scrip to kill the sessions which are inactive for more than 60 minutes. To kill # # # # # # # # # # # # # #. ORACLE HOME}/bin/sqlplus -s ‘/as sysdba’ @/ora/app/oracle/admin/scripts/ kill session script.sql. To kill # # # # # # # # # # # # #. Kill session script.sql. 8212; Script to kill sessions inactive for more than 1 hr. Set echo on;.
vivekag.wordpress.com
Just Oracle | When Things Go Wrong, Don't Go With Them | Page 2
https://vivekag.wordpress.com/page/2
When Things Go Wrong, Don't Go With Them. Recreate AWR repository in 10G and above. October 24, 2013 by vivekag. We can do the following to recreate awr. We can run the followings:. Sql alter system flush shared pool;. Can cheack more details in below oracle docs:. How to Recreate The AWR ( AUTOMATIC WORKLOAD ) Repository? Doc ID 782974.1). How to recreate AWR views in 10.2.0.1.0 to 10.2.0.3 (Doc ID 387610.1). 171; Newer Posts. Controlling Diagnostic and Tuning Pack Usage and Disabling AWR. On Solaris 10...
pedroinvietnam.blogspot.com
Pedro in Vietnam: New blog
http://pedroinvietnam.blogspot.com/2012/09/new-blog.html
Sunday, September 16, 2012. I know it's been a while since I've posted on here (since I don't post on this blog anymore), but I thought I'd let the followers of this blog about the existence of the new blog I created a couple of weeks ago. The link is: http:/ hashtagpedro.blogspot.com/. Please follow me there, or subscribe to the RSS feed! If you are reading this blog, please feel free to comment on my posts, pictures, etc. If anything, just say hi! Id love to hear from my readers! Join My Support Team!
justwired.blogspot.com
just wired: New blog
http://justwired.blogspot.com/2012/09/new-blog.html
Sunday, September 16, 2012. I know it's been a while since I've posted on here (since I don't post on this blog anymore), but I thought I'd let the followers of this blog about the existence of the new blog I created a couple of weeks ago. The link is: http:/ hashtagpedro.blogspot.com/. Please follow me there, or subscribe to the RSS feed! Subscribe to: Post Comments (Atom). Verse of the day. Visitors to this page.
vivekag.wordpress.com
Just Oracle
https://vivekag.wordpress.com/2013/10/24/419
When Things Go Wrong, Don't Go With Them. October 24, 2013 by vivekag. I suggest to use the following document from Oracle to convert Oracle database from Standard to Enterprise Edition. It is an in-place conversion and requires a short downtime Doc ID 117048.1. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Email (Address never made public). You are commenting using your WordPress.com account. ( Log Out. Notify me of new comments via email.
vivekag.wordpress.com
Controlling Diagnostic and Tuning Pack Usage and Disabling AWR | Just Oracle
https://vivekag.wordpress.com/2013/10/24/controlling-diagnostic-and-tuning-pack-usage-and-disabling-awr
When Things Go Wrong, Don't Go With Them. Controlling Diagnostic and Tuning Pack Usage and Disabling AWR. October 24, 2013 by vivekag. For Oracle 11g,by default diagnostic and tunning package, awr are enabled and use of this need seperate licence. We can disable them to save extra licence cost. we can set CONTROL MANAGEMENT PACK ACCESS initial parameter to NONE and Install the oracle package to disable Oracle AWR Package. Example AWR report for TEST db on HOST01 Is Oracle 11g,. 3830 11 Mar 2013 09:00 1.
