皆の日本語

MID_TIER_ORACLE_HOME/portal/admin/plsql/wwc/provsyns.sql

1. Change to the directory containing the provsyns.sql script:
   

   Windows: cd <MID_TIER_ORACLE_HOME>\portal\admin\plsql\wwc
   Linux/Unix: cd <MID_TIER_ORACLE_HOME>/portal/admin/plsql/wwc
   
   

2. Log in to SQL*Plus as the portal schema owner. For example:
   

   sqlplus portal/oracle1
   
   

   You must run provsyns.sql as the portal schema owner. By default the portal schema is called PORTAL. An administrator can use Oracle Internet Directory to obtain the portal schema password as follows:
   
   1. Navigate to:
      
      • Entry Management
      • cn=OracleContext
      • cn=Products
      • cn=IAS
      • cn=Infrastructure Databases
      • OrclReferenceName=Infrastructure Database (for example, iasdb.server.domain.com)
      • OrclResourceName=Schema Name (for example, PORTAL)
   2. Click this entry.
   3. Look for the orclpasswordattribute value in the right panel. This is the schema password.
3. Run the provsyns.sql script:
   

   SQL>@provsyns.sql <schema>

   (nếu ko chạy thì nhập vào đường dẫn tuyệt đối. VD 

   @C:\Oracle\portal\portal\admin\plsql\wwc\provsyns.sql diem)
   
   

   Where schema is the name of the schema to which you want to grant access.
   
   ref: http://docs.oracle.com/cd/B32110_01/portal.1013/b28978/pdg_pdk_plsql.htm#CHDFDCCJ