See If PMON Or SMON Running On Windows Server?
Feb 27, 2013On windows server how can we see if the PMON or SMON is running? Is there a way, as we can see on linux using?
View 6 Replies
ADVERTISEMENT
PMON Failed To Acquire Latch / See PMON Dump
Jun 19, 2012When i am trying to shutdown the database its getting HANG, and alert log showing
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Which force me to use Shutdown Abort.
DB version in 10.2.0.1.0
OS Linux 5.5
Windows :: Unable To Delete SMON Trace File?
Oct 4, 2012In my database smon tracefile was huge,now we want to delete the same,I also tried with ordebug operation but no use, delete tracfile which Smon generates.
View 5 Replies View RelatedCons Of Running 8 Production Database Instance On One Windows Server
Dec 3, 2010We are planning to consolidate our Oracle Production DB into one server. We are basically a windows shop. Is it feasible to run 8 production Oracle DB in one windows server. All the DB are not really transaction intensive DB. 2 DB in the size of 300GB and others all DB falls under average size of 40GB.
I can take care of the HD slicing so Oracle does not enter into IO bottleneck. We are planning to go for external NAS or SAN for storage.
My main concern is on processor usage. The processor we are thinking about is Intel Xeon Quad Core x 2nos. Will there be a processor bottleneck or is there way in Oracle to assign processor usage(I belive there is no much tweaking options here)
Windows :: ORA-12154 - Running 32 Bit Oracle Software On Server 2008 64 Bit
Oct 6, 2011There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.
Since all the 32 applications will have the path C:Program Files (x86) on 64 bit windows, The PATH variable doesn't recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client. Still the user is facing the same issue.
Oracle Client: 10.2.0.3 32 bit
Windows OS: Windows server 2008 R2 64 bit
I have referred document [ID 334528.1] from the metalink(which states that the bug is fixed in 10.2.0.3 client).
How To Create Central Inventory For Oracle 11g Running On Windows Server
Dec 26, 2012--- Current Oracle Inventory pointing to the location of C:program FilesOracleInventory.
We are plannig to creat a central inventory for all Oralcle installations into to C:oraagentorainventory.
Server Administration :: Foreground Process Starts Before PMON
Feb 7, 2012Details of my site is as below:
database version: 11.2.0.1.0
OS version:
Microsoft Windows Server 2003
Standard Edition
Service Pack 2
the day before yesterday when my database bounce i m facing with the following error.
ksuapc : ORA-1033 foreground process starts before PMON
Server Administration :: PMON (failed To Acquire Latch) During Shutdown
Aug 29, 2010I found in alert log that PMON "failed to acquire latch" during shutdown.What it means and how to rectify the same.
View 2 Replies View RelatedServer Administration :: DB Shutting Down Automatically By Terminating Smon Process
Dec 22, 2010I have a db on 10.2.0.1 and it's going down automatically after some time with the error in alert log file smon process terminating.
View 3 Replies View RelatedWindows :: Test If Database Is Running?
Sep 15, 2010I have a unix script that will check if the database is up and running. I need a similar script but this time in windows batch file.
this is the snippet of the code from the unix script:
#! /bin/sh
sqlplus -s /nolog > /dev/null 2>&1 <<EOF
whenever sqlerror exit failure
[Code].....
Forms :: Running Reports 6i On Windows 7?
Nov 2, 2009would like to check if anybody running Form/Report 6i on Windows 7 ? I meant not XP mode.
View 3 Replies View RelatedORA-12154 Running 32 Bit Oracle Software 0n 64 Bit Windows?
Oct 7, 2011There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.
Since all the 32 applications will have the path C:\Program Files (x86) on 64 bit windows, The PATH variable doesnt recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client.
Oracle Client: 10.2.0.3 32 bit
Windows OS: Windows server 2008 R2 64 bit
I have referred the below document from the metalink(which states that the bug is fixed in 10.2.0.3 client).
ORA-12154 or ORA-6413 Running 32-bit Oracle Software on 64-bit Windows OS [ID 334528.1]
Forms :: Running Oracle Database 10g On Windows 7
Nov 12, 2009I was install windows 7 on my computer,oracle database10g and forms 10g installed successfully. I Cannot run forms on the browsers , how i can run my programs
View 9 Replies View RelatedWindows :: Error When Running Macro Excel
Jan 13, 2012I installed Oracle 11gR2 database for windows 7. I believe it's 32 bit. I keep getting an error when I run my macro excel: Error while trying to retrieve text for error ORA-01019.
View 1 Replies View RelatedSMON Not Clearing Up Some Transient Types
Dec 5, 2010All nodes in RAC environment are available.But sessions are not load balanced for one/some of them.
Checking alert log the following oracle errors can be found:
alert_<INSTANCE>.log
ORA-21779: duration not active
ORA-06512: at line 1
The root cause of the problem is SMON that is not clearning up some transient types.
I've noticed this effect in Oracle 11g release 1, but there is a chance it happens for early Oracle versions.
Startup SMON Process Will Do Instance Recovery
May 7, 2013we 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 RelatedWindows :: Installing 10g Database Software On Windows 2008 Server?
Sep 28, 2010I've tried to install Oracle 10gR2 (10.2.0.4.0) on Windows server 2008 (64 bit). I just click on installer and a message appears:
Checking Operating system version: must be 5.0,5.1,5.2 or 6.0
Actual 6.1
FAILED <<<<
Exiting Oracle Universal Installer
Press any key to Exit.
Windows :: Installation Of 10g R2 On Windows Server 2008?
Sep 30, 2010I want to install Oracle 10g R2 on Windows Server 2008.
View 22 Replies View RelatedServer Administration :: How To Know Currently Running Databases In Single Server
Jul 30, 2010I have installed three database in MY Linux server. I have started Instance for all database and started database also .
No I want to check my databases status or currently running database How can I know . Or which Dynamic View or Database dictionary I should use ?
Reports & Discoverer :: Reports Not Running In Windows 7?
Jan 4, 2012We have Forms and Reports 6i which is perfectly running its reports in windows xp pc and even in windows 98 pc.
But recently we have installed windows 7 64 bit, but the reports not working here.
Running Rootpre.sh On Server?
Aug 6, 2012We are about to upgrade Os from IBM AIX 5.3 to IBM AIX 6.1 .
My Plan is :
1.Shutdon Database .
2.Os upgradation from IBM AIX 5.3 to IBM AIX 6.1 (IBM Admin)
3.Run "rootpre.sh" and find system requirements .
4.Install required filesets for AIX 6.1
5.Verify all system requirements .
6.Startup database .
----------------------------------------------
I want to know that , is it required to run "rootpre.sh" after OS migration ?.Cos we run this script if we go for fresh Oracle Software Installation .my case software is already installed .
Server Administration :: Job Not Running On Defined Schedule
Jul 24, 2012I migrate schema with data from oracle 10gR2(Windows) to oracle RAC 11gR2 (Linux).My JOBS are created but they are not running on defined schedule. but they run manually successful.
----script of my job are as below --------
BEGIN
SYS.DBMS_SCHEDULER.DROP_JOB
(job_name => 'JHON.TAX_IT);
END;
/
[code]...
Server Administration :: Dba_jobs Stopped Running
Feb 19, 2011I have a dba_job that is scheduled to run every hour and for the past couple of weeke it is behaving strangely. It fails running every alternate hour. I have checked the alert log whenever it fails but nothing is reported in the alert log. The job is not broken.
View 4 Replies View RelatedServer Administration :: Why Oracle Scheduler Is Not Running
May 14, 2013Why Oracle shceduler is not running.What could be the cause.
CREATE TABLE dept1 AS SELECT * FROM dept;
CREATE OR REPLACE
procedure update_record(p_deptno number)is
BEGIN
insert into dept1 values(p_deptno,'xxx','xxx');
end;
[code]....
Server Administration :: ORA-01034 While Running Dbca
May 27, 2011I hv created a database VAHAN with SID VAHAN , now I want to create another database in it with name SARATHI SID SARATHI.VAHAN db is running perfectly but everytime i tried to create the db with dbca it shows error "ORA-01034: ORACLE not avaiable."
I ran dbstart,lsnrctl start - getting same error..i dbshut the db and use startup nomount - getting same error.
DBCA Not Running On HPUX Itanium Server
Jan 30, 2013I have installed oracle software on HPUX IA server.After installation, I am trying to create the database using database template through DBCA.After setting database name , password, database file location and sga size on DBCA, DBCA not initializing the database creation after clicking "Finish" button and does not give any error though.I have tried multiple times but not able to create db using specific template using DBCA.
View 10 Replies View RelatedServer Utilities :: Running Export Utility Online
May 26, 2010Just want to confirm if I can run the export (command line) even if the database is up (online)? Are there any risks/impact while doing so?
View 7 Replies View RelatedServer Administration :: DBMS Scheduler Jobs Are Not Running
Jan 12, 2011I have scheduled few jobs (scheduled for each day) which has not run today, which was running successfully till yesterday. When I query dba_scheduler_jobs, i could see last_run_date as yesterday's date 6am and next_run_date is still showing today's date and time (it should show tomorrow's date/time).
View 3 Replies View RelatedServer Administration :: Running DBCA In Silent Mode
Jan 27, 2012I'm trying to run dbca in silent mode and works perfect, this is how the code look like:
dbca -silent -createDatabase -templateName Transaction_Processing.dbc -gdbName test.mydomain -sid test
-sysPassword passoracle -systemPassword passoracle -emConfiguration LOCAL -dbsnmpPassword passoracle
-sysmanPassword passoracle -characterSet WE8ISO8859P1
-initParams "open_cursors=500"
The problem is when I specify more than one initialization parameter in -initParams. If I try something like
-initParams "open_cursors=500, parallel_max_server=0"
Then I get this error Exception in thread "main".
Server Administration :: Session Inactive But Running Queries?
Mar 4, 2010I am using 10.2.0.4 oracle database on Solaris 10. We are running some Peoplesoft upgrade on one of the database from last 6-7 hours. The status of the session is INACTIVE from couple of hours. And the sql_id is null for these sessions.
select sid,serial#,STATUS,to_char(logon_time,'DD-MON_YY HH24:MI:SS') from v$session where username like '%&usern%' ORDER BY 4 DESC;
533 2234 INACTIVE 04-MAR_10 01:59:02
525 5919 ACTIVE 04-MAR_10 01:54:50
534 4186 INACTIVE 04-MAR_10 01:05:15
520 2320 INACTIVE 04-MAR_10 00:29:44
[code].....
While when i see the current sql from the v$active_session_history, it keep on changing after every 10-15 minutes. Using below query to find the sql_text for the session from v$active_session_history.
select sql_id, sql_text
from v$sql
where sql_id in (
select sql_id
from v$active_session_history
where session_id=511
[code].....
We have not faced issue like this during Peoplesoft upgrade. what could be the reason that the status is not changing while the base sqls keep on changing after every 10 minutes.