24.11.2010
Ferhat Sengonul Podcast
I wanted to share with you this nice to podcast.
http://streaming.oracle.com/ebn/podcasts/media/9547030_Turkcell_111810.mp3
http://ferhatsengonul.wordpress.com/
Grid Clusterware-Diagnostics Collection Script
This script is located u01/app/11.2.0/grid(Grid_Home)/bin/diagcollection.pl
Connect root user then run above mention script.
When invoked script
•crsData_hostname_date.tar.gz contains log files
•coreData_host_name_date.tar.gz contains core files
•ocrData_hostname_date.tar.gz files contains ocrdump and ocrcheck also show OCR backups.
•osData_hostname_date.tar.gz contains operating system logs
You can use scripts -collect option. If you want to clean local directory use -clean option
/u01/app/11.2.0/grid/bin/diagcollection.pl --collect
22.11.2010
SCAN - SINGLE CLIENT ACCESS NAME
srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521
srvctl config scan
SCAN name: yeni-scan, Network: 1/192.168.1.0/255.255.255.0/
SCAN VIP name: scan1, IP: /yeni-scan.oracle.com/192.168.1.190
SCAN VIP name: scan2, IP: /yeni-scan.oracle.com/192.168.1.191
SCAN VIP name: scan3, IP: /yeni-scan.oracle.com/192.168.1.192
kurulum sırasında remote_listener parametresi yeni-scan.oracle.com:1521 olarak ayarlanır.
SCAn kullanmıs bir TNSNAMES.ora dosyası
orcl =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=yeni-scan.oracle.com)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=orcl))
)
Eski yontemle scan kullanmamıs bir tnsnames.ora dosyası örnegi
orcl =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=yeni1-vip.oracle.com)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=yeni2-vip.oracle.com)(PORT=1521))
)
(CONNECT_DATA=(SERVICE_NAME=orcl)))
)
)
2.11.2010
Vakit Tamam,TROUG Avrupa'nın en buyugu olmak için yola çıkıyor

4 November Oracle Day-My Presentation Subjects
1.11.2010
ORA-12838: cannot read/modify an object after modifying it in parallel
SQL> ALTER SESSION FORCE PARALLEL DML PARALLEL 4;
Session altered.
SQL> DELETE sh.customers1 WHERE cust_id>10000;
32000 rows deleted.
SQL> select * from sh.customers1;
select * from sh.customers1
* ERROR at line 1:
ORA-12838: cannot read/modify an object after modifying it in parallel
If you modified has table in parallel, then s query the content of that table you get an ORA-12838 error message.
How to solve?
SQL> ALTER SESSION FORCE PARALLEL DML PARALLEL 4;
Session altered.
SQL> DELETE sh.customers1 WHERE cust_id>10000;
32000 rows deleted.
SQL> commit or rollback
then
SQL> select * from sh.customers1;