Pepe2323
asked on
Install Oracle XML issues
Hellow Guys
I'm trying to install Oracle XML on Oracle 10.2.0.4
but i'm facing some issues running the sql script
i'm running like this:
SQL> @?/rdbms/admin/catqm xml_password xmldb_ts temporal
i already created the tablespace and i'm using the other table sapce called temporal
must part of the script runs fine but the last part seems like lost connection to the database
I will attach all my output.
I have been looking on google for a solution but seems no much info.
Thanks in advance.
XML-install-log.txt
I'm trying to install Oracle XML on Oracle 10.2.0.4
but i'm facing some issues running the sql script
i'm running like this:
SQL> @?/rdbms/admin/catqm xml_password xmldb_ts temporal
i already created the tablespace and i'm using the other table sapce called temporal
must part of the script runs fine but the last part seems like lost connection to the database
I will attach all my output.
I have been looking on google for a solution but seems no much info.
Thanks in advance.
XML-install-log.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Finally it worked my XML, this is what i did:
i uninstalled the failed XML install
i found out that my CATALOG and CATPROC showed also as invalid, as first step i fixed this problem:
$sqlplus "/as sysdba"
SQL> startup upgrade
SQL > @?/rdbms/admin/catalog.sql
SQL > @?/rdbms/admin/catproc.sql
SQL > @?/rdbms/admin/utlrp.sql
At this point my CATPROC and CATALOG ware fixed so shown as VALID
then i made a XML install again but this time instead of run the command from the sqplus i did using nohup option
nohup sqlplus / as sysdba @?/rdbms/admin/catqm xml_password xmldb_ts temporal
for some reason looks like if i run like this it run much better than if i logged on sqlplus
Regards.