3 Replies Latest reply: Aug 22, 2012 4:13 PM by 957339 RSS

    OWBSYS.WB_WORKSPACE_MANAGEMENT Package Has Errors

    user13330455
      Hi,

      I have installed OWB11g.When i try to create workspace thru repository assistant in step 6 i am getting the below error

      OWBSYS.WB_WORKSPACE_MANAGEMENT Package Has Errors

      I have complied the same package in sqlplus its not throwing errors.

      Please advice me

      Thanks
        • 1. Re: OWBSYS.WB_WORKSPACE_MANAGEMENT Package Has Errors
          David Allan-Oracle
          Did you try compiling the package body (not the spec)?

          Can you include the repository install log here?

          Cheers
          David
          • 2. Re: OWBSYS.WB_WORKSPACE_MANAGEMENT Package Has Errors
            Ciaran
            Any update on this one?

            I'm having the same error....
            • 3. Re: OWBSYS.WB_WORKSPACE_MANAGEMENT Package Has Errors
              957339
              Hello,

              I have the same error, i am working in windows 7 64bits. This is the log.

              [main] [ 2012-08-16 02:42:30.239 AMT ] [InventoryUtil.getOracleBase:147] Getting ORACLE_BASE from inventory.
              [main] [ 2012-08-16 02:42:30.255 AMT ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
              [main] [ 2012-08-16 02:42:30.255 AMT ] [InventoryUtil.getOracleBase:162] Inventory Home Size = 1
              [main] [ 2012-08-16 02:42:30.255 AMT ] [InventoryUtil.getOracleBase:187] ORACLE_BASE returned from inventory:= C:\app\Tian
              [main] [ 2012-08-16 02:42:30.255 AMT ] [Host.displayOracleBaseWarning:1206] oracleBaseFromEnv null
              [main] [ 2012-08-16 02:42:30.255 AMT ] [Host.displayOracleBaseWarning:1212] oracle_base from OUI C:\app\Tian oracle_base from envC:\app\Tian
              [main] [ 2012-08-16 02:42:30.255 AMT ] [Host.checkOPS:2522] Inside checkOPS
              [main] [ 2012-08-16 02:42:30.255 AMT ] [Host.checkOPS:2534] Trying to check cluster existence
              [main] [ 2012-08-16 02:42:30.255 AMT ] [Version.isPre:304] version to be checked 11.2.0.1.0 major version to check against10
              [main] [ 2012-08-16 02:42:30.255 AMT ] [Version.isPre:315] isPre.java: Returning FALSE
              [main] [ 2012-08-16 02:42:30.255 AMT ] [OCR.loadLibrary:308]
              Inside constructor of OCR
              [main] [ 2012-08-16 02:42:30.255 AMT ] [OCR.isCluster:939] Calling OCRNative for isCluster()
              [main] [ 2012-08-16 02:42:30.255 AMT ] [OCR.isCluster:943] OCR Result status = true
              [main] [ 2012-08-16 02:42:30.255 AMT ] [OCR.isCluster:955] Bolean result = false
              [main] [ 2012-08-16 02:42:30.255 AMT ] [Host.checkOPS:2540] cluster existence:false
              [main] [ 2012-08-16 02:42:30.255 AMT ] [Host.checkOPS:2581] Cluster installed=false
              [main] [ 2012-08-16 02:42:30.270 AMT ] [InitParamHandler.endElement:524] CustomSGA flag: false
              [main] [ 2012-08-16 02:42:30.270 AMT ] [InitParamHandler.endElement:525] Database Type: MULTIPURPOSE
              [main] [ 2012-08-16 02:42:30.270 AMT ] [InitParamHandler.endElement:526] Mem Percentage: 40
              [main] [ 2012-08-16 02:42:30.286 AMT ] [OsUtilsBase.getTotalPhysicalMemory:375] Total Physical Memory in MB: 3998
              [main] [ 2012-08-16 02:42:30.286 AMT ] [OsUtilsBase.is64Bit:359] architecture is 64 bit: true
              [main] [ 2012-08-16 02:42:30.286 AMT ] [InitParamHandler.endElement:559] Total memory MB: 1600
              [main] [ 2012-08-16 02:42:30.286 AMT ] [OsUtilsBase.is64Bit:359] architecture is 64 bit: true
              [main] [ 2012-08-16 02:42:30.286 AMT ] [MemoryCalculator.<clinit>:95] setting memory minimums for 64 bit
              [main] [ 2012-08-16 02:42:30.286 AMT ] [StorageAttributes.setAttribute:240] IN threadID:1 group#=1
              [main] [ 2012-08-16 02:42:30.286 AMT ] [StorageAttributes.setAttribute:240] IN threadID:1 group#=2
              [main] [ 2012-08-16 02:42:30.286 AMT ] [StorageAttributes.setAttribute:249] Current threadID=1
              [main] [ 2012-08-16 02:42:30.286 AMT ] [StorageAttributes.setAttribute:256] Current threadID=1 ==> redoGroups[0]=1
              [main] [ 2012-08-16 02:42:30.286 AMT ] [StorageAttributes.setAttribute:266] vRedoGroups:[1]
              [main] [ 2012-08-16 02:42:30.286 AMT ] [StorageAttributes.setAttribute:296] setAttribute: bExists=false
              [main] [ 2012-08-16 02:42:30.286 AMT ] [StorageAttributes.setAttribute:240] IN threadID:1 group#=3
              [main] [ 2012-08-16 02:42:30.301 AMT ] [StorageAttributes.setAttribute:249] Current threadID=1
              [main] [ 2012-08-16 02:42:30.301 AMT ] [StorageAttributes.setAttribute:256] Current threadID=1 ==> redoGroups[0]=1
              [main] [ 2012-08-16 02:42:30.301 AMT ] [StorageAttributes.setAttribute:256] Current threadID=1 ==> redoGroups[1]=2
              [main] [ 2012-08-16 02:42:30.301 AMT ] [StorageAttributes.setAttribute:266] vRedoGroups:[1, 2]
              [main] [ 2012-08-16 02:42:30.301 AMT ] [StorageAttributes.setAttribute:296] setAttribute: bExists=false
              [main] [ 2012-08-16 02:42:30.301 AMT ] [Verifier.getDatabaseSize:3143] Clone Datafile: SYSTEM01.DBF size: 680
              [main] [ 2012-08-16 02:42:30.301 AMT ] [Verifier.getDatabaseSize:3143] Clone Datafile: SYSAUX01.DBF size: 440
              [main] [ 2012-08-16 02:42:30.301 AMT ] [Verifier.getDatabaseSize:3143] Clone Datafile: UNDOTBS01.DBF size: 25
              [main] [ 2012-08-16 02:42:30.301 AMT ] [Verifier.getDatabaseSize:3143] Clone Datafile: USERS01.DBF size: 5
              [main] [ 2012-08-16 02:42:30.301 AMT ] [Verifier.getControlfFileSizes:3510] No. of Control files:=2
              [main] [ 2012-08-16 02:42:30.301 AMT ] [Verifier.getDatabaseSize:3204] dbSize: 1177600 redoLogSize: 153600 ctrlFileSize: 4096
              [main] [ 2012-08-16 02:42:30.301 AMT ] [TemplateManager.getParsedAttributes:1828] Setting DB_RECOVERY_FILE_SIZE to default size: 3912
              [main] [ 2012-08-16 02:42:30.301 AMT ] [TemplateManager.parseCloneTemplate:1518] See for any transportable datafiles in TemplateManager.....
              [main] [ 2012-08-16 02:42:30.301 AMT ] [TemplateManager.isInstallTemplate:2300] Selected Template by user:=General Purpose
              [main] [ 2012-08-16 02:42:30.301 AMT ] [TemplateManager.isInstallTemplate:2307] The Message Id to be searched:=GENERAL_PURPOSE
              [main] [ 2012-08-16 02:42:30.301 AMT ] [TemplateManager.parseCloneTemplate:1530] create new clone data file for tp file.......
              [main] [ 2012-08-16 02:42:30.301 AMT ] [Host.setupOIDCommandlineParameters:8452] setupOIDCommandlineParameters:
              [main] [ 2012-08-16 02:42:30.301 AMT ] [Host.setupOIDCommandlineParameters:8453] m_regWithdirService: false
              [main] [ 2012-08-16 02:42:30.301 AMT ] [Host.setupOIDCommandlineParameters:8454] m_unregWithdirService: false
              [main] [ 2012-08-16 02:42:30.301 AMT ] [Host.setupOIDCommandlineParameters:8455] m_updateDirService: false
              [main] [ 2012-08-16 02:42:30.301 AMT ] [HAUtils.getHASHome:631] Oracle home from system properties: C:\app\Tian\product\11.2.0\dbhome_2
              [main] [ 2012-08-16 02:42:30.301 AMT ] [HAUtils.getCRSHome:588] Getting configured CRS/HAS home for Oracle home ( C:\app\Tian\product\11.2.0\dbhome_2 ) ...
              [main] [ 2012-08-16 02:42:30.301 AMT ] [GETCRSHOMEUtil.<init>:88] Toolname: getcrshome.exe --- Tool location: C:\app\Tian\product\11.2.0\dbhome_2\binTool dependencies: [Ljava.lang.String;@5d3ad33d
              [main] [ 2012-08-16 02:42:30.301 AMT ] [CmdToolUtil.doexecute:360] starting remote exec server on local node src=C:\app\Tian\product\11.2.0\dbhome_2\bin dest=C:\Temp\
              [main] [ 2012-08-16 02:42:30.411 AMT ] [Utils.getLocalHost:356] Hostname retrieved: Tian_hp, returned: Tian_hp
              [main] [ 2012-08-16 02:42:30.411 AMT ] [WindowsSystem.startRemoteExecServer:1728] WS: Checking if service is started

              [main] [ 2012-08-16 02:42:30.411 AMT ] [Utils.getLocalHost:356] Hostname retrieved: Tian_hp, returned: Tian_hp
              [main] [ 2012-08-16 02:42:30.411 AMT ] [WindowsSystem.dorunRemoteExecCmd:2061] WS: Calling windowsNative with cmd: C:\app\Tian\product\11.2.0\dbhome_2\bin\getcrshome.exe
              [main] [ 2012-08-16 02:42:31.425 AMT ] [WindowsSystem.dorunRemoteExecCmd:2064] WS: WinNative returned: true
              [main] [ 2012-08-16 02:42:31.425 AMT ] [WindowsSystem.dorunRemoteExecCmd:2078] WS: remote command executed, but didn't return zero.
              [main] [ 2012-08-16 02:42:31.425 AMT ] [GETCRSHOMEUtil.getCRS_HOME:147] cmdTool.execute() failed.
              [main] [ 2012-08-16 02:42:31.425 AMT ] [HAUtils.isHASConfigured:364] Ignoring exception in isHASConfigured: PRCT-1400 : Fallo de ejecución de getcrshome. Detalles del error:
              localnode
              PRCT-1400 : Fallo de ejecución de getcrshome. Detalles del error:
              localnode
                   at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:425)
                   at oracle.sysman.assistants.util.hasi.HAUtils.getCRSHome(HAUtils.java:592)
                   at oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:652)
                   at oracle.sysman.assistants.util.hasi.HAUtils.isHASConfigured(HAUtils.java:360)
                   at oracle.sysman.assistants.dbca.backend.Host.startOperation(Host.java:3413)
                   at oracle.sysman.assistants.dbca.Dbca.execute(Dbca.java:119)
                   at oracle.sysman.assistants.dbca.Dbca.main(Dbca.java:184)
              Caused by: PRCT-1400 : Fallo de ejecución de getcrshome. Detalles del error:
              localnode
                   at oracle.cluster.cmdtools.GETCRSHOMEUtil.getCRS_HOME(GETCRSHOMEUtil.java:161)
                   at oracle.cluster.cmdtools.GETCRSHOMEUtil.getCRS_HOME(GETCRSHOMEUtil.java:112)
                   at oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:422)
                   ... 6 more
              [main] [ 2012-08-16 02:42:31.425 AMT ] [Verifier.processRawConfigFile:4031] StorageType == 0
              [main] [ 2012-08-16 02:42:31.425 AMT ] [Verifier.setOradataDest:4897] setOradataDest:dfDest=C:\app\Tian\oradata
              [main] [ 2012-08-16 02:42:31.425 AMT ] [TemplateManager.updateDatafileDestination:2081] updateDatafiles:datafileDir=C:\app\Tian\oradata
              [main] [ 2012-08-16 02:42:31.425 AMT ] [TemplateManager.updateDatafileDestination:2225] From template, RedoLogGrName=1
              [main] [ 2012-08-16 02:42:31.456 AMT ] [TemplateManager.updateDatafileDestination:2240] new file name redo01.log
              [main] [ 2012-08-16 02:42:31.456 AMT ] [TemplateManager.updateDatafileDestination:2225] From template, RedoLogGrName=2
              [main] [ 2012-08-16 02:42:31.456 AMT ] [TemplateManager.updateDatafileDestination:2240] new file name redo02.log
              [main] [ 2012-08-16 02:42:31.456 AMT ] [TemplateManager.updateDatafileDestination:2225] From template, RedoLogGrName=3
              [main] [ 2012-08-16 02:42:31.456 AMT ] [TemplateManager.updateDatafileDestination:2240] new file name redo03.log
              [main] [ 2012-08-16 02:42:31.456 AMT ] [ProgressOnlyHost.performOperation:259] processRawConfigFile=false
              [main] [ 2012-08-16 02:42:31.456 AMT ] [Verifier.validateTemplate:2019] StorageType == 0
              [main] [ 2012-08-16 02:42:31.456 AMT ] [ProgressOnlyHost.performOperation:275] validateTemplate=true
              [main] [ 2012-08-16 02:42:31.487 AMT ] [NetworkUtils.checkListenerStatus:429] Checking listener status: LISTENER
              [main] [ 2012-08-16 02:42:31.565 AMT ] [NetworkUtils.checkListenerStatus:435] lsnrct status output

              LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 16-AGO-2012 02:12:31

              Copyright (c) 1991, 2010, Oracle. All rights reserved.

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
              STATUS of the LISTENER
              ------------------------
              Alias LISTENER
              Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
              Start Date 16-AGO-2012 02:12:23
              Uptime 0 days 0 hr. 0 min. 9 sec
              Trace Level off
              Security ON: Local OS Authentication
              SNMP OFF
              Listener Parameter File C:\app\Tian\product\11.2.0\dbhome_2\network\admin\listener.ora
              Listener Log File c:\app\tian\diag\tnslsnr\Tian_hp\listener\alert\log.xml
              Listening Endpoints Summary...
              (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
              The listener supports no services
              The command completed successfully
              [main] [ 2012-08-16 02:42:31.565 AMT ] [NetworkUtils.checkListenerStatus:453] returning listenernull
              [main] [ 2012-08-16 02:42:31.581 AMT ] [Verifier.validateTemplate:2019] StorageType == 0
              [main] [ 2012-08-16 02:42:31.612 AMT ] [Verifier.calculateCloneDatafilePathsAndSizes:3460] canonicalPath=C:\app\Tian\
              [main] [ 2012-08-16 02:42:31.612 AMT ] [Verifier.calculateCloneDatafilePathsAndSizes:3460] canonicalPath=C:\app\Tian\
              [main] [ 2012-08-16 02:42:31.612 AMT ] [Verifier.calculateCloneDatafilePathsAndSizes:3460] canonicalPath=C:\app\Tian\
              [main] [ 2012-08-16 02:42:31.612 AMT ] [Verifier.calculateCloneDatafilePathsAndSizes:3460] canonicalPath=C:\app\Tian\
              [main] [ 2012-08-16 02:42:31.612 AMT ] [Verifier.calculateCloneDatafilePathsAndSizes:3460] canonicalPath=C:\app\Tian\
              [main] [ 2012-08-16 02:42:31.627 AMT ] [Verifier.calculateRedoLogGroupFileSizes:3591] canonicalPath=C:\app\Tian\
              [main] [ 2012-08-16 02:42:31.627 AMT ] [Verifier.calculateRedoLogGroupFileSizes:3591] canonicalPath=C:\app\Tian\
              [main] [ 2012-08-16 02:42:31.627 AMT ] [Verifier.calculateRedoLogGroupFileSizes:3591] canonicalPath=C:\app\Tian\
              [main] [ 2012-08-16 02:42:31.627 AMT ] [Verifier.getControlfFileSizes:3510] No. of Control files:=2
              [main] [ 2012-08-16 02:42:31.861 AMT ] [Host.executeSteps:5039] Executing steps....
              [main] [ 2012-08-16 02:42:31.861 AMT ] [Host.setUpForOperation:3625] setUpForOperation: Mode = 128
              [main] [ 2012-08-16 02:42:31.861 AMT ] [OsUtilsBase.copyFile:1499] OsUtilsBase.copyFile:
              [main] [ 2012-08-16 02:42:31.861 AMT ] [OsUtilsBase.copyFile:1547] **write of file at destination complete...
              [main] [ 2012-08-16 02:42:31.861 AMT ] [OsUtilsBase.copyFile:1582] **file copy status:= true