Easy way to clone a ORACLE db

Refer to

http://www.dba-oracle.com/oracle_tips_db_copy.htm 

and

http://dbaforums.org/oracle/index.php?showtopic=2917

if you want to clone a database TEST -> DENEME 
1 take a backup of your controlfile 
2 take online / offline backup of all your datafiles 
3 make a relevant copy of your init.ora file or make changes to you are deneme initora
4 delete your control file, redo logs and datafiles on DENEME
5 move these files from TEST -> DENEME
6 using the back up of control file create the new control file for deneme 
NOTE the database name needs to be changed from TEST -> DENEME with the 
SET Clause and option resetlogs (depending on hot /cold backup)
7 create the redo log files 
8 startup mount 
9 recover the log files until cancel
10 open database

create initXXX.ora from spfile

SQL> create pfile='initFDCESW.ora' from spfile='spfilefdcesw.ora';

cp : 0653-447 Requested a write of 4096 bytes, but wrote only 3584.

cp : 0653-447 Requested a write of 4096 bytes, but wrote only 3584.

# ulimit -f unlimited

# ulimit -d unlimited

Import file: expdat.dmp >

exit from Import file: expdat.dmp >
 ctrl -D

UNIX Command

more -p G filename  

go to the end of file

du- sk

check file size

df -G

show disk usage

vi

10yy and p copy 10 lines and paste

ftp

ftp ipaddress

cd , ls or dir

get xxxx
put xxxx


ls -al | tee a.txt

Tar

tar -xvf xxxxx.tar

In

In -s xxxxx.so.6.0.1 xxxxxx.so

uname -a

Show the os information


Vi

Search and Replace

:%s/aaa/bbb/g

replace all aaa with bbb

Can't log in as sysdba

$ sqlplus / as sysdba
not working.

Solution: set the oracle_home and oracle_sid correctly.

ORA-28547

ORA-28547: connection to server failed, probable Oracle Net admin error

Check tnsping <target_database>, OK
Check tnsname.ora, OK
Check lsnrctl status, OK
Check sqlnet.ora, OK

Finally, solution from Miss Jennifer:Oracle only allows 8 characters for the database file location.(needs to be confirmed)