copy initefa.ora & newsidefa.sql from another db server /opt/oracle/ora817/dbs to currenct db server /opt/oracle/ora817/dbs copy listener.ora & tnsnames.ora from another db server /opt/oracle/ora817/network/admin to current db server /opt/oracle/ora817/network/admin[@more@].copy initefa.ora & newsidefa.sql from another db server /opt/oracle/ora817/dbs to currenct db server /opt/oracle/ora817/dbs copy listener.ora & tnsnames.ora from another db server /opt/oracle/ora817/network/admin to current db server /opt/oracle/ora817/network/admin 2.make directory which mentioned in initefa.ora & newsidefa.sql(do not need to make the file ,just make the directory) for initefa.ora mkdir -p /oradata/oradata1/efa/ctl mkdir -p /oradata/oradata2/efa/ctl mkdir -p /oradata/oradata3/efa/ctl mkdir -p /oradata/oradata4/efa/udump mkdir -p /oradata/oradata4/efa/cdump mkdir -p /oradata/oradata4/efa/bdump mkdir -p /oradata/oradata4/efa/archive for newsidefa.sql mkdir -p /oradata/oradata1/efa/redo mkdir -p /oradata/oradata2/efa/redo mkdir -p /oradata/oradata3/efa/redo mkdir -p /oradata/oradata1/efa/sys for tablespace mkdir -p /oradata/oradata3/efa/indx mkdir -p /oradata/oradata2/efa/users mkdir -p /oradata/oradata1/efa/rbs mkdir -p /oradata/oradata1/efa/temp mkdir -p /oradata/oradata1/efa/tools 3.su - oracle export ORACLE_SID=efa svrmgrl connect internal; startup nomount; spool oradataowenefa.log @ /opt/oracle/ora817/dbs/newsidefa.sql spool off 4.create users p6sfcfa,coa_user and so on create roles pd_user,r_pps and so on create tablespace (copy the sql from production db ) create rollback segment (copy the sql from production db) notes:user's tablespace default 5.exp sfcfa/111111@p5fa file=d:p5fa.dmp log=d:p5fa.log compress=no owner=sfcfa imp sfcfa/111111@fa330 file=d:p5fa.dmp log=d:p5fa.log full=y or " imp username/password file=xxx.dmp full=y ignore=y commit=y log=imp.log"