Encrypting Oracle Stored procedures
Dear All, Can anyone please tell me how to encrypt oracle stored procedures Thanks Regards, Brijesh __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Installation oracle through responsefile
Hi All I am trying to install oracle 8.16 in non-interactive mode(silent) mode. However installation does not proceed and fails I am giving following command runInstaller -silent -responsefile /oracle/response/ ee_typical.rsp However in /tmp/silentInstall.log I get following error No forced value specified for the variable ORACLE_HOME, associated with property ToLocation, in dialog oracle.sysman.oii.oiif.oiifw.OiifwInstLocWCDE This silent installation was unsuccessful. Warning :*** Alert: Do you really want to exit? *** I have done following setting in ee_typical.rsp UNIX_GROUP_NAME=dba #FROM_LOCATION;String;Used in Dialog #Full path for the products.jar file. FROM_LOCATION=/data1/cdrom1/stage/products.jar #ORACLE_HOME;String;Used in Dialog ORACLE_HOME=/oracle/product/8.1.5 Can anyone please help in solving this problem Thanks for the help in advance Regards Brijesh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Importing data from dump exported with different character set
Hi All I have been given the task to export the data from the database which has the character set of USASCII7 and import it into Databse with UTF8 character. However when I try to this the import fails with error. I also searched oracle mannual but was unable to find any relevant information. Can anyone please tell me how to accomplish this task Thanks and Regards Brijesh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple databases under the same ORACLE_HOME
Yes it is possible to have mutiple under same oracle home in windows nt. The only thing to do is just go to console and type set oracle_sid=new_sid then create the database with this new sid and thus u can have two databases runing at same time on windows nt --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: Multiple databases under the same ORACLE_HOMEIf it is the same installation it is under the same home, it's just a different SID. Aren't I right on this? Kev -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andrey Bronfin Sent: Monday, June 18, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Subject: Multiple databases under the same ORACLE_HOME Dear list ! Is it possible to create multiple databases/instances under the same ORACLE_HOME on NT ? If yes , what should be done (create services etc..) ? Thanks a lot in advance for your answer. __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Installing oracle remotely
Hi Is it possible to install oracle 8i from remote site say thru telnet. What i know is oracle 8i installation is gui based. I tried a lot but was not able to install remotely. Can anyone help me in solving this problem. Also if it is possible to install oracle remotely please tell me how to do it. Regards Brijesh __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Reco background process problem
Hi I have problem in starting the oracle8i database. It is installed in intel solaris 8. After booting solaris I am able to start databse. However when I shutdown and start the database it gives the error that reco background process did not start. The databse doesnot even go to nomont stage. To restart databse I only have to reboot the machine. Can anyone please help me in solving this problem Thanks and Regards Brijesh __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORACLE 8i DBA
Hi Go for Oracle Certified professional DBA certification Exam guide By Jason S couchman Ulrike Schwinn This is one of the best for for ocp exams it contains lot of practice exams and is desinged for OCP only Other than this for crampsession u can go to brainbuzz.com site here u can find cramps neaded for OCP preparation and above all refer Oracle manuals they are the best for exam preparation Good luck Brijesh --- Deewaker G.V. [EMAIL PROTECTED] wrote: hi I am planning to take ORACLE 8i DBA Examination, Can you guys please guide w.r.t 1) Good Book to Refer 2) Steps to Prepare for all the 5 Papers 3) Cramsessions 4) Free downloadable Power Point Presentations If you feel some more which i need to gear up with. Kindly advice me with warm regards, Deewaker G V __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Formula to calculate physical memory
Hi Can anyone please tell me the formula to calculate physical memory required for the system if size of the database is known. The size of database I am going for is 1 terabytes. The number of users are 70 it is a dataware house server. I am going for 8 CPU's . Now i want to know the physical memory for this setup. The response I need is 3 seconds for two-dimensional query and the record size is 10 GB. Can anyone suggest physical memory required for this configuration. Thanks Brijesh __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Formula to calculate physical memory
Hi Can anyone please tell me the formula to calculate physical memory required for the system if size of the database is known. The size of database I am going for is 1 terabytes. The number of users are 70 it is a dataware house server. I am going for 8 CPU's . Now i want to know the physical memory for this setup. The response I need is 3 seconds for two-dimensional query and the record size is 10 GB. Can anyone suggest physical memory required for this configuration. Thanks Brijesh __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: No listner and tns packet error
Everything u have specified set correctly it was network problem as specified by jared and I was able to solve the problem. Thanks for ur help Brijesh --- Behar, Rivaldi [EMAIL PROTECTED] wrote: If ping is Ok and listener is running, try using IP address in your tnsnames.ora instead of machine name. Rivaldi -Original Message- Sent: Tuesday, May 01, 2001 3:10 PM To: Multiple recipients of list ORACLE-L Did you include this database in your listener.ora file? Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 01, 2001 12:30 PM Hi I am facing one funny oracle failure. If i try to connect the client machine to linux oracle8i server I receive the error no listner. However when I see at linux server the listner is altready running.Again after sometime when I try to connect to oracle server I get same error for some time and then I get TNS packet failure error. After sometime I get connected to oracle server and then get disconenct after few minutes and again I get the same error no listner. I am totally puzzled with this problem can anyone help me in solving me this problem Looking forward for response from u all Brijesh __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
No listner and tns packet error
Hi I am facing one funny oracle failure. If i try to connect the client machine to linux oracle8i server I receive the error no listner. However when I see at linux server the listner is altready running.Again after sometime when I try to connect to oracle server I get same error for some time and then I get TNS packet failure error. After sometime I get connected to oracle server and then get disconenct after few minutes and again I get the same error no listner. I am totally puzzled with this problem can anyone help me in solving me this problem Looking forward for response from u all Brijesh __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Multimaster Replication setup
Hi I am trying to setup multimaster replication environment. I have two machines. On on windows NT and one on linux. I followed all the steps listed in oracle8i Api reference manuals till chapter 3. But when I update emp table. It corresponding updations are not reflected in second database. Can anyone please help me in setting up of replication server. Also can anyone tell me sites giving Complete steps for setting up replication server. I am here not going for snapshot site I am just trying for multimaster replication Regards Brijesh __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dictionary information
Hi The view v$fixed_table will give u all x$ table information Brijesh --- Seema Singh [EMAIL PROTECTED] wrote: Hi Which dictionary table is used to see all X$ tables. Thnaks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Datafile needs media recovery
Hi Since ur database in in archive log mode you can go for following method also just move your datafile to some other place. This is just for backup. Now create a new datafile based on existing datafile using following command alter database create datafile'old_datafile_name+path' as 'new_datafile_name+path' where old_datafile_name+path will be the path and name of ur orginal datafile which u have renamed and new_datafile_name+path will be the name and path u desire Then perform media recovery for that new datafile using recover datafile 'new_datafile_name+path' This method is basically used to recreate and recover damaged datafile However for this u must have all archive log files since orginal datafile was created Hope so this may help u Brijesh --- "Cale, Rick T (Richard)" [EMAIL PROTECTED] wrote: Hi All, Oracle 8 running in Archivelog One of my coworkers said they did the following: 1. Added a datafile to a tablespace 2. Took datafile offline and renamed at OS 3. ALTER DATABASE RENAME ... to new name 4. Attempted to bring datafile back online and get file needs media recovery. Tried to alter database recover automatic and other options but does not work. This is all the info I have does anyone have any suggestions on why it needs media recovery and how he can get it back online. We cannot drop the tablespace and rebuild. We could maybe export all objects in that tablespace then rebuild. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle8i Installation problem on Linux
Hi I was problem of installing oracle 8i on Linux 7.0. The problem came during database creation after net 8 configuration was sucessful the installation got hanged at 80% of database creation Thinking of going for mannual installtion I killed the databse assistant wizard and tried to go for mannual databse creation however I am able to bring instance in nomount stage also the process hangs and after long time error comes that end-of-file on commincation channel. I saw error file also but this did not solve my problem. Can anyone please help me in solving this problem. The configuration of my PC is oracle 8.1.6 128mb RAM 256 MB swap space IBM PIII processor Regards Brijesh __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle8i Installation problem on Linux
Hi I was problem of installing oracle 8i on Linux 7.0. The problem came during database creation after net 8 configuration was sucessful the installation got hanged at 80% of database creation Thinking of going for mannual installtion I killed the databse assistant wizard and tried to go for mannual databse creation however I am not able to bring instance in nomount stage also the process hangs and after long time error comes that end-of-file on commincation channel. I saw error file also but this did not solve my problem. Can anyone please help me in solving this problem. The configuration of my PC is oracle 8.1.6 128mb RAM 256 MB swap space IBM PIII processor Regards Brijesh __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).