Hi Rajkumar,

PFA file containing details steps of installation of PRPC with Tomcat server and DB scripts as well.

Step 1: Create the user and schema

    create tablespace PRPC716 logging datafile 'E:\app\hasam\oradata\PRPCDB\PRPC716.dbf' size 50M autoextend on next 1280K maxsize unlimited extent management local segment space management auto;
    create user PRPC716 identified by PRPC716 default tablespace PRPC716 quota unlimited on PRPC716; 
    GRANT CONNECT,RESOURCE TO PRPC716;
    GRANT Create view to PRPC716;

    GRANT CREATE PUBLIC SYNONYM TO PRPC716 ;
    GRANT DROP PUBLIC SYNONYM TO PRPC716 ;
    GRANT CREATE SYNONYM TO PRPC716 ;
    GRANT CREATE SEQUENCE TO PRPC716 ;
    GRANT CREATE PROCEDURE TO PRPC716 ;
    GRANT CREATE SESSION TO PRPC716 ;
    GRANT CREATE TABLE TO PRPC716 ;
    GRANT CREATE ANY TRIGGER TO PRPC716 ;
    GRANT EXECUTE ANY PROCEDURE TO PRPC716 ;
    GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR to PRPC716;
    

Step 2: Run the wizard 
    java -jar PRPC_Setup.jar
    
    Write your driver name. For ex:- oracle.jdbc.OracleDriver
    File where ojdbc jar is stored. For ex:- C:\<YourFolderName>\product\11.2.0\dbhome_1\jdbc\lib\ojdbc6.jar
    jdbc:oracle:thin:@//localhost:1521/prpc

    Enter schema name, username and password. As we have created schema with username/password is PRPC716     You can enter PRPC716 in remaining fields
    Finish the wizard without any changes
    
Step 3: Application server configuration
    -       Open C:\<YourFolderName>\tomcats\apache-tomcat-ML716\bin\setEnv.bat
            set JAVA_OPTS=-Xms768m -Xmx768m -XX:PermSize=64m -XX:MaxPermSize=256m -

Djava.awt.headless=true
    -     Go to server.xml
            <Connector enableLookups="true"/> enable it
         Note : Dont do this step as we face some issue during server startups
 

   -    Go to context.xml
            <Manager pathname="" /> uncomment it
        Error: Jul 19, 2013 2:37:46 PM org.apache.catalina.session.StandardManager doLoad SEVERE:
            ClassNotFoundException while loading persisted sessions:
            java.lang.ClassNotFoundExceptioncom.pega.pegarules.session.internal.authorization.ContextMap
            DiagCallback
            java.lang.ClassNotFoundException:
            com.pega.pegarules.session.internal.authorization.ContextMapDiagCallback

    -    Add JDBC Resource,
        <Resource name="jdbc/PegaRULES"
                type="javax.sql.DataSource"
                username="PRPC716"
                password="PRPC716"
            driverClassName="oracle.jdbc.OracleDriver"
                maxIdle="2"
                maxWait="5000"
                url="jdbc:oracle:thin:@localhost:1521:PRPC"
                maxActive="20"
                connectionProperties="oracle.jdbc.V8Compatible=true;"/>

    -    Add temp directory,
            <Environment name="url/initialization/explicittempdir" value="C:/Installation/tomcats/apache-tomcat-ML716/temp" type="java.lang.String" />

    -    Configure roles in tomcat-users.xml file
            <role rolename="admin-gui"/>
            <role rolename="manager-gui"/>
            <role rolename="PegaDiagnosticUser"/>
            <user username="admin" password="admin" roles="admin-gui,manager-gui,PegaDiagnosticUser"/>
    -    Note down tomcat port in server.xml,
            <Connector port="8089" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8444" />
    -    Deploy the prweb.war file into tomcat instance using its manager apps
    -    Stop the tomcat server and delete the prweb.war file in webapps folder
    
Step 4: Login into the application
    http://localhost:8089/prweb/PRServlet/
    [email protected] install
    
Step 5: Post installation steps
    -    In designer studio, System > Settings > URLs
        http://localhost:8089/prhelp
        http://localhost:8089/prsysmgmt
        
Kindly notify, if it helps.

Regards,

Asif