Monday, January 14, 2013

Listener make , create batch file and export dmp

Path:C:\oraclexe\app\oracle\product\0.2.0\server\NETWORK\ADMIN   
Then you will be show tnsnames icon.Now  R.B click on tnsnamesicon->edit then paste under text that means make listener.





XEKanizWish = 
 (DESCRIPTION = 
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.ip)(PORT = 1521)
   (
    CONNECT_DATA = 
      (SERVICE = DEDICATED)
      (SERVICE_NAME = orcl)
   )
)




N.B: Here XEKanizWish  is as my wish type text 
N.B: (HOST = 192.168.0.ip) is related 7th Line  (SERVICE_NAME = orcl)

N.B: (HOST = 192.168.0.mypcip) is related 7th Line  (SERVICE_NAME = xe)
     // Here SERVICE_NAME = xe because my pc database is setup orclxe version




*/Now On desktop I will open notepad and type the following text to make batch file:
  exp userid=BANBEIS/BANBEIS@XEKanizWish file=G:\kbanbeiswishname2ndphase.dmp
  N.B: Here BANBEIS/BANBEIS IS USERID/PASSWORD From cfg file
*/Now save this note pad according to Listener name that means XEKanizWish.bat

N.B: G:\kbanbeiswishname2ndphase.dmp is my wish location
*/ Now double click on this batch file and I would get dmp file required location that means (G:\kbanbeiswishname2ndphase.dmp)



Picture 1:batch file:






Picture 1:dmp file:(when I click on batch file then create dmp file)
                                                                                                         
                                                             



###########################################################

So Final : 3 step :
Step 1: Listener make 
XEKanizWish = 
 (DESCRIPTION = 
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.ip)(PORT = 1521)
   (
    CONNECT_DATA = 
      (SERVICE = DEDICATED)
      (SERVICE_NAME = orcl)
   )
)

Step 2: Create Batch file
 exp userid=BANBEIS/BANBEIS@XEKanizWish file=G:\kbanbeiswishname2ndphase.dmp




Step 3: Double click on batch file to get dmp file




#################################################
#################################################
Now carry this dmp file for my home pc then create user name and password create and import dmp using drag and drop system :

run-> sqlplus then Enter


sys/sys as sysdba enter
SQL> create user banbeis identified by banbeis;enter
if it is user created then type
sql> grant dba to banbeis;
if grant success then import dmp
SQL> $imp enter
Username:banbeis/banbeis enter

// Now put dmp on desktop AND  drag and drop system follow

No
No
No
.....
.....

Last Yes

N.B: Now use this banbeis as userename and password in my local pc project in cfg file  that contain kbanbeiswishname2ndphase.dmp
#################################################
#################################################
AS image show :


                                  


                  


No comments:

Post a Comment