PL/Plus本地連線oracle配置

記錄一下這個本地的配置

tnsnames.ora

#Amor-PC

myTableSpace =  
(DESCRIPTION =    
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))    
(CONNECT_DATA =      
(SERVER = DEDICATED)      
(SERVICE_NAME = orcl)    
)  
)



# 這個主要用於呼叫外部過程。如使用全文檢索時就需要設定EXTPROC_CONNECTION_DATA
EXTPROC_CONNECTION_DATA =  
(DESCRIPTION =    
(ADDRESS_LIST =    
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))    
)    
(CONNECT_DATA =      
(SID = PLSExtProc)      
(PRESENTATION = RO) 
)  

)

listener.ora

LISTENER1 =  
(DESCRIPTION =    
(ADDRESS = 
(PROTOCOL = TCP)
(HOST = 127.0.0.1)
(PORT = 1521)
)  
)