Oracle Error 37002
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support tips Oracle Error Tips by Burleson Consulting Oracle docs note this about ORA-37002: ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support. Cause: A severe error occurred while initializing OLAP. Action: Contact support (and possibly OLAP development) for help in debugging the issue. Many users find themselves encountering error ORA-37002. ORA-37002 occurs when a user is trying to backup an OLAP catalog schema. When attempting to backup using RMAN, if the exporting 9.2.0.5-10.1.0.3 was manually created, ORA-37002 will be thrown. Exporting RMAN can also result in ORA-37002 and associated errors. The message that you will find is: . exporting refresh groups and children . exporting dimensions . exporting post-schema procedural objects and actions EXP-00008: ORACLE error 37002 encountered ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support. ORA-33262: Analytic workspace EXPRESS does not exist. ORA-06512: at "SYS.DBMS_AW", line 27 ORA-06512: at "SYS.DBMS_AW", line 115 ORA-06512: at "SYS.DBMS_AW_EXP", line 325 ORA-06512: at line 1 ORA-37002 is caused by the lack of OLAP on the database, which occurs if the database is created from a script without OLAP. General purpose databases may have underlying basic OLAP and still return ORA-37002 because the export would continually be searching for components to catalog. Also important to note it that ORA-37002 can also be thrown with, the associated errors, after a database has been upgraded. If this occurs, you can resolve ORA-37002 by using this execution: 1. To Perform Relational Exports (schema/database) without Analytic Workspaces. SQL> conn / as SYSDBA SQL> delete from sys.exppkgact$ where package = 'DBMS_AW_EXP'; To restore this run the following SQL> conn / as sysdba SQL> @ ?/rdbms/admin/dbmsaw.plb Get the Complete Oracle Utility Information The landmark book "Advanced Oracle UtilitiesPages ... newblock) ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support. ORA-33262: ... Oracle DBA : ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support ... install of OLAP objects results in: ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP ... Oracle DBA : contact Oracle OLAP technical support. http://dbarajabaskar.blogspot.de/search/label/contact%20Oracle%20OLAP%20technical%20support. Similar Pages ... 2010 ORA-37002: Oracle OLAP failed to initialize. http://www.dba-oracle.com/sf_ora_37002_oracle_olap_failed_to_initialize_please_contact_oracle_olap_technical_support_bc1.htm Please contact Oracle OLAP technical support. I have ... install of OLAP objects results in: ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP ... ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support. ORA-33262: Analytic ... Oracle DBA : Oracle OLAP failed to initialize http://dbarajabaskar.blogspot.de/search/label/Oracle%20OLAP%20failed%20to%20initialize Similar Pages ... http://www.orasites.net/q/ORA-37002+Oracle+OLAP+failed+to+initialize+Please+contact+Oracle+OLAP+technical+support 2010 ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support. I have ... install of OLAP objects results in: ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP ... ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support. ORA-33262: Analytic ... Oracle in World: EXP-00008 ORA-37002: Oracle OLAP failed to initialize http://arjudba.blogspot.de/2011/03/exp-00008-ora-37002-oracle-olap-failed.html Similar Pages ... Oracle in World: EXP-00008 ORA-37002: Oracle OLAP failed to initialize skip to main | skip to sidebar ... initialize. Please contact Oracle OLAP technical support. ORA-33262: Analytic workspace EXPRESS does ... and ORA-37002 like below. EXP-00008: ORACLE error 37002 encountered ORA-37002: Oracle OLAP failed to ... Oracle in World: EXP-00008 ORA-37002: Oracle OLAP failed to initialize http://arjudba.blogspot.de/2011/03/exp-00008-ora-37002-oracle-olap-failed.html#sidebar Similar Pages ... Oracle in World: EXP-00008 ORA-37002: Oracle OLAP failed to initialize skip to main | skip to sidebar ... initialize. Please contact Oracle OLAP technical support. ORA-33262: Analytic workspace EXPRESS does ... and
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora37002-978422 Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran oracle error Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This oracle error 37002 group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. ORA-37002 Mad Unix asked Apr 8, 2006 | Replies (2) I am getting the following error when i export data from 10g on SuSE linux C:\Documents and Settings\Administrator>D:\ORACLE9I\bin\EXP.EXE usr/pass@king owner=3D