Question on Oracle Server 10g Install (.../oracle/oracle/.....
I am in the last stages of installing Oracle Server 10gR2 Enterprise Edition on a UNIX AIX server. When window "Execute Configuration Scripts" comes up it tells me to execute "/u01/app/oracle/oracle/product/10.2.0/db_1/root.sh". The ".../oracle/oracle/..." stops me cold. I look back in my notes and everything I wrote suggests I had entered ".../oracle/product/....." for my ORACLE_HOME. I look at the install log in /u01/app/oracle/oraInventory/logs and see: "INFO: Setting variable 'ORACLE_HOME' to '/u01/app/oracle/oracle/product/10.2.0/d b_1'. Received the value from the command line." Did I really key /oracle/oracle/ instead of /oracle/ or did the OUI change the path for some reason????? Thank you, Bill bfogarty@gaports.com wrote: > I am in the last stages of installing Oracle Server 10gR2 Enterprise > Edition on a UNIX AIX server. When window "Execute Configuration > Scripts" comes up it tells me to execute > "/u01/app/oracle/oracle/product/10.2.0/db_1/root.sh". > > The ".../oracle/oracle/..." stops me cold. I look back in my notes and > everything I wrote suggests I had entered ".../oracle/product/....." > for my ORACLE_HOME. I look at the install log in > /u01/app/oracle/oraInventory/logs and see: > "INFO: Setting variable 'ORACLE_HOME' to > '/u01/app/oracle/oracle/product/10.2.0/d > b_1'. Received the valu...

Installing oracle 9i and oracle 10g in one solaris 10 server
Hi All, Is it possible to install oracle 9i and oracle 10g in one solaris 10 server? Thanks Ed Ed <arub11@yahoo.com> wrote in news:61dc863c-fde2-426b-adc7-c77de59a1703 @n33g2000pri.googlegroups.com: > Hi All, > > Is it possible to install oracle 9i and oracle 10g in one solaris 10 > server? > Most definitely in seperate directory trees On Jul 26, 11:33=A0am, "Ana C. Dent" <anaced...@hotmail.com> wrote: > Ed <aru...@yahoo.com> wrote in news:61dc863c-fde2-426b-adc7-c77de59a1703 > @n33g2000pri.googlegroups.com: > > > Hi All, > > > Is it possible to install oracle 9i and oracle 10g in one solaris 10 > > server? > > Most definitely in seperate directory trees With different oracle users used for installation? Any other info. you may have to keep in mind during the installation of both versions of oracle? On Jul 26, 2:28=A0pm, Ed <aru...@yahoo.com> wrote: > Hi All, > > Is it possible to install oracle 9i and oracle 10g in one solaris 10 > server? > > Thanks > Ed You install them into separate oracle homes. Do the 9i first and patch then 10g and patch is simplest. You should double check 9i I "think" it is supported by oracle for solaris 10. The installer might get a little weird worry about os patches and pre-reqs not sure. The 10g install is pretty clean. You can do both installs using the "same" oracle user and group definitions or you could...

Oracle 10g 10.0.2 client, to connect oracle 8 server
Dear Group members, I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and 8i it is working very good with the 9i and 10g.. when i trying to connect 8i server ./. it giving error <b> "ORA-03134: Connections to this server version are no longer supported." </b> Can i install, 2 or more version of oracle clients in same system, becoz .. currently using client software is well configured for some SQL server BI agents, if i un-install current 10g client, it will infect my software .. process.. if, it can be possible, what kind of things i take care, before installation .. What is the best oracle client software can suitable for most of the server's On Jul 27, 11:58=A0pm, ranganadh <ranganadhkod...@gmail.com> wrote: > Dear Group members, > > =A0I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and > 8i > > it is working very good with the 9i and 10g.. > when i trying to connect 8i server ./. it giving error > > <b> =A0"ORA-03134: Connections to this server version are no longer > supported." </b> > > Can i install, 2 or more =A0version of oracle clients in same system, > becoz .. currently using client software is well configured for some > SQL server BI agents, if i un-install current 10g client, it will > infect my software .. process.. > > if, it can be possible, what kind of things i take care, ...

Oracle 10g 10.0.2 client, to connect oracle 8 server
Dear Group members, I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and 8i it is working very good with the 9i and 10g.. when i trying to connect 8i server ./. it giving error <b> "ORA-03134: Connections to this server version are no longer supported." </b> Can i install, 2 or more version of oracle clients in same system, becoz .. currently using client software is well configured for some SQL server BI agents, if i un-install current 10g client, it will infect my software .. process.. if, it can be possible, what kind of things i take care, before installation .. What is the best oracle client software can suitable for most of the server's > I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and > 8i > > it is working very good with the 9i and 10g.. > when i trying to connect 8i server ./. it giving error > > <b> "ORA-03134: Connections to this server version are no longer > supported." </b> > > > Can i install, 2 or more version of oracle clients in same system, > becoz .. currently using client software is well configured for some > SQL server BI agents, if i un-install current 10g client, it will > infect my software .. process.. Yes you can, I currently have 3 versions Oracle 8.0.4, Oracle 9.2 and Oracle 10.2 on my work PC. No problem. > > if, it can be possible, what kind of things i take care, before > installation .. If yo...

Oracle 9i and Oracle 10g
Hai ALL, I'm Karthick T.S. Oracle Corp. Already said Oracle 9i is a Unbreakable and Complete feature of Internet, then why Oracle Corp. Develop Oracle 10g? Regards Karthick T.S. "T.S. Karthick" <tskarthick@gmail.com> wrote in message news:1114431653.917702.172310@g14g2000cwa.googlegroups.com... > Hai ALL, > > I'm Karthick T.S. Oracle Corp. Already said Oracle 9i is a Unbreakable > and Complete feature of Internet, then why Oracle Corp. Develop Oracle > 10g? > > Regards > Karthick T.S. > Seems to me they are bored and made it breakable again. My database crashes when i start export with datapump (on Linux). breakable: http://www.oracle.com/technology/deploy/security/alerts.htm New features guide: http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10750/toc.htm T.S. Karthick wrote: > Hai ALL, > > I'm Karthick T.S. Oracle Corp. Already said Oracle 9i is a Unbreakable > and Complete feature of Internet, then why Oracle Corp. Develop Oracle > 10g? > > Regards > Karthick T.S. ASM ADDM ASH Virtual Indexes ORA_ROWSCN DBMS_WARNING UTL_MAIL .... does anyone need more reasons? There are at least 1000 more. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond) ...

How do I check which Oracle Patches are appplied to an Oracle DataBase Server
I would like to know if someone could help me with this topic, I'm traying to analize and chek which Oracle Patches are appplied to an Oracle DataBase Server >chek which Oracle Patches are appplied to an Oracle DataBase Server If they were applied with oPatch, then "opatch lsinventory" should show you what's there. If you did not use oPatch, then I have no clue. ;-) BD wrote: > >chek which Oracle Patches are appplied to an Oracle DataBase Server > > If they were applied with oPatch, then "opatch lsinventory" should show > you what's there. > > If you did not use oPatch, then I have no clue. ;-) For better or worse ( we know the answer ) opatch is the tool that install patches from oracle support. "If you did not use oPatch" ... what? >"If you did not use oPatch" ... what? In my 8i environments, there are separate scripts that are run - for example, for a cpu, it would be 'install_cpu.sh'. In those cases, I really don't know how (if) one can confirm which patches have been applied to an environment. ...

Help regarding migration from Oracle 9i client lib to Oracle 10g client lib.
Hi Friends, We are using Oracle client libraries to connect Oracle databases through our application with a shared library, and I am new bie in oracle. We have two separate environments/machines(HP-UX-11.11) one is for DEV and one is for SIT. And so we have two separate oracle 10g client installations. But when we build and use the shared library it works absolutely fine without any issue/doubt in DEV. And although everything is same on both ENV, still it's frequently generating core at SIT. Core back trace is as per below: Where SMAC2000.sl is our application based share...

Oracle 9i:Downtime mandatory for 'Cluster offline' patches. What about with Oracle 10g?
With Oracle 9i, Cluster Downtime(all DB instances in all nodes must be stopped) was mandatory for installing 'Cluster Offline" patches. Is the situation different now with Oracle 10g? If yes, I would like to know whether there are any cases where Downtime is still mandatory for Oracle patches. Thanks! Could anybody clarify this? Thanks! > With Oracle 9i, Cluster Downtime(all DB instances in all nodes must be > stopped) was mandatory for installing 'Cluster Offline" patches. Is > the situation different now with Oracle 10g? If yes, I would like to > know whether there are any cases where Downtime is still mandatory for > Oracle patches. qazmlp wrote: > Could anybody clarify this? Thanks! > > >>With Oracle 9i, Cluster Downtime(all DB instances in all nodes must be >>stopped) was mandatory for installing 'Cluster Offline" patches. Is >>the situation different now with Oracle 10g? If yes, I would like to >>know whether there are any cases where Downtime is still mandatory for >>Oracle patches. Not certified to clarify (not into clustering), but rolling updates, as it is/was called, will probably not emerge before 11i. The mechanism should have been in 10i, rel2, iirc. Could anyone (Mark T, Daniel M) comment on this? -- Regards, Frank van Bortel Frank van Bortel wrote: > qazmlp wrote: > >> Could anybody clarify this? Thanks! >> >> >>> With Oracle 9i, Cluste...

What's a quick simple way to test Oracle connectivity between client and database server?
Gurus, Just learning Oracle. With help from a guru, installed 10g database on one server and 10g client on another. What's a quick simple way to test Oracle connectivity between these two servers at this point? -- Spin On Nov 1, 11:53=A0pm, "Spin" <S...@invalid.com> wrote: > Gurus, > > Just learning Oracle. =A0With help from a guru, installed 10g database on= one > server and 10g client on another. =A0What's a quick simple way to test Or= acle > connectivity between these two servers at this point? > > -- > Spin Try the tnsping utility: tnsping service_name The utility sends a message to listener specified by the tnsnames.ora file entry for the service_name listed on the command line and responds with ping type information. HTH -- Mark D Powell -- "Mark D Powell" <Mark.Powell@eds.com> wrote in message news:ce947e1a-0877-4e46-a638-91d48e92e403@u29g2000pro.googlegroups.com... On Nov 1, 11:53 pm, "Spin" <S...@invalid.com> wrote: Try the tnsping utility: tnsping service_name The utility sends a message to listener specified by the tnsnames.ora file entry for the service_name listed on the command line and responds with ping type information. HTH -- Mark D Powell -- Is service_name a placeholder for something or do I literally type "service_name"? Spin says... > "Mark D Powell" <Mark.Powell@eds.com> wrote in ...

Why the size of Oracle 10g database is much smaller than Oracle 9i?
Oracle 10g only requires 1 disk (604MB); whereas Oracle 9i requires 3 disks (1.3 GB). I was very surprised why Oracle 10g requires so less disk spaces. Am I missing something? Or this is the improvement from Oracle on disk size? I assume Oracle 10g is much more better than Oracle 9i in terms of technologies and performance. Any comments from Oracle 10g users? Please advise. Thanks!! "Matt" <jrefactors@hotmail.com> wrote in message news:ba8a039e.0411141912.71c7d598@posting.google.com... > Oracle 10g only requires 1 disk (604MB); whereas Oracle 9i requires 3 > disks (1.3 GB). I was very surprised why Oracle 10g requires so less > disk spaces. > Am I missing something? Or this is the improvement from Oracle > on disk size? I assume Oracle 10g is much more better than Oracle 9i > in terms of technologies and performance. Any comments from Oracle 10g > users? > > Please advise. Thanks!! They refactored it and made it a lot more efficient and smaller. Jim Matt wrote: > Oracle 10g only requires 1 disk (604MB); whereas Oracle 9i requires 3 > disks (1.3 GB). I was very surprised why Oracle 10g requires so less > disk spaces. > Am I missing something? Or this is the improvement from Oracle > on disk size? I assume Oracle 10g is much more better than Oracle 9i > in terms of technologies and performance. Any comments from Oracle 10g > users? > > Please advise. Thanks!! Actually, to get the same set of options ...

from sql server to oracle to ANOTHER oracle
I have a linked server to a oracle db, that works. I have to write a query from sql server that connecto to the oracle server, and the use a database link from that oracle db to another oracle db. I'm not able to find the syntax. I try to write something like SELECT * FROM LINKTOORACLE..mm510TAL.CSHDET@ORAGATE2 but it does not work questions 1) is is possible to use nested dblinks ? 2) if so, how ? thank you! On Nov 10, 10:57=A0am, Alberto Marchi <alberto.rol...@gmail.com> wrote: > I have a linked server to a oracle db, that works. > > I have to write a query from sql server that connecto to the oracle > server, and the use a database link from that oracle db to another > oracle db. I'm not able to find the syntax. > > I try to write something like > > =A0SELECT * FROM > =A0 LINKTOORACLE..mm510TAL.CSHDET@ORAGATE2 > > but it does not work > > questions > 1) is is possible to use nested dblinks ? > 2) if so, how ? > > thank you! use a synonym that points to the second linked table? On Nov 10, 9:27=A0pm, onedbguru <onedbg...@yahoo.com> wrote: > On Nov 10, 10:57=A0am, Alberto Marchi <alberto.rol...@gmail.com> wrote: > > > > > > > I have a linked server to a oracle db, that works. > > > I have to write a query from sql server that connecto to the oracle > > server, and the use a database link from that oracle db to another > > oracle db. I&#...

oracle 10g and oracle 9i RMAN
According to oracle increment backup in oracle 10g RMAN is faster then oracle 9i RMAN, because after enable block change tracking... oracle starts recording changes in blocks in a file. But in oracle 9i also oracle record changes in database to REDO LOG files and how is it different. On 10 jul, 12:39, peter <hhh.datab...@gmail.com> wrote: > According to oracle increment backup in oracle 10g RMAN is faster then > oracle 9i RMAN, > because after enable block change tracking... oracle starts recording > changes in blocks in a file. > But in oracle 9i also oracle record changes in database to REDO LOG > files and how is it different. The answer to this question is obvious (as with all of your questions, as you never RTFM and if you RTFM, don't try to *understand* the documentation). The redo log is a *chronological* collection of what Oracle calls change vectors. If you would need to determine which blocks have been changed since last backup, you *obviously* would have to scan through *ALL* redologs since last backup. The block change tracking file is a bitmapped file only stating the fact a specific block has changed. -- Sybrand Bakker Senior Oracle DBA On Jul 10, 3:49 pm, sybrandb <sybra...@gmail.com> wrote: > On 10 jul, 12:39, peter <hhh.datab...@gmail.com> wrote: > > > According to oracle increment backup in oracle 10g RMAN is faster then > > oracle 9i RMAN, > > because after enable block change tracking......

Linking with Oracle 9i and Oracle 10g
Hi, I want to use software built against Oracle 9i on an Oracle 10g database. I am using g++ on Solaris 9 with Oracle 9i to build the code. Doing an ldd shows libclntsh.so.9.0 => /u01/app/oracle/product/9.2.0.4/lib32/libclntsh.so.9.0 Is there a way not to have the binary not expect the .so.9.0 i.e. it just accept libclntsh.so. I am soft linking at the moment as workaround i.e. ln -s libclntsh.so.10.2.0 libclntsh.so.9.0 Thanks, Iain Iain William Wiseman <iwiseman@fred.co.nz> wrote: > I want to use software built against Oracle 9i on an Oracle 10g database. > > I am using g++ on Solaris 9 with Oracle 9i to build the code. Doing an > ldd shows > > libclntsh.so.9.0 => /u01/app/oracle/product/9.2.0.4/lib32/libclntsh.so.9.0 > > Is there a way not to have the binary not expect the .so.9.0 i.e. it > just accept libclntsh.so. I am soft linking at the moment as workaround > > i.e. ln -s libclntsh.so.10.2.0 libclntsh.so.9.0 That soft link is a very bad idea. There are two good solutions: a) link the software against Oracle 10 b) install an Oracle 9 client. While a) may not always be possible, there's nothing to keep you from b). Yours, Laurenz Albe ...

Install Oracle 9i after Oracle 10g
I have had to install Oracle 9i on a server (W2K3) that already had Oracle 10g installed. I was planning to use the listener which was created as part of the 10g installation so I did not create a new listener for 9i. I performed a software only installation because the application that I have to install for 9i has scripts to create its own instances. After doing the 9i install, which seemed to go well, I am having the following problem. I cannot start the Database Configuration Assitant or the Net Configuration Assistant. I don't know if this is because the it can't detect the 10g listener or if it is another problem which I haven't discovered yet. Also, when using the Home Selector utility, it tell me that there is only one Oracle home, even though I installed 9i into a new Oracle home. The Universal installer shows two homes, but the registry does not show a Home0 and Home1, only a Home0 pointing to the 9i install. Any know issues with installing 9i AFTER 10g that could be causing these problems? Thank you. RhodeRunner wrote: > I have had to install Oracle 9i on a server (W2K3) that already had > Oracle 10g installed. I was planning to use the listener which was > created as part of the 10g installation so I did not create a new > listener for 9i. > > I performed a software only installation because the application that I > have to install for 9i has scripts to create its own instances. > > After doing the 9i install, wh...

oracle 8i communicate with oracle 9i
I'm planning to do data purging which transfer some old data in date range from oracle 8i to oracle 9i and then delete the old in oracle 8i. as i know, to communicate between database in same server, we need to use "Database Link" but if communicate with different server? any query or snytax to do it? or what steps i need to follow? Is it difficult to do it? Thanks.. Just create a regular database link CREATE DATABASE LINK <link-name> CONNECT TO <username> IDENTIFIED BY <password> USING '<tns-name>'; But make sure that the server is in tnsnames.ora on your database server. skyloon skrev: > I'm planning to do data purging which transfer some old data in date > range from oracle 8i to oracle 9i and then delete the old in oracle 8i. > as i know, to communicate between database in same server, we need to > use "Database Link" > but if communicate with different server? any query or snytax to do it? > or what steps i need to follow? Is it difficult to do it? > > Thanks.. ...

Oracle 9i Database Server on Windows 2003 Server
I am wondering if we can install this Server on Windows 2003 Server without any problems. Is there anybody that did that before? Thanks in advance if someone know the answer. Yvon Bouchard, B. Sc. Computer Science Teacher http://info.cegepat.qc.ca/siteyvon I've installed it on windows 2003 enterprise ed. about 1 month ago without any problem. I've installed the version 9.2.0.1 with the patch to 9.2.0.3. 9.2.0.3 is the only version certified by oracle for win 2003. Ciao "Yvon Bouchard" <yvon.bouchard@cablevision.qc.ca> ha scritto nel messaggio news:QCLvb.21605$ZF1.2102185@news20.bellglobal.com... > I am wondering if we can install this Server on Windows 2003 Server without > any problems. > Is there anybody that did that before? > Thanks in advance if someone know the answer. > > Yvon Bouchard, B. Sc. Computer Science > Teacher > http://info.cegepat.qc.ca/siteyvon > > > Yvon Bouchard wrote: > > I am wondering if we can install this Server on Windows 2003 Server without > any problems. > Is there anybody that did that before? > Thanks in advance if someone know the answer. > Although I have not installed on Windows 2003 myself, I know of several such installations and all occurred without issue. I do note that Oracle has a separate download (CD set) for the WIndows 2003 compared to NT/2000/XP, so I suspect the install for the latter may not be ...

Oracle 10g OCI based application talking to an Oracle 9i database
Hi all, Got a question. I have an OCI C++ application that is written using the Oracle 10g OCI includes, etc ... This of course is running on a 10g client. The client OS is actually a Windows x64 system since 10g is the only native OCI client right now for 64 bit Windows systems. So this all works fine. Now, I am communicating with an Oracle 9i database server. Is there anything wrong or invalid about this configuration ? I didn't think that there was but I was asked to confirm this, that is having an Oracle 10g client communicating with an Oracle 9i database. Our application is making very straight forward OCI calls, and we are not using any of the newer OCI calls that were introduced in 10g, just the ones that are available in 9i OCI. Thanks in advance, Nick On Tue, 22 Aug 2006 11:01:32 -0700, "Nicholas Palmer" <nick@kcicorp.com> wrote: >Got a question. I have an OCI C++ application that is written using the >Oracle 10g OCI includes, etc ... This of course is running on a 10g client. >The client OS is actually a Windows x64 system since 10g is the only native >OCI client right now for 64 bit Windows systems. So this all works fine. >Now, I am communicating with an Oracle 9i database server. Is there anything >wrong or invalid about this configuration ? I didn't think that there was >but I was asked to confirm this, that is having an Oracle 10g client >communicating with an Oracle 9i database. Our applica...

WINODS NT SERVER Oracle
I have Oracle database running on a Windows NT server. I am accessing the server using Remote Desktop ( A Microsoft Terminal Service Client). Somone told me that there are limitations in remote desktop, i.e., one cannot start Oracle. I want to know why as well as the workarounds. Instead of running everything from the WINDOWS NT server console wjhich is painful, what are the workraounds. Do same problem exist with pcAnywhere, VNC desktop, Citrix client. Thanks, Prem On 19 Feb 2004 18:38:10 -0800, premmehrotra@hotmail.com (Prem K Mehrotra) wrote: >I have Oracle database running on a Windows NT server. I am accessing >the server using Remote Desktop ( A Microsoft Terminal Service >Client). Somone told me that there are limitations in remote desktop, >i.e., >one cannot start Oracle. I want to know why as well as the >workarounds. Because Microsoft is Microsoft and Microsoft doesn't support the BEQ protocol used by Oracle for this purpose. The only lousy workaround is to use set local=<tns service name> prior to connecting to sql*plus in a cmd window. Also you can't use the lsnrctl program to start and stop the listener for the same reason. You need to bounce the service. > >Instead of running everything from the WINDOWS NT server console >wjhich is painful, what are the workraounds. OEM? It works! Need to save the init.ora on the Oracle Enterprise Management Server, using OEM, but that is about there is. Or dump Microsux T...

Running Oracle 8.1.x and Oracle 9i on same Windows 2000 Server
I'm attempting to run an Oracle 8.1.7 database and and Oracle 9i database on the same Windows 2000 Server. Before doing this has anyone ran this configuration and are there any things I must watch out for prior to installing the Oracle 9i software? Thanks for the assistance. David David wrote: > I'm attempting to run an Oracle 8.1.7 database and and Oracle 9i database > on the same Windows 2000 Server. > > Before doing this has anyone ran this configuration and are there any > things I must watch out for prior to installing the Oracle 9i software? > > Thanks for the assistance. > David Environment variables Multiple Oracle Homes Lack of resources It can be done. Many have done it. It still isn't a good idea if it can be avoided. And please, in the future, do NOT cross-post. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply) ...

massive performance drop Oracle 9i on multi processor system (Windows Server 2003, Oracle 9i, 9.2.0.6.0)
The performance of some complex PL/SQL functions has dropped dramatically since migrating from Oracle 8i (8.1.7.0.0) on Windows Server 2000 to 9i (9.2.0.6.0) on Windows Server 2003. We found out, that Oracle 9i performance on a multi processor CPU machine (our server has 4 XEON CPUs, Hyperthreading is disabled in BIOS) is highly dependent on init.ora parameters; unfortunately our trial and error approach to find the proper settings (we searched Oracle Tech Net (OTN) and google groups without success) did not help so far. We are testing performance behaviour with some business critical PL/SQL procedures that do authorization calculations for our application. Simplified these functions do a lot of inserts, deletes and selects in/from tables (being used as temp tables in lack of in memory temp table support of oracle 9i). We can monitor the progress within the stored procedure by using UTL_FILE functions to write a log file into the file system of the server; we real time monitor the log file using "tail -f". <PL/SQL do something> UnbufferedLogFileOutputUsingUTL_FILE(); <PL/SQL do something> UnbufferedLogFileOutputUsingUTL_FILE(); [...] When setting "CPU_COUNT = 1" in init.ora the function will typically run up to 10 seconds, when setting "CPU_COUNT = 4" it will take more than 2 minutes (!!!) We experimented with the following other parameters so far: db_writer_processes (set to 4 in combination with cpu_count = 4) fast_start_parall...

install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 2
hello i have a strange problem with DBI module. has anyone any clue about what is wrong here? my connection string: --------------------- use DBI; use DBD::ODBC; use DBI qw(:sql_types); use strict; use warnings; my $db = "something"; my $user = 'XXX'; my $passwd = 'XXX'; my $dbh = DBI->connect('dbi:Oracle:XXX', $user,$passwd, {RaiseError => 1, AutoCommit => 0}) or die $DBI::errstr; ################# This gives the foll...

How to make a dump for Oracle 9i with Oracle 10g
Hello, is it possible to create an export dump of a scheme in Oracle 10g in order to import it into an Oracle 9i database? Thank you, Norbert On Mar 31, 10:10=A0am, Norbert P=FCrringer <thalio...@graffiti.net> wrote: > Hello, > > is it possible to create an export dump of a scheme in Oracle 10g in > order to import it into an Oracle 9i database? > > Thank you, > Norbert Yes, and that's been covered any number of times in this newsgroup, on the web and in the Oracle documentation. I suggest you search the newsgroup archives, learn to use google or visit the documentation found here: http://tahiti.oracle.com David Fitzjarrell On Mon, 31 Mar 2008 08:10:48 -0700 (PDT), Norbert P�rringer <thalion77@graffiti.net> wrote: >Hello, > >is it possible to create an export dump of a scheme in Oracle 10g in >order to import it into an Oracle 9i database? > >Thank you, >Norbert This is a FAQ which should be prevented by searching the Internet. Usually only people in the Eastern Hemisphere are too lazy to do that, but I see the virus is spreading. You need the 9i exp to run against the 10g database. -- Sybrand Bakker Senior Oracle DBA ...

Bring over Oracle 9i db to Oracle 10g
Have been using a db in Oracle 9i for sometime and now want to upgrade this db to Oracle 10g. Can someone point me in the right direction? "William F. O'Neill" <wfoneill@bellsouth.net> wrote in news:RZ60d.82660$N11.77025@bignews5.bellsouth.net: > Have been using a db in Oracle 9i for sometime and now want to upgrade > this db to Oracle 10g. Can someone point me in the right direction? > > > http://otn.oracle.com http://tahiti.oracle.com Hi Ana: By the time I go thru both of those websites that you gave me, Oracle will be out with v.11 - spent a half hour looking for some instruction or article that would help me. Am not a DBA, so the answer might be staring me in the face, and I wouldn't recognize it. Just want to be able to use my old Oracle 9i db in Oracle10g. "Ana C. Dent" <anacedent@hotmail.com> wrote in message news:Xns955FBFA0ADB5BSunnySD@68.6.19.6... > "William F. O'Neill" <wfoneill@bellsouth.net> wrote in > news:RZ60d.82660$N11.77025@bignews5.bellsouth.net: > >> Have been using a db in Oracle 9i for sometime and now want to upgrade >> this db to Oracle 10g. Can someone point me in the right direction? >> >> >> > > http://otn.oracle.com > http://tahiti.oracle.com William F. O'Neill wrote: > Hi Ana: > > By the time I go thru both of those websites that you gave me,...

Oracle 8i and Oracle 9i Lite Sync
Is it possible to do a synchronisation between oracle 8i server and oracle 9i Lite, If that is the case what is the edition [type] of oracle 8i that is required [Enterprise or standard etc]. Im unable to find this info @ oracle site [or] it is too complicated to search -karthik On 25 Aug 2004 23:42:23 -0700, karthi@myrealbox.com (Karthik) wrote: >Is it possible to do a synchronisation between oracle 8i server and >oracle 9i Lite, >If that is the case what is the edition [type] of oracle 8i that is >required [Enterprise or standard etc]. Im unable to find this info @ >oracle site [or] it is too complicated to search > >-karthik Lower version database to higher version client. This is not likely going to work. -- Sybrand Bakker, Senior Oracle DBA Sybrand Bakker wrote: > On 25 Aug 2004 23:42:23 -0700, karthi@myrealbox.com (Karthik) wrote: > > >>Is it possible to do a synchronisation between oracle 8i server and >>oracle 9i Lite, >>If that is the case what is the edition [type] of oracle 8i that is >>required [Enterprise or standard etc]. Im unable to find this info @ >>oracle site [or] it is too complicated to search >> >>-karthik > > > Lower version database to higher version client. This is not likely > going to work. > > > -- > Sybrand Bakker, Senior Oracle DBA I once had Advanced Replication working from an 8i to a 9i database, but it was a lot of work. This is th...