ORA-01244 on Physical Standby September 14, 2009
Posted by Tyo in Oracle.add a comment
Error Message: ORA-01244
and below are steps to resolve the problem.
First thing to do query v$datafile to check the unnamed datafile with this query:
select name from v$datafile; (lagi…)
A Day with Solaris 10 Desember 4, 2008
Posted by Tyo in Uncategorized.1 comment so far
Installing Oracle 10g on many operating system has been my regular jobs for this 2 month. Most of this jobs using Solaris 10 as their operating system. Usually when doing installation, i have a backup from solaris people from many other vendors or their principal to do the setting for solaris 10. I just sit back and relax and watch them do the setting shmmax. It really enjoyable though 
.
Changing Hostname on Linux Oktober 21, 2008
Posted by Tyo in Linux.Tags: change linux hostname, hostname, Linux
1 comment so far
This post is only a reminder for me on “how to change Hostname in Linux”. Since I play a lot with VMWARE, and I already have the Linux OS template, so i don’t have to do linux installation all the time whenever i need to do new Oracle installation, just change the hostname and ip address and those Linux OS template is ready to use.
My Oracle Script Collection Februari 15, 2008
Posted by Tyo in Oracle.add a comment
1. Moving all tables in a schema
select ‘alter table ‘|| table_name || ‘ move tablespace users’ from user_tables;
2. Moving all indexes in a schema
select ‘ALTER INDEX ‘ ||Index_name || ‘ REBUILD TABLESPACE INDX’ from user_indexes;
3. Check Tablespaces size in a database
SELECT df.tablespace_name TABLESPACE, df.total_space TOTAL_SPACE,
fs.free_space FREE_SPACE, df.total_space_mb TOTAL_SPACE_MB,
(lagi…)
Recreate Temp Tablespace Januari 3, 2008
Posted by Tyo in Oracle.1 comment so far
Below is step for recreating Oracle temp Tablespace.
== Step 1 Create Temporary Tablespace Temp
CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE
‘/u01/app/oradata/temp01′ SIZE 10240M AUTOEXTEND OFF,
(lagi…)
