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. […]
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 […]
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 […]
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 […]
Oracle Enterprise Manager DB Console is a somewhat independent software but attached under Oracle database. For some reasons, sometimes it cannot be started, or it can be started but show a piece of message like this: The database status is currently unavailable. It is possible that the database is in mount or nomount state. Click […]
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′ […]
In my experience, to create a new database by DBCA with silent mode in a 9i database on Linux, you must issue the dbca command under a x-window environment, otherwise, you will get “java.lang.NoClassDefFoundError”, even you set CLASSPATH correct. I think it maybe a bug on Linux platform.But the most ironic thing is, if you can […]
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 […]
Creating a database by DBCA is easier than scripts. But there will be less control over the database details, thus, some incompatible parameters with your policies can only be changed after the creation.In silent mode, you have to profile the database in advance by two ways:With response file: you must edit a response file before […]
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 […]
