solaris上已经安装了Oracle

Solaris上已经安装了Oracle，版本10.2.0.1供大家学习和使用。

 

开通了3个service分别是

 

crmdb，

用户名 crm/crm

 

salesdb，

用户名  sales/sales

 

soldb

用户名  scott/tiger

 

数据库端口31521

 

这个数据库的表空间比较小，各只有400M，仅供学习使用

 

salesdb = 
   (DESCRIPTION = 
     (ADDRESS_LIST = 
       (ADDRESS = 
         (PROTOCOL = TCP)
         (HOST = tech.inthirties.com)
         (PORT = 31521)
       )
     )
     (CONNECT_DATA = 
       (SERVICE_NAME = salesdb)
     )
   )
 )

 crmdb = 
   (DESCRIPTION = 
     (ADDRESS_LIST = 
       (ADDRESS = 
         (PROTOCOL = TCP)
         (HOST = tech.inthirties.com)
         (PORT = 31521)
       )
     )
     (CONNECT_DATA = 
       (SERVICE_NAME = crmdb)
     )
   )
 )

 soldb = 
   (DESCRIPTION = 
     (ADDRESS_LIST = 
       (ADDRESS = 
         (PROTOCOL = TCP)
         (HOST = tech.inthirties.com)
         (PORT = 31521)
       )
     )
     (CONNECT_DATA = 
       (SERVICE_NAME = soldb)
     )
   )
 )