The following is the solution .
The spfile parameter LOG_ARCHIVE_DEST was set to LOG_ARCHIVE_DEST=” !
So "SHOW PARAMETER" is showing nothing but in the spfile you can see the difference!
ALTER SYSTEM RESET LOG_ARCHIVE_DEST SCOPE=BOTH SID=’*’;
or
Change in init.ora
Oracle DBA Checklist Version 1.7 Generic This document is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. For a copy of the GNU General Public License write to…
Solution for mount problems facing on AIX? Facing Errors like below? Have you ever tried mounting a shared folder existing on Solaris or Linux machine to a AIX machine ? While doing so most of us will see the below kind of error. So to solve this problem the solution is this post. bash-3.00# mount…
Installation The NetBackup client software must first be installed as the root user. (for versions 6.x and earlier you also need to install the Oracle RMAN NBU client extension (add-on) as well). The NBU client and Oracle extension should both be at the same version, and no higher then the version of the media…
How to change the SYSADMIN password at E-Business Suite 11i. 1. run the apps environment. 2. cd $FND_TOP/bin 3. FNDCPASS apps/*** 0 Y system/manager USER SYSADMIN new_password Tip: Check the request log to see if it is completed successfully. You must use at least 6 characters long and not repeated. Check Metalink Note ID: How…
Silent Installation of Oracle database Preface This paper is for silent installation of Oracle Database Practice and Experience of the process of recording. Installation of 10g of silence which is conducted in RHEL AS3U4, 9i silent installation practice is in Windows XP Professional (SP2) on the. 9i installed three common CD-ROM, Oracle installing customized specifically…
The following are simple steps to change the ORMI default port in Oracle Warehouse Builder. Navigate to OWB_HOME\bin\win32 and run ccashut.bat(in case OC4J is already running). Next navigate to OWB_HOME\owb\jrt\config\rmi.xml file look out for rmi-server tag for port and ssl-port attributes. Change the default non-ssl port 23791 and ssl port 23943, to any port which…