check out jim melton's paper "Database Catalog Tutorial -Open Forum 2003 on Metadata Registries" at ...
Mark C. Stock
mcstock@...
Nov 1, 2004 7:23 pm
605
I did rebuild the indexes over the weekend and that did not help. I have reloaded a copy of the database that is about a month old on a server that I can test...
Hi, My production database 8.1.7.4 is on solaris 2.6 box. I have to upgrade my OS to 2.9. OS and Oracle (8.1.7.4 32 bit) have been already installed on target ...
Roshy, Hi. I think you have most of it but am not sure it will work. Oracle create other processes. I would recommend trying: 1. shutdown production database....
Allen Shepard
ashepard@...
Nov 3, 2004 1:34 am
608
No, this is not possible. Oracle binaries are different. Thanks HM ... From: "roshykum" <roshykum@...> Reply-To: VOUGlist@yahoogroups.com To:...
HIMANGSHU DEY
hdey@...
Nov 3, 2004 1:35 am
609
I am sure this will work. Although the Oracle binaries are compiled as 64 bit vs 32 bit and they are different, oracle database files (datafile, redologs and...
Kumar, Subodh
subodh.kumar@...
Nov 3, 2004 2:33 am
610
Can anyone tell me if it's worth using 64 bit oracle on solaris? We're presently using 32 bit on 64 bit machines. Will there be any benefits ? Thanks. ...
Steff Gonos
steff_gonos@...
Nov 4, 2004 3:53 pm
611
Having 64 bit Oracle run on 64 bit solaris is supposed to give you performance boost as your wordsize is 64bit. In short, it will take one pass to move 64 bit...
Kumar, Subodh
subodh.kumar@...
Nov 4, 2004 6:51 pm
612
Subodh, Yes 64 bit should be faster. When moving from 8 to 16 bit and then the last big change of moving from 16 bit to 32 bit there where some problems. Data...
Allen Shepard
ashepard@...
Nov 4, 2004 9:28 pm
613
When we moved from 32 to 64 bit, the only issue we faced was of memory. The memory requirement went up significantly. We have PA_RISC chips. No AMD experience...
Kumar, Subodh
subodh.kumar@...
Nov 5, 2004 10:00 am
614
Hi guys, I've been away from Oracle for awhile but have a job op. next week. I just installed 8i Lite on my laptop to brush up a little and am having trouble...
Alan Kirchner
akirchner@...
Nov 5, 2004 10:04 am
615
Akirchner, Hi. You are welcome. Yes, adding the new oracle will require adding it to TNS names. As a security feature new databases are not automatically...
Allen Shepard
ashepard@...
Nov 5, 2004 7:18 pm
616
Subodh, Hi. You are welcome and thank you for the information from a real life experience, Memory - I would have missed that one. Metalink has some articles on...
Allen Shepard
ashepard@...
Nov 5, 2004 7:18 pm
617
Alan: I think it is not the password problem. You are not getting connected to your instance because of some problem in TNSNAMES.ORA file. You have to edit...
Mano Devamanoharan
devamanp@...
Nov 5, 2004 7:18 pm
618
Hey Allen, Are you specifying a host name at login? If there is only one db on the system, you should be able to login without it. A TNSNAMES error usually...
Robertson Ludwig H CO...
robertsonlh@...
Nov 5, 2004 7:18 pm
619
Does anyone have a good tuning script for Oracle 9i databases that they would share with me? Thanks, Bill Buker, M.D.B.A. Total Resource Management 1435...
Hey Bill, Tuning is such a broad area, that it's difficult to "can" scripts for it. I used to use a bunch of scripts to watch tablespace growth, shared pool...
Robertson Ludwig H CO...
robertsonlh@...
Nov 11, 2004 4:53 pm
621
Hey, I need some advice on how to encrypt the database password and possibly the username within an shell script. Right now, I have it hardcoded and need to...
Phillip Small
psmall57@...
Nov 12, 2004 6:54 pm
622
Look into using an account that is externally identified. This is a lot easier than trying to encrypt or hide the password. ...
Brett Ogletree
bretto97@...
Nov 12, 2004 10:31 pm
623
Phillip, if you are using unix there are a couple of ways to do this. For instance in a csh/tcsh script that reads the information from a file and passes it...
Rick Raughton
raughton@...
Nov 15, 2004 4:01 pm
624
Phillip, If using Oracle applications and calling shell through a concurrent process, you can put ENCRYPT in the options field in the concurrent program define...
Where would this ENCRYPT keyword be placed? Is it placed in the shell script where the data or sql code is written? I have my code in one file and a separate...
Phillip Small
psmall57@...
Nov 15, 2004 11:57 pm
626
Phillip, The ENCRYPT option is if you are using The Oracle Applications (like AR/AP, HR...) not just the DB. Bob...
Where should the sqlnet.log be located ? I am finding that there are multiple copies of it, in some different directories - what does that tell me ? Thanks. ...
Steff Gonos
steff_gonos@...
Nov 16, 2004 9:21 pm
628
From that directory the client made a connection to the database, where the file was generated. Normally, it is created since the connection gets a failure. ...
Li, Joseph
Joseph.Li@...
Nov 17, 2004 2:03 pm
629
It gets created in whatever was the current working directory for the tool that used Oracle Net. I believe that you can configure it to go elsewhere, but I'll...
Thanks to this group I successfully installed 8i personal and connected to database. I then proceeded to install the developer suite successfully but for some...
Alan Kirchner
akirchner@...
Nov 18, 2004 8:11 pm
631
+ Interjection by listserv moderator: + Several helpful replies to this posting concatenated + below to help everyone's inboxes clean! - Craig ... From: "John...
Hi friends, We just migrated Oracle8i into Oracle9i and Oracle web server. How do I connect to the Oracle database and oracle web server if it is installed ...
Jim, Using MS Active Directory credentials is a requirement that a lot of people have had. As of yet, I have not heard of an architecture to directly use AD...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
