Search results for query: *

Is there any difference in tns and listener conf for oracle 8i on windows 2000 and NT server. I have installed oracle 8i on NT where it is working fine and just now I have installed Oracle 8i (same version) on win2000 on a machine and I have given the same name to global database name which I...

Hi I have got a problem. I have java program which calls a oracle stored procedure and it works fine if output is single row. We can use cursor in procedures to display output on SQL> but this does not work for Java program. In Java program I am using PrepareCall() to execute the stored...

How can I write a trigger or function which will notify a java object about a particular event on a database table. First of all is it possible to refer any java object through SQL Amol New to dba world, so please ......

Hi all This is a query related to change in the password of internal. I am working on Oracle 8i (8.1.6) on Windows NT. I want to set up password for internal user for my own machine to prevent users from using Oracle DB Access as admin. For this I have used exact procedure told Oracle in...

Hello Everybody I am working as Oracle DBA in an organisation which specialises in E-biz and Network Management Solutions. Now as per policy decision they have decided to specialise in Network Management Solutions. Earlier I was working with E-biz. As a whole I don't have any idea where DBA...

Hello Everybody I am working as Oracle DBA in an organisation which specialises in E-biz and Network Management Solutions. Now as per policy decision they have decided to specialise in Network Management Solutions. Earlier I was working with E-biz. As a whole I don't have any idea where DBA...

Hello Friends This may not be a question related to this forum but since I have been a member of this for a long I would like to ask this. Currently my organisation has divesified and took projects related to Network Management and product development for Networks. Since earlier I was working...

Hello Friends I have a query related to backups and recovery operations. I am currently operating windows Nt Server with Oracle 8i. I have set Database in ArchiveLog Mode with automatic archival enabled. I have set log_archive_dest_1 and 2 in 2 different drives. Now As I see In both the...

Hello I would like to know whether I can see history of users logged in in oracle for a past few days. Currently our oracle has installed at remote server and I am accessing it using database links from my local oracle. If I want to who has logged on 2 days back and for what time how can I know...

Hello Can anyone tell me how set oracle two tier architecure in oracle 8.1.5 on linux. I have installed it but do I have to make changes in any of the paramaters. A lot of people said me that for effective connection pooling and processes handling for a B2B database two-tier will be more useful...

Hello Everybody I don't know how to implement Multi threaded Server for a B2B database. Do I have to Install Oracle Again for it or can I change it by adding some parameters. Is there any other way which I can really have the solution to the problem of connection pooling from the database side...

The Processes parameter in my init.ora file is set to 200. By Default it was 50. It became inadequate and started giving error of 'maximum no of processes exceeds' even after 10 users accesssing it by a web server. This database is for B2B site . I have changed this parameter to 200 and...

Hello I have windows nt with oracle 816 on it and a remote linux server with oracle 815 on it. To access the remote server I have created an alias in my local tnsnames.ora file and I can access that server by specifying user@alias way. I have a oracle user named 'mserd' on my remote server . I...

Hello I have made the following setup in my NT init.ora file however the last log archive format is commented. Do I have to uncomment It ? Initially log_archive_start was false and no destination directories. These are added by me. I have to ask after setting database into archivemode and...

I am trying for online backup My settings are Database Log Mode -- Archive Mode Automatic Archival -- Enabled While taking the backup of tablespaces and I the script I used Alter tablespace users begin backup; host ocopy80 d:\oracle\oradata\mydb\users01.dbf h:\backup\user01.bak...

Hello I have Oracle database 8.1.6 on windows NT Server named 'ODBK' I wanted to create a new database for my another project. I have just created a new database in Oracle using DBCA. First I shut down the database using SVRMGR and then entered 'STARTUP NOMOUNT' I have created this database...

I have just now installed Oracle 8.1.5 on Linux (Red Hat 6.2) I have got a database created in it. I was able to add records in table only when I uncommented the parameter 'Rollback Segments = R01 R02 R03 R03 R04 R05'. I will have to modify the parameter 'Processes' to 200 which is currently...

If I have created a new database on my machine and I have mounted that new database, However I want my default database running as well which is currently down by me only for creating new database. Now How can I make my default database mount when this new databse is already mounted. I need both...

Can anyone help me on how to use vsize function to calculate memory occupied my each record. I need syntax. Thanks in advance Amol

I want create table which are of follwing type A Small size faster growth B small size slow growth C BIg size alow growth D Big size big growth Do I keep these table in above group in same tablespaces or some of A group in one tablespace with some tables from other groups I am On Oracle 8.1.6...