Server Administration :: How To Check Oracle Database Uses Java Or Not

Jul 23, 2010

Actually in our environment , sysadmins are upgrading java versions on Unix (HP & Solaris) Machines and they have asked the query whether oracle database uses Java or not?

If it uses then all the databases need to be shut down for their planned activities and if not no need to shutdown the databases.

View 17 Replies


ADVERTISEMENT

Server Administration :: How To Check Whether Database Is Dedicated Or Shared

Feb 3, 2012

How to check whether database is dedicated or shared ?

View 1 Replies View Related

JDeveloper, Java & XML :: Best Driver For Java To Oracle Database Connection

Jul 30, 2012

Which is the best driver for java to Oracle database connection ?

View 1 Replies View Related

Server Administration :: Server Hang Very Often / How To Check Reason For Hanging

Mar 14, 2012

We a running oracle9i database and forms 6i application.

We have 4 gb ram size and sized the sga for 700mb pga for 400mb for past 4 months there is no problem.

Now from last week we encounter the server hang, and we do restart. How to check reason for hanging.what are all the check list to carried out.

View 19 Replies View Related

Server Administration :: How To Check ASM Is Used

Jul 8, 2010

How can I check whether the ASM is used in the environment? how I can check for it and if being used, how to connect to that instance later on.

View 5 Replies View Related

Server Administration :: How To Check Alertlog File

Mar 3, 2012

you have some 500 Db how will u check the alertlog file. do u do it manually or is their any tool to check the alertlog files. how to check it.

View 7 Replies View Related

Server Administration :: How To Check A Partition Have Been Compressed

Oct 20, 2011

How can i check a partition whether it has been compressed? just as flowing test,i can not get the information about partition P_L1 whether been compressed.

SQL> Select
2 aa.compression,
3 aa.partition_name
4 From dba_tab_partitions aa
5 Where aa.table_name = 'TB_HXL_LIST';

COMPRESS PARTITION_NAME
-------- ------------------------------
DISABLED P_L1
DISABLED P_L2
DISABLED P_L3
DISABLED P_L4

SQL> Alter Table tb_hxl_list compress;

Table altered.

SQL> Alter Table TB_HXL_LIST
2 Move Partition P_L1 compress;

Table altered.

SQL> Select
2 aa.compression,
3 aa.partition_name
4 From dba_tab_partitions aa
5 Where aa.table_name = 'TB_HXL_LIST';

COMPRESS PARTITION_NAME
-------- ------------------------------
ENABLED P_L1
ENABLED P_L2
ENABLED P_L3
ENABLED P_L4

View 5 Replies View Related

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

Jan 11, 2011

i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.

"The image file D: is Valid, but is for a machine type other than the current machine."

View 1 Replies View Related

Server Administration :: Quick Check On Hidden Parameter?

Mar 20, 2013

quick check on a hidden parameter? I need to know the default value and possible values for _serial_direct_read on various releases, I have only 11.2.0.3 available right now and I'ld like to know this for 11.2.x.x 11.1.x.x, and 10.2.x.x.

Below is the query that will show what it is currently which (unless you've changed it) will be the default: auto for my 11.2.0.3. Then to see the options, try to set it to something wrong, my options are false/true/never/auto/always. I think false/true were the only choices for 10.2 and are maintained only for compatibility. But I can't rememebnr 11.1.

orcl>
orcl> set lin 80
orcl> select KSPPSTVL from x$ksppcv join x$ksppi using (indx) where ksppinm='_serial_direct_read';
KSPPSTVL
--------------------------------------------------------------------------------
auto

orcl>
orcl> alter system set "_serial_direct_read"=rubbish;
alter system set "_serial_direct_read"=rubbish
*
ERROR at line 1: ORA-00096: invalid value RUBBISH for parameter _serial_direct_read, must be from among false, true, never, auto, always

orcl>
update: added 11.1.x.x to my wishlist

View 10 Replies View Related

Server Administration :: How To Check Error ORA-01555 / Snapshot Too Old

Dec 23, 2011

i am getting this error during expdp ORA-01555 -snapshot too old

1. i increased undo_retention i.e 50000

2. i execute expdp during late night when almost zero user is online so no commit from any other session.

3. we have a table having BLOB data type field in a table which is 500 GB in size.complete DB size is 700 GB

where and why this error exists.if corruption of BLOB so how to check that etc. the same error is occurring in three of our data centres during expdp.

View 4 Replies View Related

Server Administration :: Check Tables Located In Which Datafiles?

Aug 6, 2010

would want to check which tables located in which datafiles.

Tried with this command:
select B.FILE_NAME from dba_segments a, dba_data_files b
where a.header_file=b.file_ID and segment_name='TABLE_NAME'

Seems like it only shows 1 datafile. Some tables are large and i suppose it's resided in more than 1 datafile.

View 1 Replies View Related

Server Administration :: Check Free Extents In Tablespace

Apr 29, 2012

which data dictionary view would you query to see the free extents in a tablespace.

i use dba_free_space;

SQL> select tablespace_name,sum(bytes),sum(blocks) from dba_free_space where
tablespace_name = 'SYSTEM' GROUP BY TABLESPACE_NAME;

TABLESPACE_NAME SUM(BYTES) SUM(BLOCKS)
------------------------------ ---------- -----------
SYSTEM 9830400 1200

View 2 Replies View Related

Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client

Feb 13, 2013

I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.

1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?

SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'

View 3 Replies View Related

Server Administration :: Oracle 10g - Database Server Startup / Shutdown

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

Server Administration :: Oracle Database Server - Logon Denied

Jul 19, 2011

I am connected as System. It was the only user I set-up a password when installed the database on personal computer.

SQL> alter user sys identified by mypass007
2 /
User altered.
SQL> connect sys/mypass007
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

[code]...

SQL> conn sysoper/mypass007
ERROR:
ORA-01017: invalid username/password; logon denied

View 1 Replies View Related

Server Administration :: Check Status Of Listener And Read Only From DB Query?

Jun 13, 2010

I need to display the parameter and status of DB for listener and Read Only.

I know those value could be get from command line , but could we get the values of Listener and Read only by SQL/PlSQL? So I can get it through the query of DB.

View 8 Replies View Related

Server Administration :: How To Check Last Modification Date Of Resource_name In Profile

Feb 9, 2010

we have a few profiles in dba_profile. How to check what is the last modification date of the the resources inside each profile.

View 6 Replies View Related

Server Administration :: From Where To Download Oracle 9i Database Server

Aug 17, 2010

I have some requirement wherein I need to install Oracle 9i database server (9.2.0.7). I am not getting it on Oracle website. where can I get the download.

View 1 Replies View Related

Server Administration :: Submitting Job From Java Web Based UI - Getting ORA-01652?

Mar 13, 2013

I am getting ORA-01652 temp space issue.I read several posts before posting this and no luck.We are submitting the job from java web based UI where it builds dynamic sql to submit the job.The issue is not repeatable for the same input parameters i.e for the same sql.Some times it will run just fine with out issues for the same input params and sql.

Only way I can reproduce the issue when i submit the job twice and some times,both fails and some times one success and one fail, but not both success any time.The job usually returns few millions of records and takes about 1.5 hrs to run.

I tried to extract the generated sql and run from pl/sql developer from two different sessionsat the same time and it will just run with out issues in both sessions. I repeated thiscouple of times and success every time. Only issues when i submit from UI. Thereseems some thing going in the java code the way it submits, but not able to figure out.

We have plenty of temp space 300G. We monitored the temp space and it only takes about 4G whenit ran with out issues. We also monitored when the job fails as it keeps growing till it hit300GB and throws the table space error.We are using 11G version. Year ago we migrated from 10 to 11. But when the app developed, it is 9g.

View 8 Replies View Related

Server Administration :: Changing Of SID Oracle Database

Jan 3, 2011

i do know how change the database but can any one assist me how to chnage SID of database which in windows 2003 server?

View 1 Replies View Related

Server Administration :: How To Create A Database (Oracle 10g)

Jul 6, 2012

How to create own database in oracle 10g. I want to create new database in oracle.

View 10 Replies View Related

Server Administration :: Size Of The Oracle Database 11g?

Apr 21, 2010

how can we find the size of the oracle database 11g.

View 2 Replies View Related

Server Administration :: Creating New Database In Oracle?

Nov 10, 2010

how to create a new database in oracle??

View 2 Replies View Related

Server Administration :: Upgrading The Database To 11g From Oracle 8i?

Aug 27, 2013

I need to upgrade an oracle 8i database on HP-Unix server to Oracle 11g on Linux server, whether to upgrade it first to 10g linux and then to 11g ?

View 4 Replies View Related

Server Administration :: How To Get Tables In Oracle 10g Database

Dec 13, 2010

I have installed oracle 10g software and created Database on RHEL 4. when i run the run.sql its successively done but im not getting tables. whats the prob.

View 17 Replies View Related

Server Administration :: Oracle Database 12.1.0.1.0 No Emctl?

Aug 1, 2013

installed and configured oracle 12.1.0.1.0 on linux and i noticed there is no emctl? I went through the oracle docs and i see no references as what to use,

View 12 Replies View Related

Server Administration :: Upgrade 9.2.0.8 Database In Oracle 11.2.0.2

Sep 21, 2011

I am trying to upgrade the oracle 9.2.0.8 database in oracle 11.2.0.2. I have installed the new oracle home for 11g and after running the pre-upgrade script and setting the all environment variable like oracle base, oracle home, oracle sid and ora_nls

i am running the dbua but after click on finish button it's do the processing of 2% but after that i get
-------------------------------------------------
ORA-12709 error while loading create
database character set
--------------------------------------------------

View 11 Replies View Related

Server Administration :: Oracle 11gr2 Database And 11.1 ASM

Jun 26, 2012

I have oracle 10g running on oracle ASM 11.1, I want to know that if i install oracle 11gr2 database , can i use oracle 11.1 ASM which is already installed ?

View 5 Replies View Related

Server Administration :: CPU Usage By Oracle 10g Database

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

Server Administration :: Default Count Of Oracle 11g Database

Mar 6, 2011

I installed Oracle 11g and created a test database in that the default count should be 4196... but it is 4143.. some packages are missing.. even when i'm creating materialized view it is showing some error that packages are missing. what can i do for that? Is my oracle s/w corrupted ? even when i downloaded from oracle site it also shows the same count.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved