| Unable to install HTML DB [message #167147] |
Tue, 11 April 2006 09:53  |
Azrael
Messages: 8
Registered: April 2006
|
Junior Member |
|
|
I have Oracle 10g 10.1.0.2.0 on XP, and am trying to instal HTML DB 2.0.
Basically, I used HTML DB in the past on a work placement, thought I dont have much experiance of regular Oracle, thought Im fine with SQL. I want to use HTML at home, on my XP machine. I installed Oracle fine, played a little with Enterprise manager, but I cannot make HTML DB install.
Here's what Im having problems with
| Quote: |
#
Change your working directory to htmldb.
#
Start SQL*Plus and connect the database where Oracle HTML DB is installed as SYS or SYSTEM, for example:
c:\> sqlplus sys/SYS_password as sysdba
#
Run htmldbins.sql passing the following six arguments in the order shown:
@htmldbins password tablespace_htmldb tablespace_files tablespace_temp images connect
Where:
*
password is the password for the Oracle HTML DB administrator account, the HTML DB schema owner, and the HTML DB files schema owner.
The HTML DB schema owner is the user or schema into which Oracle HTML DB database objects will be installed. The HTML DB files schema owner is the user or schema where uploaded files are maintained in Oracle HTML DB.
*
tablespace_htmldb is the name of tablespace for the Oracle HTML DB application user.
*
tablespace_files is the name of tablespace for the Oracle HTML DB files user.
*
tablespace_temp is the name of the temporary tablespace.
*
images is the virtual directory for Oracle HTML DB images. To support future Oracle HTML DB upgrades, define the virtual image directory as /i/.
*
connect is the Oracle Net connect string to the database. If this is a local install, use none or NONE.
The following examples demonstrate running htmldbins.sql and passing these arguments when the target database is Oracle Database 10g release 1 (10.1):
Local installation:
sqlplus "sys/syspass as sysdba" @htmldbins password SYSAUX SYSAUX TEMP /i/ none
Using a connect string:
sqlplus "sys/syspass@10g as sysdba" @htmldbins password SYSAUX SYSAUX TEMP /i/ 10g
|
I think Im meant to type
@htmldbins.sql password sysaux sysaux TEMP /i/ none
but I get
SP2-0310 unable to open file "htmldbins.sql"
This is the first thing Im putting in after entering SQL*plus as system, is there something else I should do first?
I would really appreciate any help
|
|
|
|
|
|
| Re: Unable to install HTML DB [message #167317 is a reply to message #167231] |
Wed, 12 April 2006 07:23  |
Azrael
Messages: 8
Registered: April 2006
|
Junior Member |
|
|
|
I thought I did but maybe not. I got confused about it, I thought it meant bring up the directory in windows. It only says to open SQL*plus after that, so I didnt think it was a command in that. Does it mean open it through a DOS prompt or something?
|
|
|
|
|
|
|
|
|
|
| Re: Unable to install HTML DB [message #167366 is a reply to message #167147] |
Wed, 12 April 2006 12:34 |
Azrael
Messages: 8
Registered: April 2006
|
Junior Member |
|
|
Doesnt seem to have worked, got this error after the intall attempt:
ERROR at line 1:
ORA-04063: package body "FLOWS_020000.WWV_FLOW_AUDIT" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"FLOWS_020000.WWV_FLOW_AUDIT"
ORA-06512: at line 3
Would this be caused by a mistake in the install command itself, or is there something I need to do to the database first? After installing Oracle I basically just made a schema and a table to test it, does more need to be done to install HTML DB?
|
|
|
|
| Re: Unable to install HTML DB [message #167490 is a reply to message #167366] |
Thu, 13 April 2006 06:09 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Any errors in your installation-log?
First try to rerun the installation.
If that fails:
How is your pl/sql knowledge? Can you recompile the schema and find out what's missing?
Then, goto the htmldb-installation dir and find the appropriate installation-file and try to correct the errors by rerunning it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
