Oracle WebDB Installation Guide Release 2.2 A77053-01 |
|
This chapter contains the following sections:
Oracle WebDB provides upgrade scripts that allow you to migrate from Oracle WebDB version 2.1 to Oracle WebDB 2.2.
IMPORTANT: Before performing a WebDB migration, ensure that you have your ORACLE_HOME environment variable configured to point to your Oracle database. |
Before performing a WebDB or site migration, you must upgrade your Oracle Web Application (OWA) from version 4.0.7 to 4.0.8.
Complete the following steps to do this:
owaload.sql
using the following syntax:
<userid> <tablespace> <temp_tablespace> <log_file> <userid_password>
where
Once owaload.sql
is run as directed, OWA is upgraded to version 4.0.8.
These scripts apply to the WebDB 2.1 product installed on your Windows NT or Solaris machine.
To migrate Oracle WebDB version 2.1 to version 2.2:
/upgrade/webdb/21-22
directory.
/upgrade/webdb/21-22
directory, execute the upgrade script with the appropriate command:
Note: With the exception of the connect string (TNS names alias), all are required parameters when running the command. |
Windows NT
upgrad22.cmd <sys_password> <user> <password> <db_o8> <connect_string> <logfile>
Solaris
upgrad22.csh <sys_password> <user> <password> <db_o8> <connect_string> <logfile>
where:
WebDB 2.2 provides scripts that you can use to migrate the Site Building packages included in Oracle WebDB 2.1 to version 2.2.
You can run the scripts from the SQL*Plus command prompt.
Important:
|
To run the migration scripts from the SQL*Plus prompt:
/upgrade/sites/21-22
directory.
upgrd220.sql
using the following syntax:
SQL> @upgrd220.sql [site schema] [site admin] [default tablespace] [temporary tablespace] [site language] [site schema password@DB connectstring]
[log file name]
where:
sqlldr userid=<site_schema>/<password> control=wwvsbus.ctl log=<dir>wwvsbus.log sqlldr userid=<site_schema>/<password> control=help.ctl log=<dir>help.log sqlldr userid=<site_schema>/<password> control=helpctxs.ctl log=<dir>helpctxs.log sqlldr userid=<site_schema>/<password> control=helprela.ctl log=<dir>helprela.log sqlldr userid=<site_schema>/<password> control=helpindx.ctl log=<dir>helpindx.log
where <dir> is the directory where you want the log files to be created and <password> is the password for the site_schema.
Upon installing a WebDB site, three database schemas are created. For example, if the schema name chosen for the new WebDB site is MYSITE, then the relevant schemas would be:
If you want to drop or delete a WebDB site from your database, you must delete these schemas and the data associated with them.
To drop WebDB sites, do the following in SQL*Plus:
select username from all_users
<sitename> <sitename>_public <sitename>_admin
drop user <sitename> cascade; drop user <sitename>_public cascade; drop user <sitename>_admin cascade;
Note: Make sure that you really want to drop a site or site users since you cannot recover once they have been dropped. |
Delete from wwv_modules$ where schema = upper('<sitename>');
Note: Do this for each WebDB site you have dropped above.
COMMIT;
The URL to the WebDB site is dropped.
If you drop a user from the Oracle database, any WebDB site that was created by that user, will stop working. To resolve this:
sqlplus sys/<sys_password>
grant execute on sys.dbms_sys_sql to <site_schema>
where
sys_password
is the SYS user password for the database.
site_schema
is the schema that owns the site.
You should now be able to access the WebDB site with an authenticated (valid) database username/password.
|
Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|