Initialization Parameter

How to Resolve ORA-02097: Parameter Cannot be Modified Because Specified Value is Invalid

Posted on
When you ALTER SYSTEM to modify an initialization parameter, it sometimes fails with ORA-02097 ORA-02097: parameter cannot be modified because specified value is invalid Reproduce ORA-02097 Let’s me show you some examples that can reproduce ORA-02097 and I will explain it more detailed along with the context. Here I would like to change DB_RECOVERY_FILE_DEST location. […]
Installation and Upgrade

How to Create a 9i Database by DBCA with Graphic Interface

Posted on
It seems that running DBCA with GUI will hang at some specific steps under x-window environments, therefore, we should avoid to step on the traps during creating a database.Before you create a new database by DBCA with graphic interface, you should check the environmental variables are correct.[oracle@oracle9i ~]$ echo $ORACLE_BASE/u01/app/oracle[oracle@oracle9i ~]$ echo $ORACLE_HOME/u01/app/oracle/product/9.2.0Since the fields […]
Installation and Upgrade

How to Resolve ORA-27302 Failure Occurred at

Posted on
After creating another database by DBCA on the same server, I found the first database started up successfully, but the second one failed to startup.[oracle@oracle9i ~]$ sqlplus /nolog…SQL> conn / as sysdbaConnected to an idle instance.SQL> startupORA-27154: post/wait create failedORA-27300: OS system dependent operation:semget failed with status: 28ORA-27301: OS failure message: No space left on […]
Performance

How to Monitor Real-Time Top SQL on CPU Consuming

Posted on
You can identify the most cpu-consuming SQL statements from database memory by querying v$sql.cpu_time, but they are not real-time data, they are history data. If we want real-time data, there is an indirect way can identify the real-time SQL statements on cpu consuming. First, collect the most cpu-consuming process id on OS-level, then map these process […]
Archived Log File

How to Archive Redo Logs to Respective Local Destinations of RAC

Posted on
For a RAC database, we may want to archive the redo logs to local destinations of instances rather than ASM. That is, put instance #1, #2 archive thread #1, #2 redo logs to their respective local destinations. To achieve this goal, LOG_ARCHIVE_DEST_1 should be setup more granularly by sid like this way:SQL> alter system set log_archive_dest_1=’location=/oracle/oradata/arch1′ […]
Installation and Upgrade

How to Install Oracle 9i Database on Enterprise Linux 4

Posted on
Here I show my experience on the steps to install 9.2.0.4 and patch it up to 9.2.0.8 on Enterprise Linux 4.4. In general, Oracle 9.2.0.4 is easy to be installed with the type of a standalone database.Determine the domain, hostname and IP address.[oracle@oracle9i ~]$ vi /etc/resolv.confsearch example.comnameserver 168.95.1.1[oracle@oracle9i ~]$ vi /etc/sysconfig/networkNETWORKING=yesHOSTNAME=oracle9i.example.comGATEWAY=192.168.0.1[oracle@oracle9i ~]$ vi /etc/sysconfig/network-scripts/ifcfg-eth0…IPADDR=192.168.0.151NETMASK=255.255.255.0NETWORK=192.168.0.0…Add a […]
Installation and Upgrade

Creating a 11g Database Manually by Scripts (3/3) – Configure local naming and password file for outside users

Posted on
Creating a 11g Database Manually by Scripts (2/3) – Create and check the new databaseEven though the database is created, but it has not been connected from outside. You should configure an entry of local naming for the new database on application servers or client machines.Add a service naming on a client machine.On Windows platform, use […]