Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Installation with oracleInstallation with oracle
Previous
 
Next
New Post
8/24/2006 10:36 AM
 
AM Portali

Joined: 8/23/2006
Posts: 2

 

Someone can help me please?

I’m trying to install DotNetNuke 4.0.2 with oracle 9i. One machine is the database server (windows 2000) and the other is the web server (windows 2000 with IIS 5.0 and DNN Oracle Data Provider 4.00.2).

 

 

 

I had this log during the installation:

 

Installing DotNetNuke

Version: 04.00.02

 

 

 

Installation Status Report

00:00:00.078 - Installing Version: 3.1.0

00:00:00.093 - Installing Script: DotNetNuke.SetUp.OracleDataProvider

00:00:01.453 - Installing Script: DotNetNuke.Schema.OracleDataProvider

00:00:19.937 - Installing Script: DotNetNuke.Data.OracleDataProvider

00:00:22.937 - Installing MemberRole Provider:

00:00:22.953 - Executing InstallCommon.sql

00:00:25.046 - Executing InstallMembership.sql

00:00:25.078 - Executing InstallProfile.sql

00:00:25.109 - Executing InstallRoles.sql

00:00:25.187 - Upgrading to Version: 3.1.1

00:00:29.015 - Upgrading to Version: 3.2.0

00:00:29.578 - Upgrading to Version: 4.0.0

00:00:31.125 - Upgrading to Version: 4.0.1

00:00:31.484 - Upgrading to Version: 4.0.2

00:00:31.562 - Performing General Upgrades

00:00:32.453 - Loading Host Settings:

00:00:32.812 - Configuring SuperUser:

00:00:33.296 - Installing Desktop Modules:

00:00:33.296 - Installing Modules:

00:00:33.343 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Announcements_3.1_Install.zip:

00:00:34.015 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Announcements_3.1_Oracle.zip:

00:00:34.906 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Contacts_3.1_Install.zip:

00:00:35.171 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Contacts_3.1_Oracle.zip:

00:00:35.937 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Discussions_3.1_Install.zip:

00:00:36.250 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Discussions_3.1_Oracle.zip:

00:00:37.046 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Documents_3.1_Install.zip:

00:00:37.406 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Documents_3.1_Oracle.zip:

00:00:38.218 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Events_3.1_Install.zip:

00:00:38.500 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Events_3.1_Oracle.zip:

00:00:39.703 -   Installing Module File C:\DotNetNuke\Website\Install\Module\FAQs_3.1_Install.zip:

00:00:40.046 -   Installing Module File C:\DotNetNuke\Website\Install\Module\FAQs_3.1_Oracle.zip:

00:00:40.781 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Feedback_3.1_Install.zip:

00:00:40.937 -   Installing Module File C:\DotNetNuke\Website\Install\Module\HTML_3.1_Install.zip:

00:00:41.406 -   Installing Module File C:\DotNetNuke\Website\Install\Module\HTML_3.1_Oracle.zip:

00:00:42.171 -   Installing Module File C:\DotNetNuke\Website\Install\Module\IFrame_3.1_Install.zip:

00:00:42.437 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Image_3.1_Install.zip:

00:00:42.609 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Links_3.1_Install.zip:

00:00:42.890 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Links_3.1_Oracle.zip:

00:00:43.890 -   Installing Module File C:\DotNetNuke\Website\Install\Module\NewsFeeds_3.1_Install.zip:

00:00:44.078 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Survey_3.1_Install.zip:

00:00:44.390 -   Installing Module File C:\DotNetNuke\Website\Install\Module\Survey_3.1_Oracle.zip:

00:00:45.453 -   Installing Module File C:\DotNetNuke\Website\Install\Module\UserDefinedTable_3.1_Install.zip:

00:00:45.718 -   Installing Module File C:\DotNetNuke\Website\Install\Module\UserDefinedTable_3.1_Oracle.zip:

00:00:46.625 -   Installing Module File C:\DotNetNuke\Website\Install\Module\UsersOnline_3.1_Install.zip:

00:00:46.828 -   Installing Module File C:\DotNetNuke\Website\Install\Module\UsersOnline_3.1_Oracle.zip:

00:00:47.546 -   Installing Module File C:\DotNetNuke\Website\Install\Module\XML_3.1_Install.zip:

00:00:47.734 - Executing Additional Scripts:

00:00:47.734 -   Creating Portal: My Website

00:00:53.953 -   Successfully Installed Portal 0:

00:00:53.953 - Installing Optional Resources:

 

After the installation I had this error:

 

File

 

Error  

ORA-00600: codice errore INT., argom.: [kokegPinLob1], [], [], [], [], [], [], [] ORA-06512: a "DNN402USER.DNN_ADDEVENTLOG", line 23 ORA-06512: a line 1

 

 

In the home page when I open it  as user I had the error in the modules  “Error: Welcome To My Website... is currently unavailable.” 

 

 

If you log in as host the error in “Welcome to My website”  module is the following:

Error: Welcome To My Website... is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: ORA-06564: L'oggetto DNN_GETHTMLTEXT non esiste ORA-06512: a "SYS.DBMS_UTILITY", line 114 ORA-06512: a line 1 ---> System.Data.OracleClient.OracleException: ORA-06564: L'oggetto DNN_GETHTMLTEXT non esiste ORA-06512: a "SYS.DBMS_UTILITY", line 114 ORA-06512: a line 1 at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor) at System.Data.OracleClient.OracleCommand.ExecuteNonQuery() at System.Data.OracleClient.OracleCommandBuilder.ResolveName(OracleCommand command, String nameToResolve, String& schema, String& part1, String& part2, String& dblink) at System.Data.OracleClient.OracleCommandBuilder.DeriveParametersFromStoredProcedure(OracleConnection connection, OracleCommand command) at System.Data.OracleClient.OracleCommandBuilder.DeriveParameters(OracleCommand command) at DotNetNuke.Data.OracleSqlHelper.DeriveParameters(IDbCommand cmd) at DotNetNuke.Data.AdoHelper.a(IDbConnection A_0, String A_1, Boolean A_2) at DotNetNuke.Data.AdoHelper.b(IDbConnection A_0, String A_1, Boolean A_2) at DotNetNuke.Data.AdoHelper.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at DotNetNuke.Data.AdoHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Html.OracleDataProvider.GetHtmlText(Int32 moduleId) at DotNetNuke.Modules.Html.HtmlTextController.GetHtmlText(Int32 moduleId) at DotNetNuke.Modules.Html.HtmlModule.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

 

 

 
 
New Post
8/24/2006 5:38 PM
 
Sanjay Mehrotra

www.acuitisolutions.com
Joined: 5/30/2003
Posts: 591

luigi.matticari  - did you have the modules.zip files in your modules sub folder (from when you unzipped DNN).
This is a known issue when you unzip DNN and leave the existing zip files in the folder. I need to update the documentation to reflect the following.

Setup the DNN Oracle DataProvider

  • Delete all files located in the [Drive]:\[Path]\DotNetNuke\Install\Modules folder.
  • Run the setup file making sure that you specify the correct folder where DotNetNuke is installed. I.e. [Drive]:\[Path]\[DotNetNuke]
  • After installing the provider successfully go to the Installation Directory and locate the OracleWeb.config file which will be copied over during the installation. Rename your existing web.config file to web.old and then rename OracleWeb.config to web.config.
  • Using Notepad, open the newly renamed web.config and make any changes to the SiteOracle Key under App Settings and Connection Settings.  A sample is provided below.

 

 

App Settings

<add key="SiteOracle" value="User Id=DNNUSER;Password=DNNUSER;Data Source=DNN3"/>

Providers

<add name="OracleDataProvider" type="DotNetNuke.Data.OracleDataProvider, DotNetNuke.OracleDataProvider" connectionStringName="SiteOracle" upgradeConnectionString="" providerPath="~\Providers\DataProviders\OracleDataProvider\" objectQualifier="DNN_" databaseOwner="" UseEncryption="false" />

  • If you are upgrading from a previous version, make sure you copy your MachineValidationKey and MachineDecryptionKeys.
  • Open up your web browser and load the website by entering the URL for the site.

 

 

I would recommend the following

a) Uninstall your oracle data provider and blow away the database schema that you created before and re-create.

b) Blow away the folder you unzipped DNN into.

c) Unzip the contents of 4.0.2 into a new folder.

d) Remove the zip files in your modules folder.

e) Install the oracle data provider.


Shoot me an email to dnnsupport@webacuity.com if you have any questions.

Thanks

Sanjay

 

 

AcuitiDP - Oracle Data Provider for DotNetNuke
 
New Post
8/25/2006 6:00 AM
 
AM Portali

Joined: 8/23/2006
Posts: 2

Thank you Sanjay, it works fine, I’was going crazy with this problem.

We tried to use the email address dnnsupport@webacuity.com but  it didn’t work yestarday.

We would like to know if it is possible to have the upgrade 4.0.3 and when you are planning to release the 4.3.3 version.

 

We would like also to ask you if had experience about using DNN with a webservices dataprovider.

Our next project needs to run on an architecture that has a firewall between the webserver and the DB server so we have to find a solution to use Oracle via webservices instead of normal DB connection. Do you have any advice to share with us?

thanks in advance
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Installation with oracleInstallation with oracle


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out