Filling in the blanks for the post_v11_upgrade_11gr2.sql script
Last Updated September 07, 2011
The upgrade instructions provided in the Symantec DLP Oracle 11g Installation and Upgrade Guide discuss running a post-installation script called "post_v11_upgrade_11gr2.sql", but doesn't provide much instruction as to what is needed.
The post_v11_upgrade_11gr2.sql script is run from sqlplus logged in as sys as sysdba. Because it is referenced at the beginning of a section, then actually called 10 steps later without guidance, it can be rather confusing as to what this thing is doing:
First, from the commandline, make sure that you have navigated to the directory that contains post_v11_upgrade_11gr2.sql. Usually it is something like this:
> cd c:\Vontu\Protect\install\sql
If you try to do some form of fancy "running the script from another directory", you will get:
SP2-0310: unable to open file "Fix_KeywordCondition.sql"
... which means the Fix Keyword Condition script could be found. Just take the time to go to the directory and run it from there.
Next, the prompts are a little deceiving. Typically, you are asked for a username/password pair. In this case, you are prompted for a password first; the script already knows the username (sys). Once again, no fancy second guessing what is being requested. Just type in the following:
1) password for sys
2) the SID for the database. This is the "database name". Typically, protect.
3) Then a username and password pair. When it requests "Please enter DB username" it is really saying "the owner of the DLP database; the Oracle account that DLP uses to connect to the database". For those in the know: the DLP schema owner. Typically.... protect
4) When it requests "Please enter a password for DB username", it's simply looking for the passwords associated with the username.
And that's it.
Imported Document ID: TECH219414
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe