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 Ken Thanks . I got the answer for my problem. What you have said is true but there is no need for 3 functions. This can be done using ref cursor. Please go thru http://govt.oracle.com/~tkyte/ResultSets/index.html Amol New to dba world, so please ......

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...

'Select * from user_indexes' will not serve purpose rightly as it will display all the columns unncessarily. Instead of this you can use USER_IND_COLUMNS. It looks like you know the index name , the table and column name can be found in this view. For other details see the USER_INDEXES view. I...

Well I know these files are used for a rollforward operations in recovery. Please tell me can I delete those files at the end of day because I am not using I am currenlty on just a desktop server which is used only for development, not for implementation Amol New to dba world, so please ......

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...

Thanks Michael Well I think my knowledge was wrong in this case, which was from some other book, Because I got some responses from some other forums that there is no such limit of 300. Depending on youe RAM and other resources you can increase this limit to more. Thanks Again for your...

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...

I dont have PARALLEL_MAX_SERVERS parameter set im my init.ora file . Is the problem with web server's connection pooling ? My setting is Linux with Oracle 8.1.5 . The server is dedicated server. Can I run Dedicated server for B2B site or do I have to change setting. I will be greatly thankful...

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...

Thanks Karluk I have another query based on above Currently I have 3 destinations supplied for backup as above in my Windows NT Oracle Machine. When Explore thru the files I found that the sizes of files are very much different. Currently I am just running a trial database where very few data...

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...