CPU Usage On Server Steadily Grows After Instance Startup
Mar 4, 2013
We have Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production on AIX platform. We've noticed that the CPU usage on the server is slowly but steadily grows since instance restart: after the instance restart the maximum CPU usage is about 25-30%, and a month later with the comparable transactional load it's about 60-65%. In the top I see a lot of Oracle sessions each of which use about 1% of CPU, so I cannot find the one "CPU eater".
View 4 Replies
ADVERTISEMENT
Jun 24, 2010
Find an appropriate script to automate Oracle DBs in one server? This db server have 6 instances. We always done the starting up and shutting down manually, although we have a reference script that does this but in Oracle v7.3.4. We do want to include the automatic start/stop of dbconsole for accessing it via OEM.
View 1 Replies
View Related
May 7, 2013
we have given shutdown abort to a database.At the next startup SMON process will do instance recovery. If it contains committed as well as uncommitted transactions on what basis or how the SMON process will roll forward or rollback the transactions and from where it will get these informations or data?
View 4 Replies
View Related
Jul 19, 2012
I am running ORACLE 10.2.0 on Windows Virtual PC. System: Microsoft Windows XP SP3.
Yesterday I wanted to make a copy of my Virtual Machine Hard Drive Image. I directly copied all the files to my external hard drive, but I forgot shutting down my virtual machine when I was doing this.
Today I found my instance failed startup.
In OEM, it is showing:
Agent Connection to Instance
Status: Failed
Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
In SQLPlus:
SQL> connect sys/password as sysdba
Connected to an idle instance
SQL> startup
ORACLE instance started.
[code]....
View 3 Replies
View Related
Oct 29, 2010
Our database size is 100GB and i removed few records from a table and rebuild the index.The size of Index reduced considerably after Index rebuild but now i see our database size increased to 115GB.I know online rebuild creates second index which is also removed after the build is finished then why the increase in database size?Is there a way so it shows up more space ?
select sum(bytes) from dba_segments where owner='abc' and segment_name='abc_index_1';
8GB
ALTER INDEX abc_index_1 REBUILD ONLINE ;
select sum(bytes) from dba_segments where owner='abc' and segment_name='abc_index_1';
2GB
View 6 Replies
View Related
Mar 16, 2011
My context on our servers is the following one:
- one ASM instance
- X DB instances
- each DB instance uses 2 or more dedicated diskgroups from the ASM instance
- there is one diskgroup named FREEDISK that contains spare disks
On each DB instance you can see:
- the list and global parameters of all diskgroups using v$asm_diskgroup view
- the list and parameters of all disks the instance is using with v$asm_disk view
So my question is: how (if this is possible) to know the list of (spare) disks in FREE DISK disk group?
View 6 Replies
View Related
Jun 29, 2011
I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.
View 5 Replies
View Related
Sep 21, 2010
I have installed oracle 11g Release 11.1.0.1 on windows server 2008.I access this server from a client machine running on winXP through SQL PLUS. I wanted to shutdown and start DB server from this client machine. Accordingly i issued shutdown immediate command from SQLPLUS.
Now when i tried to start the DB with "STARTUP NOMOUNT" command i received error 12514. I understand this error means that the listener received a request to establish connections to a database but since DB services are not up and running, hence the error. So my first question is how do I resolve this error.
Continuing further, i tried to re-connect to the database as sys, and i received another error ORA-01041. So, my second question is why did i receive this error and again how can i resolve it
may be you can point me to relevant reference in Oracle documentation) how can i start and stop oracle from a client machine using SQL interface in CLI mode and windows environment and avoid this error.
View 12 Replies
View Related
Jun 28, 2013
Is their any query to find cpu usage & memory usage of all the queries currently running on DB?
View 5 Replies
View Related
Apr 27, 2010
MY oracle database is not starting ,at startup its giving me following error message .
ORA-00600: internal error code, arguments: [kccext_info_4], [], [], [], [], [],[], []
Alert Log file showing following message ,
Tue Apr 27 14:22:26 2010
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Tue Apr 27 14:22:26 2010
ARC1: Becoming the heartbeat ARCH
Tue Apr 27 14:22:26 2010
db_recovery_file_dest_size of 2048 MB is 36.88% used.
This is auser-specified limit on the amount of space that will be used by thisdatabase for recovery-related files, and does not reflect the amount ofspace available in the underlying filesystem or ASM diskgroup.Tue Apr 27 14:22:27 2010Errors in file h:oracleproduct10.2.0adminorcl4udumporcl4_ora_3704.trc:ORA-00600: internal error code, arguments: [kccext_info_4], [], [],
[code]...
If i connect with scott user ,following message occurs ,
ORA-01033: ORACLE initialization or shutdown in progress
View 2 Replies
View Related
Dec 17, 2011
FRM-92101...There was a failure in the Forms Server during startup. this could happen due to invalid configuration. Look into the web-server for the details.
Details...
Java Exception:
Oracle.forms.net.ConnectionException:Forms Session<74> failed during startup: no response from runtime process
at oracle.forms.net.HTTPNStream.getResponse(unknown source)
at oracle.forms.net.HTTPNStream.doFlust(unknown source)
[code]....
View 3 Replies
View Related
Sep 3, 2010
While running the test form test.fmx available in DevSuiteHome_1 ools , I get the follwing error :-
FRM - 92101 There was a failure in Forms server during startup. This could happen due to invalid configuration.
I have tried to install the software many times after deinstalling but no success. However the same software has been installed on other machines too and is working absolutely fine.
View 1 Replies
View Related
Feb 22, 2008
i just compile all the forms on linux server and creatge a envirement in formsweb.cfg file and create my test.env file.
then when i run OC4J and starting my application. it gave me following error
frm-92101 There was failure in forms server during startup this could be happen due to invalid configuration look your web server log file for details.
i also attached the screen shot, you can see it in attachment.
View 4 Replies
View Related
May 30, 2013
i have one problem when i make any changes in my any existing reports or just i recompile the existing report after that when i open this report its give me
error
Quote:•FRM-92101: THERE WAS A FAILURE IN THE FORMS SERVER DURING STARTUP. THIS COULD HAPPEN DUE TO INVALID CONFIGURATION
View 2 Replies
View Related
Jun 20, 2011
im new to DBA.i installed oracle on my pc but im not able to startup database...im manually creating database ..CRD files r still not created as im unable to startup nomount..im getting this error.
SQL> startup nomount
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel
i almost worked on this for 10 days but im getting the same error...
View 39 Replies
View Related
Apr 1, 2009
I want to shutdown the database using shutdown immediate and startup the database using startup mount.
1.)My system is client system if I connect start--> program -->Accessories --> communication --> Remote Desktop connection (connect server system) , open Run type cmd after
Shutdown immediate (database is shutdown)
Startup mount (database is mounted no problem it's working fine)
2.) But if I, open Run type cmd in client system If I run same command, I'm getting below error (ORA-12560: TNS:protocol adapter error).
C:>set oracle_sid=dbadb
C:>sqlplus / as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on ╘± ╠ß± 31 18:09:27 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
[code].....
3. If I run same command in Sql Plus I'm getting below error(ORA-12514: TNS:listener does not currently know of service requested in connect descriptor).
SQL*Plus: Release 10.1.0.2.0 - Production on Ôñ Ìáñ 31 18:23:13 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
[code].....
View 14 Replies
View Related
Nov 16, 2012
how many rows created (replaced ?) und stored in v$object_usage on each fact of index scan? I'm using 11.2 version of database server
View 7 Replies
View Related
Aug 16, 2012
I have three oracle 10g databases (db1, db2, db3)on a linux box.
A command at the OS level to find total cpu used by each of the above databases.
View 12 Replies
View Related
Jan 12, 2011
I searched the knowledge base here and in other forums and haven't found the answer. There was a similar condition presented earlier, but it turned out the resolution was to run the >shutdown/>startup on the server rather than from a client. Not applicable in my case!
Shutdown and startup called used to work with 9i, now startup fails in 10g. ORACLE_HOME and ORACLE_SID are set and report correct values. What is different in 10g that the script (shown below) now throws a TNS listener error after shutdown?
I successfully upgraded from 9i to 10g (10.2.0.5.0) on Windows Server 2003, 32-bit last weekend. Now our backup_script.bat and oracle_stop_start.sql throw "ORA-12514: TNS:listener does not currently know of service requested in the connect descriptor"
This batch file and sql script predate me and worked with 9i for years. Now the startup command in the oracle_stop_start throws this error after executing shutdown. The backup batch file calls:
sqlplus "system/manager@wind as sysdba" @D:ptcwindchillackupsoracle_stop_start
The entire oracle_stop_start.sql is as follows:
shutdown immediate;
startup open;
quit
What is different in 10g that this now doesn't work? Shutdown works, but it will not startup due to the listener error. I have made the backups work by commenting out the call to sqlplus and I'm getting good backup dumps.
In my virtual image of the server I have found that I can duplicate the error after >shutdown. I have found that if I exit sql*plus and go back in as follows I can get the database instance to restart from the command line:
c:>sqlplus /nolog
sql>connect sys/* as sysdba
sql>startup open wind;
That does start, mount and open the database instance.
Is there a better way to be making sure that everything is stopped before executing the >exp command to create a backup dump? I will look into and test datapump export/import and RMAN for creating the backups, after I get this working again.
why this worked in sql*plus in 9i but not in 10g? Can I make TNS Listener smarter? Change or add variables to the startup command?
View 2 Replies
View Related
Jan 26, 2013
I have a RAC 48 cores on solaris. I check dbconsole when application performance is very slow and everyone complains, and I see that the main wait is cpu - also on the awr report. however when I check server cpu I see about 80% idle! so how can I make oracle use more cpu power instead of waiting for it? I don't think that parallel is an option here because I can't change the application code.
View 2 Replies
View Related
Feb 8, 2011
I successfully created a DB manually with PFILE.
I want the DB to startup with SPFILE at next login.So i fired the below command.
CREATE SPFILE='path/SPFILEPRAGAT.ORA' FROM PFILE='path/file.ora'.
But it shows the error as below:
ORA-01078: failure in processing system parameters
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (os 123) The filename, directory name,or volume label syntax is incorrect.
View 20 Replies
View Related
May 25, 2010
I am looking for a script to find the tbs usage including datafiles. Tablespaces Datafile Size Used Free Used% Free% Max MB
Need all the data in MB and all the datafile space in every tablespace.I have searched internet,but couldn't find this type of format.
View 9 Replies
View Related
Sep 22, 2010
We performed image copy of production Oracle server (OS and instances) to a backup server. After a few weeks, we try to restore a latest Oracle database backup from production server to backup server. As we know, Oracle instance must be unique on the network.
Even we log on to backup server and bring up the instance, I think that still point to production instance since all init file, TNSNAMES.ora and listener file are still same. If we restore the database, we will end up bring down the production instance and restore on top of productions. How to change instance name on backup server including TNSNAMES, sqlnet, listener files in order for us to restore Oracle database from production to backup server?
View 2 Replies
View Related
Sep 22, 2010
We imaged production Oracle Server ( OS and Oracle and everything) to a backup server. I guess my question shall be how do we access the local instance via this backup server. When we log on to this backup server, we ran sqlplus and connected to the instance but it ended up to connect to production instance. Shall we stopped local Oracle services and change init.ora, tnsname, or listener files in order not conflict with production instance?
View 1 Replies
View Related
Jul 1, 2010
Is it possible to use oracle dataguard from single instance to RAC instance ? Does Oracle dataguard support this ?
View 1 Replies
View Related
Sep 8, 2013
[oracle@localhost /]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Sun Sep 8 19:10:30 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
--------------------------------------
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '/home/oracle/app/oracle/product/11.2.0/dbhome_2/dbs/'
ORA-27037: unable to obtain file status
Additional information: 5
What seems to be a problem here? I've been trying to fix this for few weeks.
View 24 Replies
View Related
Jul 15, 2010
I am learning to create an ASM (Automatic Storage Management) instance using dbca.
View 3 Replies
View Related
Apr 29, 2013
How to create DBMS_SCHEDULER job for particular instance,we have 3 instance we want to schedule few jobs in Instance 2,how to schedule in Particular instance.
View 3 Replies
View Related
Sep 28, 2011
I've to install Oracle 10g on Solaris 10, Sparc. I prepared anything successfully, but, when I gone to create ASM instance, I found the Create new bow did not show any disks into. I take brief something:
1- Sparc & disks preparation:
# isainfo
sparcv9 sparc
# ls -lL /dev/rdsk/c4t50060E800570B715d0s6
crw-rw---- 1 root sys 336, 14 Sep 28 14:08 /dev/rdsk/c4t50060E800570B715d0s6
# ls -lL /dev/rdsk/c4t50060E800570B715d2s6
crw-r----- 1 root sys 336, 62 Sep 28 14:09 /dev/rdsk/c4t50060E800570B715d2s6
# ls -lL /dev/rdsk/c4t50060E800570B715d3s6
[code]....
Those 6 partitions disks above were supplied to ASM, so, I make mknod to link them.
# ls -lrt /asmdisks
total 0
crw-r--r-- 1 oracle dba 336, 110 Sep 28 15:35 disk6
crw-r--r-- 1 oracle dba 336, 94 Sep 28 15:39 disk5
crw-r--r-- 1 oracle dba 336, 78 Sep 28 15:39 disk4
crw-r--r-- 1 oracle dba 336, 30 Sep 28 15:39 disk3
crw-r--r-- 1 oracle dba 336, 14 Sep 28 15:39 disk2
crw-r--r-- 1 oracle dba 336, 62 Sep 28 15:39 disk1
Well, I go to ASM, but And nothing on Available Disk Groups.
View 2 Replies
View Related
May 11, 2011
Getting the below message even after doing the
oracle@ttlwaurd001:~$ ps -ef | grep pmon
oracle 7779 1 0 Feb08 ? 00:00:07 ora_pmon_WGRGOLD1
oracle 10155 1 0 Feb20 ? 00:30:48 ora_pmon_DPTLS01
oracle 12354 1 0 Feb20 ? 00:00:53 ora_pmon_DOEMS01
oracle 17902 1 0 Feb20 ? 00:00:13 ora_pmon_DREPS01
oracle 23745 23360 0 19:51 pts/4 00:00:00 grep pmon
oracle@ttlwaurd001:~$
oracle@ttlwaurd001:~$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Wed May 11 19:49:54 2011
Copyright 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
oracle@ttlwaurd001:~$ echo $ORACLE_SID
DPTLS01
View 15 Replies
View Related
