Oracle 10g - Creating Library Management System Using Struts 2

May 18, 2011

i am creating a library management system using struts 2.i have a form that display a table having column(bookname, author, publisher,..etc) and it contains an operation "edit book" with each row. now i m stuck with an update query(or any other query) by which i can edit an entire row (or any column) onclicking the edit button.i'm using oracle 10g database.

View 2 Replies


ADVERTISEMENT

Backup & Recovery :: Failed To Load Media Management Library

Jun 30, 2012

i just run the command

RMAN> crosscheck backup;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 06/30/2012 14:25:12
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library

RMAN> configure default device type to disk;

old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # defa
[code]....

View 2 Replies View Related

How To Make System Table Space Extent Management Dictionary

Dec 21, 2010

I want to create system table space's extent management dictionary with the syntax:

CODEcreate database
logfile
group 1 ('/u01/app/oradata/anand/redo1a.log') size 100M,
group 2 ('/u01/app/oradata/anand/redo2a.log') size 100M,
group 3 ('/u01/app/oradata/anand/redo3a.log') size 100M
datafile '/u01/app/oradata/anand/system.dbf' size 400M extent management dictionary
sysaux datafile '/u01/app/oradata/anand/sysaux.dbf' size 300M
default temporary tablespace temp tempfile '/u01/app/oradata/anand/temp.dbf' size 50M

but it is giving error
ERROR at line 6:
ORA-25141: invalid EXTENT MANAGEMENT clause

how can I make system tablespace's extent management dictionary?

View 3 Replies View Related

Automatic Storage Management :: Create Database First Before Creating ASM

Oct 14, 2013

Sun Solaris 10, Oracle 11gr2 x86 How are you doing?  I am trying to build a test system.  I never build ASM before.  if I need to install database first then Migrating to ASM?  The other problem I am having is that I only have a Raw disk.  I have one disk for root and oracle and the other one for Raw disk for ASM.  Do you know it's possible to build ASM on 1 raw disk? 

View 3 Replies View Related

Automatic Storage Management :: Configure Row Device To Usable For Creating New Diskgroup

Jul 4, 2012

I want to configure row device to usable for creating new asm diskgroup.we are using ASM. Steps to configure that row device to available for creating new diskgroup.

View 2 Replies View Related

SQL & PL/SQL :: Creating A Flight Booking System

Dec 1, 2010

i am trying to create a flight booking system,i am at the stage of creating the tables but am having trouble with creating one of the tables

CREATE TABLE Seat
(Seat_no NUMBER(3) CONSTRAINT PK_Seat PRIMARY KEY,
Class_Code CHAR(2) CONSTRAINT FK_Class_Code FOREIGN KEY (Class_Code) REFERENCES Class(Class_Code)
CONSTRAINTS CHK_Class_Code CHECK(Class_Code='EN' OR Class_Code='FS')
(Class_Code is a primary key in the table Class)

It comes up with an error saying ORA-02253: Constraint specification not allowed here and if i put a coma after the first constraint it says the name already used for an existing constraint.

View 18 Replies View Related

Security :: Creating Wallet - System Does Not Prompt For Password

Apr 14, 2011

I'm trying to hide the password for the batch programs that connect to the DB Server

as Cadot pointed out in

[URL].........

Quote:
use secure external password store

with reference to

[URL].........

when I create wallet, the system does not prompt me for password

C:>mkstore -wrl "C:ora102NETWORKADMIN" -create

when creating login credentials, again the system never prompts me for password

C:>mkstore -wrl "C:ora102NETWORKADMIN" -createCredential db10g scott tiger

here's my sqlnet.ora configurations

WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY =C:ora102NETWORKADMIN)
)
)
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSESSL_VERSION = 0

here's my tnsname.ora settings

DB10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mike)
)
)

here's the outcome

C:Documents and SettingsAdministrator>sqlplus /@db10g
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Apr 13 22:53:06 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:
ORA-12534: TNS:operation not supported

Enter user-name:

so I Google around for the solution to the ORA-12534 error, one of the site,

[URL].......

here's my lsnrctl services

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "MIKEXDB" has 1 instance(s).
Instance "mike", status READY, has 1 handler(s) for this service...
Handler(s):
[code].....

The command completed successfully

right now I think I will be a fool to think that the solution is to resolve the ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. so what is wrong with my setup, or is it some patch that I need to apply?

View 9 Replies View Related

Server Administration :: Minimum Datafile Size Required For Creating Non-system Tablespace?

May 21, 2007

what is the Minimum datafile size required for creating a non-system tablespace?

I am trying to create a tablespace by giving the syntax like,

SQL> create tablespace t1
2 datafile '/home/data/t1.dbf' size 72k;
create tablespace t1
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required

SQL> create tablespace t1
2 datafile '/home/data/t1.dbf' size 73k;

Tablespace created.

The blocksize for my database is 4096, as i have heard that the minimum size of the datafile is decided by blocksize, but i want to know that how it is calculated as by giving the above syntax the other values will be default. I am trying the syntax in oracle 9.2.0.1.0 version.

View 13 Replies View Related

Oracle SQL - Query A Large Library File?

Dec 1, 2008

I'm currently new to Oracle 10g SQL and I need to query a large library file.I need to find the different first keywords associated with references written by authors who have more than 10 references in the readings table.

View 4 Replies View Related

Call Interface :: What Oracle 9.2 Installation Use To Have OCI Library Header Files

Sep 6, 2012

There are only OCI headers in 9.2.0/rdbms/demo directory in our installation of Oracle 9.2:

9.2.0/rdbms/demo/ocixad.h
9.2.0/rdbms/demo/oci.h
9.2.0/rdbms/demo/oci1.h
...

In Oracle 10.2 installation there are OCI headers in rdbms/public directory:
10.2.0/rdbms/public/ocidem.h
10.2.0/rdbms/public/ocidfn.h
10.2.0/rdbms/public/ocikpr.h
10.2.0/rdbms/public/oci.h
10.2.0/rdbms/public/oci1.h
...

What should be installed additionally to have OCI headers in rdbms/public in Oracle 9.2.0?

View 0 Replies View Related

Precompilers, OCI & OCCI :: Multithread Program Hangs In Oracle Library On Itanium

May 13, 2005

my Multithread-Program hangs in an oracle library while passing a prepare statement (also if i try an EXEC SQL SELECT statement...). Something seems to be wrong in the Program, but i cant's find the Error.The Program is build with:

proc parse=none code=cpp mode=oracle hold_cursor=yes maxopencursors=20 THREADS=YES sqlcheck=full iname=Precomp_all.pc oname=Precomp_all.h

problem: a first thread creates the connection to oracle with one global context (type sql_context) in the connection object:

connect()
{
EXEC SQL WHENEVER SQLERROR DO ORASQL_ERROR();
EXEC SQL WHENEVER SQLWARNING DO ORASQL_WARNING();
EXEC SQL WHENEVER NOTFOUND DO ORASQL_NOP();
[code]....

View 3 Replies View Related

Control Existence Shared Library In Memory Space To Define Real Need Of Shutting Down Of All Oracle Instances

Feb 7, 2013

according to article "Installing Netbackup for Oracle agent on Unix". URL.... Shut Down all oracle instances on this client. The reason: sometimes Oracle will take a shared library (such as ours) and place it into its shared memory spaceMy question is how I can control existence shared library in memory space to define the real need of Shuting down of all oracle instances ? I'm usung 11.2.0.3

View 4 Replies View Related

9i - Login With Oracle Management Server

Aug 1, 2008

i have install 0racle 9i its working fine .I can access data from launch standalone but when i tried with login to oracle management server i can't login .

how can login with oracle management server .

View 1 Replies View Related

Client Tools :: Oracle User Management

Oct 11, 2011

I'm looking for a basic password reset / unlock tool for use at a help desk. Environment is mixed 10 and 11G. Current procedure is log into specific database using SQL Plus and manually type out reset/unlock commands.

View 10 Replies View Related

Enterprise Manager :: Backup In Oracle Management Server

Dec 6, 2009

when i want to do backup in oracle management server for my database (repository)that i created give me an error message

<< using perferred credentials , the following error occurred: ORA-01031 :insufficent privileges>>

View 1 Replies View Related

Automatic Storage Management :: Build ASM In Linux Box Oracle 11g?

Dec 28, 2012

I have a Linux box with the below configurations:-

Linux blrulvremoradb02 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

Last time my UNIX administrator have done a partition in this box. I have 100GB lun allocated to this box which is spilitted in two mount points.

/u01 is having 30GB and /u02 is having 70GB. I want to build a ASM in this box and install Oracle 11.2.0.1 and for that I need raw disk.

Is there any useful links or can you guide me to achieve this... My UNIX admin is on leave for new year and I want to do this by my own..

View 5 Replies View Related

Server Administration :: How Oracle Implements Undo Management

Jul 31, 2010

I have been reading various articles about the undo management. This basic concept of undo management is simple but how oracle implements it is bit harder for me to grasp.

What i have read and understood is that whenever a DML(Update, Delete, Insert) statement is issued by a user, the data is fetched from datafile to database buffer cache and at the same time a copy of the original data is saved in undo segment. Now if other users requests the same data, they are presented with the unchanged copy in the undo segment.

Now I have the following questions:
1) In case of Insert statement, what data is saved in undo segment. Is it the complete data in the table to which we want to insert the new row?
2)When the user issues DML statement, there are three copies of the same data, one in Memory (which is changed and not the same as original data), second in Undo segment (Which is unchanged copy of original data) and third in datafile file ( which is original data). What is the difference in the data in undo segment and data in datafile at this stage. Why are the other users presented with the data from undo segment rather than original data from the datafile to maintain read consistency.
3)When the user issues rollback, the changes made to the copy of data in memory are undone.The copies of data in memory and undo segment are now same?. What happens to the before change copy in undo segment. Is it still there or deleted.

View 5 Replies View Related

Replication :: Management Tool In Oracle Enterprise Manager Console?

May 31, 2013

I am not finding Replication Management Tool in Oracle Enterprise Manager 10g. Where can i found it?

How can I start Oracle Enterprise Manager Console? I have installed Oracle Enterprise Manager Control.

View 5 Replies View Related

Automatic Storage Management :: Cannot Start ASM On Oracle Database Appliance

Apr 11, 2013

I cannot start ASM on my Oracle Database Appliance.

crsctl status resource -t says:
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started

however, if I try to access the ASMCMD it says:
[grid@node1 ~]$ asmcmd
Connected to an idle instance.
ASMCMD> startup
ORA-00304: requested INSTANCE_NUMBER is busy
Connected to an idle instance.

View 13 Replies View Related

Automatic Storage Management :: Oracle ASM Create-disk Failed?

Oct 25, 2012

I am using 11.2.0.1.0 on RHEL 5.4ASM is properly working on my machine. database is running from ASM. I want to configure additional oracleasm devices.command fails saying:

$ oracleasm createdisk ASMDISK08 /dev/xvd8
Writing disk header: done
Instantiating disk: failed
Clearing disk header: done

I am creating asm diskgroup on loopback devicesHere are the configured loopback devices.

[root@host1 ~]# ls -l /dev/loop[1-9]
brw-rw-rw- 1 oracle oinstall 7, 1 Oct 25 14:42 /dev/loop1
brw-rw-rw- 1 oracle oinstall 7, 2 Oct 25 14:42 /dev/loop2
brw-rw-rw- 1 oracle oinstall 7, 3 Oct 25 14:42 /dev/loop3
brw-rw-rw- 1 oracle oinstall 7, 4 Oct 25 14:42 /dev/loop4

[code]...

I am unable to understand where is the problem.

View 11 Replies View Related

Cloud Service :: Installing Oracle Management Agent In 11g Database (11.2.0.3)?

May 6, 2013

Error occurred, While installing the agent in 11g database.
Error is listed below

[oracle@grid agent]$./agentDeploy.sh AGENT_BASE_DIR=/ebiz/oracle RESPONSE_FILE= agent.rsp
AGENT_BASE_DIR=/ebiz/oracle
Validating the OMS_HOST & EM_UPLOAD_PORT
Executing command : /ebiz/oracle/core/12.1.0.1.0/jdk/bin/java -classpath /ebiz/o

[code]./..

Executing agent install prereqs... Executing command: /ebiz/oracle/core/12.1.0.1.0/oui/bin/runInstaller -ignoreSys rereqs -prereqchecker -silent -ignoreSysPrereqs -waitForCompletion -prereqlogl c /ebiz/oracle/core/12.1.0.1.0/cfgtoollogs/agentDeploy -entryPoint oracle.sysma .top.agent_Complete -detailedExitCodes PREREQ_CONFIG_LOCATION=/ebiz/oracle/core 12.1.0.1.0/prereqs -J-DORACLE_HOSTNAME=grid.4iapps.com -J-D

[code]...

View 5 Replies View Related

Enterprise Manager :: 11g Management Agent Deploy Errors On Oracle 10g R2 4 Node RAC

Sep 6, 2010

I have been facing issues deplyong OEM 11g agent on Oracle 10g Target databases. I have installed OEM Agent 11g which is functioning perfectly. Now i am trying to deploy management agent 11g on Target databases which are a Oracle 10g RAC system of 4 node on Oracle enterprise linux 64 bit. Below is the error log..

-----------------------------------------------------------------
BLUE1DB-> ./runInstaller -silent -responsefile /opt/Agent11g/sysman/agent_download/11.1.0.1.0/linux_x64/response/additional_agent.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 150 MB. Actual 1463 MB Passed
Checking swap space: must be greater than 150 MB. Actual 32767 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-08-24_09-42-37PM. Please wait ...BLUE1DB-> *** Check for updates ***

[code]...

View 2 Replies View Related

Automatic Storage Management :: Oracle ASM Normal / High And External Redundancy?

Jun 27, 2013

, I have a few doubts in Normal,High and External redundancy levels in ASM concept. External - No failure group. No mirroring. Normal - Two Way Mirroring. One failure group. High - Three Way Mirroring. Two failure group. 1.

above mentioned 3 types in correct.2. My main question is what is the minimum number of disks needed in Disk group creation in Normal and External redundancy??

View 3 Replies View Related

Forms :: Difference Between System.current_item And System.cursor_item?

Apr 1, 2012

We have system.current_item and system.cursor_item.....

both represent the same....

like this we have few other system variables also .....

what is the main difference between current_item and cursor_item?

View 2 Replies View Related

CPU System Time (percentage) For Multi Core System?

Aug 21, 2012

couple of questions about below parameters, do they measure single processor or avg usage across all processorss and cpus for example will i recieve alert if CPU system time goes above 95% for single processors? or not

CPU Idle Time (%)
CPU System Time (%)
CPU User Time (%)

View 1 Replies View Related

Automatic Storage Management :: Disk Is Not Displaying - Install Oracle Grid Infrastructure 11r2?

Jul 1, 2012

i try to install oracle grid infrastructure 11r2 on cent OS 4.8 on vmware workstation 8.0.2..ASM disk is not showing ,i had also change disk discovery path to 'ORCL:*'i had already configure ASM disk using /etc/init.d/oracleasm createdisk...successfully..

View 8 Replies View Related

Windows :: Oracle 8i On XP System

May 12, 2002

i have installed oracle 8i on my windows xp system. it has not given me any problems during installation. i could log on to oracle and work on it without any problems. but when i restarted my system, my system has failed to start the oracle service, and i could no longer logon to sql * plus.

I've got messages 'oracle not available'. i've even tried to start the service from administrative tools-services, but of no use. then i created a new database and log on to sql* plus. but when i rebooted my system, the problem continued.

View 33 Replies View Related

Server Administration :: OFA And Raid System For Oracle

May 5, 2011

Can I use OFA and Raid system together for Oracle 11g in Windows 2008 Server? I am installing the OS in C drive. Where to install the oracle, location for Oracle_Base, number of logical and physical drive required, size of each etc.

I am planning to use
Raid 1 - Controlfile, redolog file and archive log file
Raid 1+0 - Datafiles

Also I want to multiplex virtual memory page also.

View 6 Replies View Related

Oracle 11g R2 On Windows 2008 R2 - Cannot Login As SYSTEM

May 31, 2013

I created an empty database using the DB Configuration Assistant, then imported a dump file provided by a client. I believe what happened is that all of the user passwords (for SYSTEM, SYSDBA, etc.) which I had created in the DB Config Assistant were overwritten during the import process as I can no longer log into the DB.

I have attempted logging into sqlplus using the /as sysdba swith while logged in to the server as a user in the ORA_DBA role, but I still get the ORA-01031: insufficient privileges message.

I am running Oracle 11g R2 on Windows 2008 R2.

View 4 Replies View Related

Reports & Discoverer :: Customized System On Oracle 10g

Jun 30, 2011

I have customized system on oracle 10g ( English interface and reports ) , the company want to make the system in both (Arabic and English) , i make every thing is okay , but the problem when i change the PDF subset in the file uifont.ali to include Arabic fonts , the report server every 2 hours stopped and give me the message ( server is in progress ) ,

View 1 Replies View Related







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