P2-0310 Unable To Open File

Oracle® DatabaseRelease Notes10 g Release 2 (10.2) for HP OpenVMSB25413-05October 2012This document contains important information that was not included in the platform-specific or product-specific documentation. Except where noted in the text, the information in these notes applies to Oracle Database 10 g Release 2 for HP OpenVMS Alpha and HP OpenVMS Itanium.This document may be updated after it is released. To check for updates to this document and to view other Oracle documentation, see the Documentation section on the Oracle Technology Network (OTN) website:These Release Notes are part of the following documentation set for the Oracle Database 10 g for HP OpenVMS:.This document contains the following topics:. 3 Unsupported Initialization ParametersSupport for the following Oracle Database initialization parameters found in earlier releases has been removed starting with this release of Oracle Database:.ALWAYSANTIJOIN.ALWAYSSEMIJOIN.JOBQUEUEINTERVAL.OPTIMIZERPERCENTPARALLEL.HASHMULTIBLOCKIOCOUNT.DBBLOCKLRULATCHES.DBBLOCKMAXDIRTYTARGET.SORTMULTIBLOCKREADCOUNT.DBFILEDIRECTIOCOUNT.GCDEFERTIME.GCRELEASABLELOCKS.GCROLLBACKLOCKS.LMLOCKS.LMRESS.USEINDIRECTDATABUFFERS.

• Sp2-0310 Unable To Open File
• Sp2-0310 Unable To Open File Mount.sql

5.1.1 Configuring Enterprise Manager Agent After UpgradeDuring normal installation, when using the Oracle Database Configuration Assistant to create a database, the Oracle Database Configuration Assistant automatically starts the Oracle Enterprise Manager Configuration Assistant to create the necessary configuration files for the Oracle home and database.If you upgrade from a previous release, then the configuration assistants do not start automatically. After the upgrade is complete, ensure the following:.The database is up and running in the Oracle Database 10 g Oracle home.Set up your Oracle environment by running the following command from the Oracle home directory:$ @orauser sid.Manually run Oracle Enterprise Manager Configuration Assistant (emca)Oracle Enterprise Manager Configuration Assistant prompts for various parameters that you need to respond to. Enter appropriate values for these parameters. After entering the parameter values, type Yes at the prompt asking whether to continue or not, and then press Enter. Oracle Enterprise Manager Configuration Assistant runs through the tasks and completes the configuration.

If any errors are reported when running Oracle Enterprise Manager Configuration Assistant, then refer to the oraroot:cfgtoollogsemca.log file for more information about errors or failures.After Oracle Enterprise Manager Configuration Assistant runs successfully, follow the steps in the 'Installing, Configuring, and Running Enterprise Manager Agent' appendix of to complete the remaining steps. 5.1.2 Running the Installer on an Existing InstallationIf you plan to run Oracle Universal Installer on an existing installation, then ensure that all Oracle processes running out of that installation are completely shutdown, including Oracle instances, listeners, agent, and so on. After shutting down all Oracle processes, run the following command to stop the Bequeath listener and remove the known binaries:$ remoracleThere are cases where remoracle may be optional, such as installing the Companion CD software into the same Oracle home as the Oracle Database software. If you are installing Client Administration on the same Oracle home as a Database installation, or deploying certain patches, then you must shutdown all Oracle processes. Failure to shutdown and perform remoracle is likely to result in errors. 5.2 Enabling Automated BackupsWhile installing Oracle Database, the Specify Backup and Recovery Options screen may appear truncated if the system does not have the required fonts installed. If the system has only fixed-width fonts, you may not be able to fully specify the required information in the Backup Job Credentials area of the screen.

To work around this issue, do not select Enable Automated Backups on this screen. After the installation is complete, use Oracle Enterprise Manager Grid Control to enable automated backups. 5.3 Oracle MultimediaA known issue exists with Oracle Multimedia on Oracle Database 10 g.

5.5 Oracle Clusterware and Oracle RAC Known IssuesThe following are known Oracle Clusterware issues in the current release:.An Oracle Clusterware installation creates the following system level logicals:ORAOCRCONFIGLOCORASCLSSCRPATHORAVAROPTIf you plan to delete an Oracle Clusterware installation and create a non-Oracle Clusterware installation on the same node, ensure that you first deassign these logicals. Failure to do so will result in unintended errors or failures on assistants such as Oracle Net Configuration Assistant and Oracle Database Configuration Assistant.In an Oracle Clusterware installation, if Private Interconnect is selected in the Private Interconnect Configuration screen, then the Private Interconnect Configuration Assistant displays a failure message even though the actual operation completes successfully. Check the oifcfg.log file in the installation directory, and verify that the operation is completed successfully.

If a failure is recorded in the log file, then you must run the oifcfg manually as indicated by Oracle Universal Installer. You can ignore the Private Interconnect Assistant failure if the operation completed successfully.While installing Oracle Clusterware, the device on which an installation is created is visible and accessible across all nodes of a cluster installation. For example, for an Oracle Clusterware installation created on disk A to run on nodes B and C, disk A is accessible on both nodes. For this reason, it is not necessary to copy a device across nodes. You may see error messages similar to the following in the.err files created under the log directory of your orainventory:Error in copying file: rootadd.comoracle.ops.mgmt.cluster.ClusterException: PRKC-1004: Problem in copying file to nodeThese errors can be safely ignored.During a Custom installation of Oracle Real Application Clusters (Oracle RAC), Oracle Network Configuration Assistant is displayed at the end of the installation procedure even though the Database Creation option is not selected.

You must run Virtual IP Configuration Assistant before running Oracle Net Configuration Assistant for Oracle RAC. 5.7 Enhanced Oracle Database PerformanceInstall the Oracle image as an HP OpenVMS resident image to increase the performance of Oracle database. To install the ORACLE.EXE image resident, refer to document 282965.1, OpenVMS: Installing the Oracle Image /Resident on the My Oracle Support (formerly Oracle MetaLink) website:To locate document 282965.1:.Log on to My Oracle Support (formerly Oracle MetaLink).Set Article ID as the search source.Enter 282965.1 in the search field, then click Search. 5.7.1 System ChangesThe following system changes are recommended for improved Oracle performance:.SYSGENIncrease the current size of the SYSGEN parameters: GHRESCODE, GHRESDATA, and GHRSRVPGCNT.

The size of the parameters GHRESCODE and GHRSRVPGCNT need to be increased by 8192, and GHRESDATA to its current maximum value of 2048. This increase needs to accommodate the size of the image being installed resident. For 9.2.0.x ORACLE.EXE, this size should be of maximum 90 MB, and for 10.1.0.x ORACLE.EXE it should be approximately 98 MB depending on what options you have selected for ORACLE.EXE during installation.Oracle recommends using AUTOGEN and the modparams.dat file for making these changes. These values should be changed by making use of the ADD parameter feature of AUTOGEN. Note:These parameters are not dynamic. You must restart your system for the new values to take effect.You must also install the HP OpenVMS image SYS$LIBRARY:DSMTSHR.EXE with shared address space before the Oracle image is installed resident. HP OpenVMS installs this image by default, but not with shared address space.There are two ways to implement this:.Run the install replace command as shown:$ install replace sys$library:dismntshr.exe/shared=addressThis command would need to be rerun after any system restart and before the Oracle image is installed (which typically occurs during execution of Oracle startup procedures).Edit the file sys$manager:vms$imagesmaster.dat, which contains the list of installed images for HP OpenVMS, and add the /shared=address qualifier for the DISMNTSHR.EXE entry in the file.

This is done before running AUTOGEN to ensure that DISMNTSHR.EXE is installed with the /share=address option after a system restart or after running AUTOGEN. You may re-edit this file if it is included in a system patch or upgrade.

Caution should be taken when editing this file, so that this is the only change made.Oracle Command ProceduresTo make the Oracle image an installed resident, make the following changes to the command procedure that links the ORACLE.EXE image and the procedure that installs this image:.For 10.1.0.x: ORAROOT:000000INSORACLE.COMOld:installl create oraroot:binoracle.exe/open/headerres/shareNew:installl createoraroot:binoracle.exe/open/headerres/share=address/resident. 6.1 Oracle Net Configuration Assistant HelpIn the Oracle Net Configuration Assistant help, the link to the Select Oracle Context help topic is broken. The text for this topic is as follows:Directory Usage Configuration, Select Oracle ContextOracle administrative content has been found in multiple locations in the directory. Oracle administrative content is stored in Oracle Context, a subtree in the directory that stores Oracle entries.From the list, select or enter the location you want to use as the default Oracle Context location from which this computer will access Oracle entries, such as connect identifiers. 6.2 Oracle Net Configuration Assistant IPC ProtocolIf you select the use of the IPC protocol for the network layer, Oracle Net Configuration Assistant cannot reliably determine whether the key value specified in the protocol is in use. To let the user specify whether the key is actually available, Oracle Net Configuration Assistant displays the following message:The information provided for this listener is currently in use by other software on this computer. You can proceed with this configuration as it is, but it will not be possible to start this listener until the conflict is resolved.

Would you like to continue with the configuration anyway?When this message is displayed, you should check if there are other listener processes on the system. In addition, you should ensure that the key value you have specified is not in use. If it is not in use, then proceed with the configuration session. If it is in use, then shut down the listener using the key. Alternatively, you can use the Oracle Net Configuration Assistant screen to specify that you do not want to continue with the installation and then select a key value that is not in use on the system. 6.3 Flashback Table or Flashback AnalysisIf a user starts the Flashback Table or Flashback Analysis operation, and that user has FLASHBACK ANY TABLE privileges but does not have DBA privileges and specific flashback privileges on the objects that flashback is started on, then the following errors may occur:ORA-02002: error while writing to audit trailORA-00600: internal error code, arguments: kzasps1, 4, 47, ,To fix this problem, as SYSDBA, grant the user FLASHBACK privilege on the objects that are referred to in the FLASHBACK TABLE statement and then start the flashback operation.

For example:SQL GRANT FLASHBACK ON SCOTT.EMP1 TO user1;This issue is tracked with Oracle bug 3403666. 6.7 Full-Text Searching with Oracle TextFor full-text searching with Oracle Text, you must create XML tables manually.If you will need to use Oracle Text indexes for text-based ora:contains searches over a collection of XML elements, then do not use the XML schema annotation storeVarrayAsTable='true'. This annotation causes element collections to be persisted as rows in an Index Organized Table (IOT). Oracle Text does not support IOTs.To be able to use Oracle Text to search the contents of element collections, set parameter genTables='false' during schema registration.

Then create the necessary tables manually, without using the ORGANIZATION INDEX OVERFLOW clause. The tables will then be heap-organized instead of index-organized (IOT), as shown in the following example:CREATE TABLE PurchaseOrder of XMLTYPEXMLSCHEMA 'PurchaseOrder'VARRAY 'XMLDATA'.'

Sp2-0310 Unable To Open File

ACTION'STORE AS TABLE ACTIONTABLE ((PRIMARY KEY(NESTEDTABLEID, ARRAYINDEX)))VARRAY 'XMLDATA'.' LINEITEM'STORE AS TABLE LINEITEMTABLE ((PRIMARY KEY(NESTEDTABLEID, ARRAYINDEX))). 6.9 Oracle Net Configuration FilesFiles such as LISTENER.ORA, TNSNAMES.ORA, SQLNET.ORA, if configured manually, or copied and edited from earlier releases of Oracle Database may have record attributes that are incompatible with Oracle Database 10 g Release 2. 7 Known RestrictionsThe following sections lists current restrictions for using Oracle Database 10 g.HP OpenVMSHP OpenVMS always performs its I/O asynchronously. Several init.ora parameters that mimic asynchronous behavior are not needed on HP OpenVMS. Refer to, for the list of parameters that are not supported on HP OpenVMS.PORTALWith some limitations, Oracle Database 10 g with Oracle Application Server middle tier (with HP OpenVMS back end database configuration) is supported. For information about iAS support, contact your Oracle representative.Copying Oracle ExecutablesMoving executables from one HP OpenVMS system to another is not recommended due to the usage of shared libraries and to the difficulty of ensuring valid referencing.

Oracle recommends that you relink on the node where the executable will run.Using a FORTRAN CompilerThe Hewlett-Packard Fortran compiler (formerly the DIGITAL Fortran 90) is not supported by Oracle Database 10 g. To check which FORTRAN compiler is on your system, refer to.Oracle Targets Paths in the Enterprise Manager AgentDue to an inherent characteristic of the Perl language, wherein it attempts to translate any string with the '$' character in it as a Perl variable, it is strongly recommended that the paths used for Oracle targets, such as oraclehome, listeneroradir do not contain the '$' (dollar) character in them. This issue is tracked through Oracle bug 4299411.Installation TimeWhen running the Oracle Universal Installer, the Installer may take about five minutes to move from one screen to the other. This is normal and expected and the Installer is not hanging. An installation will run between 3-4 hours depending on the products being installed.During installation, when you click Next on the Installation Details screen, Oracle Universal Installer processes the information that you provided up to that point. This may take 10 minutes.

During this time, it may appear that Oracle Universal Installer is not responding. There may be similar delays on other installer screens.Oracle Database Configuration Assistant Runtime ConsiderationsWhen running the Oracle Database Configuration Assistant, the assistant performs background operations such as running databases. As a result, some of the assistant screens do not change for 10 minutes or more, depending on the system performance.If the Password Management button on the last Oracle Database Configuration Assistant screen is not visible, then expand the Oracle Database Configuration Assistant window to use the Password Management feature. 8 Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at.Access to Oracle SupportOracle customers have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.Oracle Database Release Notes, 10 g Release 2 (10.2) for HP OpenVMSB25413-05Copyright © 1996, 2012, Oracle and/or its affiliates. All rights reserved.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws.

Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S.

Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are 'commercial computer software' pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs.

No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation.

Sp2-0310 Unable To Open File Mount.sql

All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.Scripting on this page enhances content navigation, but does not change the content in any way.