Updating tnsnames ora

posted by | Leave a comment

, an Oracle error such as ORA-12705, or even an Apache crash.Check the Apache log files for startup errors and see the sections above to resolve this problem. Set-up a $ORACLE_HOME/network/admin/file as detailed in the File Listings below. Start the listener using the command lsnrctl start. Build the embryo database using the following commands: The following steps should be performed once the database has been built to ensure that the environment conforms to Oracle's Best Practices and also ensures that it doesn't fall foul of Internal Audit. Remove the GRANT EXECUTE TO PUBLIC privilege from potentially harmful packages. Remove all database files, binaries, trace files and administration logs using the deinstall tool - see Miscellaneous Section below. /sqlplus/admin/SET TERMOUT ON CONN system/&systpw SET ECHO OFF PROMPT PROMPT PROMPT Now running HLPBLD. The default directory is specified in square brackets. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of script. Configure Oracle environment variables using the following commands: 46. /sqlplus/admin/SET TERMOUT ON SET ECHO ON SPOOL OFF When running you are prompted for the local bin directory.PHP applications can connect to other versions of Oracle Database, since Oracle has client-server cross-version compatibility.option builds OCI8 as a shared library that can be dynamically loaded into PHP.Oracle Apps Guide (OAG) is a platform for Oracle Apps R12 and 11i to understand and share live experience on it.

Configure $ORACLE_BASE/admin/SID/create/file, adjusting parameters accordingly - see File Listings section below. Configure $ORACLE_BASE/admin/SID/pfile/init file, adjusting parameters accordingly and create symbollic link to it from $ORACLE_HOME/dbs - see File Listings section below. To restore the environment back to its initial state, perform the following 1. export ORACLE_BASE=/u01/app/oracle export SQLPATH=$ORACLE_BASE/scripts/sql export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 export TNS_ADMIN=$ORACLE_HOME/network/admin export ORACLE_HOME_LISTNER=$ORACLE_BASE/product/11.2.0/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH export ORATAB=/etc/oratab ACCEPT syspw PROMPT 'Enter SYS password : ' ACCEPT systpw PROMPT 'Enter SYSTEM password : ' ACCEPT sid PROMPT 'Enter SID name : ' SET VERIFY OFF SET ECHO ON SPOOL STARTUP NOMOUNT CREATE DATABASE &sid USER SYS IDENTIFIED BY &syspw USER SYSTEM IDENTIFIED BY &systpw MAXDATAFILES 1024 MAXINSTANCES 1 MAXLOGFILES 32 MAXLOGMEMBERS 4 MAXLOGHISTORY 100 CHARACTER SET AL32UTF8 ARCHIVELOG DATAFILE ' DATA/&sid/system_01.dbf' SIZE 400m EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE ' DATA/&sid/sysaux_01.dbf' SIZE 400m LOGFILE GROUP 1 (' DATA/&sid/redo001a.dbf',' FRA/&sid/redo001b.dbf') SIZE 50m, GROUP 2 (' DATA/&sid/redo002a.dbf',' FRA/&sid/redo002b.dbf') SIZE 50m, GROUP 3 (' DATA/&sid/redo003a.dbf',' FRA/&sid/redo003b.dbf') SIZE 50m, GROUP 4 (' DATA/&sid/redo004a.dbf',' FRA/&sid/redo004b.dbf') SIZE 50m UNDO TABLESPACE undo DATAFILE ' DATA/&sid/undo_01.dbf' SIZE 400m DEFAULT TEMPORARY TABLESPACE temp TEMPFILE ' DATA/&sid/temp_01.dbf' SIZE 400m EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1m / SET ECHO OFF PROMPT PROMPT PROMPT Now running CATALOG. PROMPT PROMPT SET TERMOUT OFF @$/rdbms/admin/catalog SET TERMOUT ON PROMPT PROMPT PROMPT Now running CATBLOCK. PROMPT PROMPT SET TERMOUT OFF @$/rdbms/admin/catblock SET TERMOUT ON PROMPT PROMPT PROMPT Now running CATPROC. PROMPT PROMPT SET TERMOUT OFF @$/rdbms/admin/catproc SET TERMOUT ON SET ECHO ON CREATE TABLESPACE tools DATAFILE ' DATA/&sid/tools_01.dbf' SIZE 400m EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE users DATAFILE ' DATA/&sid/users_01.dbf' SIZE 400m EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO / CREATE TABLESPACE indx DATAFILE ' DATA/&sid/indx_01.dbf' SIZE 400m EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO / CREATE USER ops$oracle IDENTIFIED EXTERNALLY DEFAULT TABLESPACE users / GRANT DBA TO ops$oracle / CONN system/&systpw SET ECHO OFF PROMPT PROMPT PROMPT Now running PUPBLD. However, due to a bug in the script this default is not picked up. The file "coraenv" already exists in /usr/local/bin. Now product-specific root actions will be performed. binutils-2.17.50.0.6 compat-libstdc -33-3.2.3 compat-libstdc -33-3.2.3 (32 bit) elfutils-libelf-0.125 elfutils-libelf-devel-0.125 gcc-4.1.2 gcc-c -4.1.2 glibc-2.5-24 glibc-2.5-24 (32 bit) glibc-common-2.5 glibc-devel-2.5 glibc-devel-2.5 (32 bit) glibc-headers-2.5 ksh-20060214 libaio-0.3.106 libaio-0.3.106 (32 bit) libaio-devel-0.3.106 libaio-devel-0.3.106 (32 bit) libgcc-4.1.2 libgcc-4.1.2 (32 bit) libstdc -4.1.2 libstdc -4.1.2 (32 bit) libstdc -devel 4.1.2 make-3.81 sysstat-7.0.2 unix ODBC-2.2.11 unix ODBC-2.2.11 (32 bit) unix ODBC-devel-2.2.11 unix ODBC-devel-2.2.11 (32 bit) Use the following SQL script if you wish to remove just the 11g database.

The directory is in use by Oracle Home '/u01/app/oracle/agent10g'. Oracle Universal Installer clean END Oracle install clean START Clean install operation removing temporary directory '/tmp/install' on node 'myhost' Oracle install clean END ######################### CLEAN OPERATION END ######################### ####################### CLEAN OPERATION SUMMARY ####################### Successfully de-configured the following database instances : SID Cleaning the config for CCR As CCR is not configured, so skipping the cleaning of CCR configuration CCR clean is finished Successfully detached Oracle home '/u01/app/oracle/SID/product/11.2.0' from the central inventory on the local node.

The Oracle Base directory '/u01/app/oracle' will not be removed on local node. Successfully deleted directory '/u01/app/oracle/SID/product/11.2.0' on the local node. Oracle install successfully cleaned up the temporary directories.

This is to accomodate feature/bug detailled in Metalink nore 567506.1. This will install the follwing ASM 2.0 libraries 14. Use the new deinstallation tool called deinstall available on the installation media before installation as well as in the Oracle home directory after installation. ./deinstall Checking for required files and bootstrapping … Location of logs /u01/app/oracle/ora Inventory/logs/ ############ ORACLE DEINSTALL & DECONFIG TOOL START ############ ######################## CHECK OPERATION START ######################## Install check configuration START Checking for existence of the Oracle home location /u01/app/oracle/SID/product/11.2.0 Oracle Home type selected for de-install is: SIDB Oracle Base selected for de-install is: /u01/app/oracle Checking for existence of central inventory location /u01/app/oracle/ora Inventory Install check configuration END Network Configuration check config START Network de-configuration trace file location: /u01/app/oracle/ora Inventory/logs/netdc_check627197374662265908Network Configuration check config END Database Check Configuration START Database de-configuration trace file location: /u01/app/oracle/ora Inventory/logs/databasedc_check6468731932053553666Use comma as separator when specifying list of values as input Specify the list of database names that are configured in this Oracle home [SID]: SID ###### For Database 'SID' ###### Single Instance Database The diagnostic destination location of the database: /u01/app/oracle/SID/admin/SID/trace/diag/rdbms/SID Storage type used by the Database: FS Database file location: /u03/oradata/SID/users/d1,/u03/oradata/SID/tools/d1,/u03/oradata/SID/indx/d1,/u03/oradata/SID/system/d1,/u03/oradata/SID/sysaux/d1,/u04/oradata/SID/undo/d1 Flash recovery area location: /u10/oradata/SID/flash/d1/SID database spfile location: /u01/app/oracle/SID/product/11.2.0/dbs/spfile The details of database(s) SID have been discovered automatically.

At the time of writing this guide, the following Linux package had been identified by the Unix team, oracleasm-2.6.18-128.4.1.0.1.el5-2.0.5-1.el5.x86_64 For example: Enterprise Edition for Linux Operating System (64-bit) linux.x64_11g R2_database_1of2: 1,239,269,270 bytes; cksum - 3152418844 linux.x64_11g R2_database_2of2: 1,111,416,131 bytes; cksum - 3669256139 linux.x64_11g R2_: 1,052,897,657 bytes; cksum - 3369676398 41. [[email protected] dbhome_1]# ./Running Oracle 11g script… The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: /usr/local/bin The file "dbhome" already exists in /usr/local/bin. Shutdown the database and run the following SQL script logged onto ASM alter diskgroup DATA drop file ' DATA/SID/system_01.dbf'; alter diskgroup DATA drop file ' DATA/SID/sysaux_01.dbf'; alter diskgroup DATA drop file ' DATA/SID/redo001a.dbf' alter diskgroup DATA drop file ' DATA/SID/redo002a.dbf'; alter diskgroup DATA drop file ' DATA/SID/redo003a.dbf'; alter diskgroup DATA drop file ' DATA/SID/redo004a.dbf'; alter diskgroup FRA drop file ' FRA/SID/redo001a.dbf' alter diskgroup FRA drop file ' FRA/SID/redo002a.dbf'; alter diskgroup FRA drop file ' FRA/SID/redo003a.dbf'; alter diskgroup FRA drop file ' FRA/SID/redo004a.dbf'; alter diskgroup DATA drop file ' DATA/SID/temp_01.dbf'; alter diskgroup DATA drop file ' DATA/SID/undo_01.dbf'; alter diskgroup DATA drop file ' DATA/SID/control01.ctl'; alter diskgroup DATA drop file ' DATA/SID/control02.ctl'; alter diskgroup DATA drop file ' DATA/SID/control03.ctl'; alter diskgroup FRA drop file ' FRA/SID/control01.ctl'; alter diskgroup FRA drop file ' FRA/SID/control02.ctl'; alter diskgroup FRA drop file ' FRA/SID/control03.ctl'; With 11.2 the Oracle Universal Installer no longer removes Oracle software. NOTES An error will occur if there are any missing deinstall files at which point the tool prompts you to download the standalone version available in the deinstall directory on the installation media The following output is example output for removing a standalone database and the related binaries.

Leave a Reply

method of documenting tracking and updating software licenses