f



Running ORACLE 8.1.7 & ORACLE 9.2 on the same UNIX server

Hi,

I have recently installed ORACLE 9.2 Database on a UNIX server (2.8)
which already has ORACLE 8.1.7. They have both a different SID and
ORACLE_BASE. However I am having to use the ORACLE 8 listener for both
ORACLE databases.

Is it possible to run separate ORACLE 8 and ORACLE 9 listeners?
0
jonathan
6/8/2004 8:37:01 AM
comp.database.oracle 721 articles. 0 followers. Post Follow

1 Replies
945 Views

Similar Articles

[PageSpeed] 49

Hello,

There are no difficulty to use 2 listeners on the same machine.

The point is that default listener used to listen on port 1521 (or
1526).

You will have to change your listener configuration( netasst or by
hand) in order to use a different port number, a different listener
name and communicate it to your users for their tnsnames.ora.

LSNR8I =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= TCP)(Host= machine)(Port= 1110))
  )

Generally what I do is to create 1 listener per Oracle Version.

After that, for starting listeners you'll have to launch

lsnrctl start LSNR8I ou lsnrctl start LSNR9I

I am used to name listeners with different names since 8i because you
have the autoregistration stuff and with 2 listeners with the same
name, you are not sure  on which the database will register (or using
le local_listener init parm).

Regs,

Olivier


jonathan.johnston@bt.com (Jonathan Johnston) wrote in message news:<5e07fa5.0406080037.67d595a9@posting.google.com>...
> Hi,
> 
> I have recently installed ORACLE 9.2 Database on a UNIX server (2.8)
> which already has ORACLE 8.1.7. They have both a different SID and
> ORACLE_BASE. However I am having to use the ORACLE 8 listener for both
> ORACLE databases.
> 
> Is it possible to run separate ORACLE 8 and ORACLE 9 listeners?
0
guyot
6/9/2004 7:33:43 AM
Reply:

Similar Artilces:

update database oracle 8.1.7 to oracle 9?
Hi How I can change my database for Oracle 8.1.7. to Oracle 9. Please help me. Thanks Slawek slawek wrote: > Hi > > How I can change my database for Oracle 8.1.7. to Oracle 9. > Please help me. Thanks > > > Slawek When you purchase the new version of Oracle it comes with an installation and migration manual. The details are in the manual. Basically install new version to new home Shutdown old database Restart using new ORACLE_HOME Run upgrade scripts There is a migration utility that pretty much automates this but we always perform the tasks manually. HTH -- Mark D Powell -- On Tue, 19 Sep 2006 19:35:45 +0200, slawek <yazoo@hacking.pl> wrote: >How I can change my database for Oracle 8.1.7. to Oracle 9. http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96530/toc.htm -- Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool Uzytkownik "Andy Hassall" <andy@andyh.co.uk> napisal w wiadomosci news:60d0h2poie7f9f0omigqadl02lmsis8kee@4ax.com... > On Tue, 19 Sep 2006 19:35:45 +0200, slawek <yazoo@hacking.pl> wrote: > >>How I can change my database for Oracle 8.1.7. to Oracle 9. > > http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96530/toc.htm > > -- > Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk > http://www.andyhsoftware.c...

ODMA_RBS Error while upgrade Oracle 8.1.7 to Oracle 9.2
Hi all, I am trying to upgrade Oracle 8.1.7 to Oracle 9.2 using database upgrade assistant and while doing that I am getting error at final Step 4 after clicking the Finish button error msg is "90MB of Free disk space not available at D:\ORACLE9\oradata\Datenbank to create the "ODMA_RBS" tablespace for rollback undo mode duting upgrade.Provide the required free disk space on the disk" Althoug there are 51 GB of disk space available. I don't know why is it giving this error! OS is Windows 2003. Can anyone help? Thanks in advance, Dirk Hmmm...Hard to say...Prove t...

Patching Oracle 8.1.7.0.0 to Oracle 8.1.7.4.1
Hello, my configuration is Windows 2K Server SP4 and Oracle 8.1.7.0.0. Where can i find a patch to upgrade to Oracle 8.1.7.4.1 Many thanks for your attention -- Sitta many thanks!!!! Have a nice work "Rauf Sarwar" <rs_arwar@hotmail.com> ha scritto nel messaggio news:1106137485.286119.307110@f14g2000cwb.googlegroups.com... > > Sitta Davide wrote: >> Hello, >> my configuration is >> >> Windows 2K Server SP4 and Oracle 8.1.7.0.0. >> >> Where can i find a patch to upgrade to Oracle 8.1.7.4.1 >> >> >> Many th...

help:How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7
How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7 1-what scripts are to be used 2-Where i can find these scripts. Thnks. You can't. You can use lower version export to export higher version database. The other way around has never been possible. -- Sybrand Bakker Senior Oracle DBA You probably have Oracle 9.2.0.1 running somewhere right, perhaps on another machine ? Set your ORACLE_HOME to 9.2.0.1 then export through sqlnet: exp username/pwd @9207instance Now you'll use the 9.2.0.1 export utility; this should work. "shahsyed" <shahsyed@gmail.co...

Oracle 8.1.7 32-Bit to Oracle 8.1.7 64-Bit
Hi I would much appreciate help We have a 150-200GB database on Oracle 8.1.7 which resides on a HP-UX 32-bit machine. We are upgrading the HP-UX machine to 64-Bit. Is the only way of extracting/inmporting the data via the exp/imp utitlity due to the change in bits? Is there any other way? Thanks Bob Bob wrote: > Hi I would much appreciate help > > We have a 150-200GB database on Oracle 8.1.7 which resides on a HP-UX > 32-bit machine. We are upgrading the HP-UX machine to 64-Bit. Hi, a) Do you want to upgrade Oracle-Software from 32bit to 64bit? On Solaris, I know 32bit ...

Need Oracle Patch for Oracle 8i (8.1.7) to make it to 8.1.7.4 WINDOWS Env.
Hi, I am a newbie here and looking for a patch which will convert 8.1.7 to 8.1.7.2 / 8.1.7.4 in a windows environment. I dont have a metalink account. If someone can help i'd appreciate it. Maybe some from the newsgroup knows how to get it. I need this for personal use (educational) Thanks. Regards RS Unfortunately the only way to get patches is through metalink and with a valid support contract. And you want to be running 8.1.7.4.13 on windows as a minimum. Regards, John On Thu, 19 Aug 2004 02:48:48 -0400, "RS" <rohitsinha@comcast.net> wrote: >Hi, > I am a newbie here and looking for a patch which will convert >8.1.7 to 8.1.7.2 / 8.1.7.4 in a windows environment. I dont have a metalink >account. If someone can help i'd appreciate it. Maybe some from the >newsgroup knows how to get it. I need this for personal use (educational) >Thanks. > > >Regards > >RS > ...

Using Oracle Developer with Oracle 8.1.7 database
Hi. I would like to use the current versions of Oracle Developer Suite I can download from Oracle website (i.e. 10g and 9i), but I will have to connect to an Oracle 8.1.7 dbase. Is it possible to connect to such an "old" database with the current versions or Oracle Developer Suite? Thank you, El DoDo march...@units.it wrote: > Hi. > > I would like to use the current versions of Oracle Developer Suite I > can download from Oracle website (i.e. 10g and 9i), but I will have to > connect to an Oracle 8.1.7 dbase. > Is it possible to connect to such an "old" database with the current > versions or Oracle Developer Suite? > > Thank you, > El DoDo 9i client is backward compatable to 8i. However, 10g is only backwards compatable to certain 8i patchset. I can connect from 10g client to 8.1.7.4.1 but not to 8.1.7.0. Not sure about the in between patchsets as I don't have them. Regards /Rauf marchesa@units.it wrote: > Hi. > > I would like to use the current versions of Oracle Developer Suite I > can download from Oracle website (i.e. 10g and 9i), but I will have to > connect to an Oracle 8.1.7 dbase. > Is it possible to connect to such an "old" database with the current > versions or Oracle Developer Suite? > > Thank you, > El DoDo Yes. Make sure you have patched the 8i database to make it as current as possible. -- Daniel A. Morgan...

Oracle server 9.2.0.1.0, Client 9.2.0.4.0, Red Hat Linux enterprise advanced server 2.1
Hi Everybody, My Database server is running on Red Hat Linux enterprise advanced server 2.1, And my Oracle version is 9.2.0.1.0. My Client mechine also Red Hat Linux enterprise advanced server 2.1 , Oracle client version is 9.2.0.4.0. I am running a web application. Our application is in Magic edeveloper. I connect to Oracle using oracle gateway to my application. My Problem is my application is is becoming slow. I am not able to trace where the problem is. Before our application was running fine. recently i upgraded Oracle client version to 9.2.0.4.0. My Oracle client & server versi...

Upgrade from Oracle 9.2.0.1 to Oracle 9.2.0.3
Hello All, I am trying to upgrade oracle 9.2.0.1 to new patchset 9.2.0.3 or 9.2.0.4. Please recommend which is better 9.2.0.3 or 9.2.0.4? Also I had a bad experience with my development server when applying 9.2.0.3 patchset. Is there anything you recommend before I start again? Thanks Kumu Hello Kumu, What is the reason for upgrade? Any specific bugs or issues you experience? You can open TAR as well to get support recommendations for your situation. New patches can introduce new problems as you can see, Regards, Ron DBA Infopower http://www.dbainfopower.com Standard di...

How to migrate from Oracle 8.1.7 to Oracle 10g Release 2
Hello all! On my first server installed oracle 8.1.7 and I want to transfer database from it to database my second server (oracle 10g Release2). How can I do this? Not sure what you mean. If you want to transfer the data from your 8.1.7 database into a 10.1.0.2 database .. then export/import are probably the best way to go. If possible upgrading the 8.1.7 database to 10.1.0.2 database might be faster. http://www.oracle.com/pls/db102/to_pdf?pathname=3Dserver.102%2Fb14238.pdf&r= emark=3Dportal+%28Getting+Started%29 http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14238....

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

Upgrading Oracle 8.1.7.2 to 8.1.7.4
Can somebody help me with the processof upgrading the Oracle Database server from 8.1.7.2 to 8.1.7.4 ? Thanks, Ram. ***************************************** * This message was posted via http://www.oraclemonster.com * * Report spam or abuse by clicking the following URL: * http://www.oraclemonster.com/Uwe/Abuse.aspx?aid=73db04a468ad4c33876f738804693df2 ***************************************** "Ramanujam Paravastu via OracleMonster.com" <forum@OracleMonster.com> a �crit dans le message de news:73db04a468ad4c33876f738804693df2@OracleMonster.com... > Can somebody help me with the processof upgrading the Oracle Database server from 8.1.7.2 to 8.1.7.4 ? > > Thanks, > > Ram. > > ***************************************** > * This message was posted via http://www.oraclemonster.com > * > * Report spam or abuse by clicking the following URL: > * http://www.oraclemonster.com/Uwe/Abuse.aspx?aid=73db04a468ad4c33876f738804693df2 > ***************************************** Just follow the instructions in the README.html file you get with your patchset. -- Regards Michel Cadot I found the patch for UNIX systems, I would like to know the patch for Windows NT/2000 systems Please. Thanks. ***************************************** * A copy of the whole thread can be found at: * http://www.oraclemonster.com/Uwe/Forum.aspx/oracle-misc/2776 * * Report spam or abuse by clicking the fo...

Oracle 8.1.7 & RH 7.2
Hi, Folks I am traying to install Oracle 8.1.7.0.1 Enterprise Edition fol Linux on RH7.2 (Kernel 2.4.7-10) PS: Celeron 466 MHz, 128 MB RAM When I start installation form CD, on screen Select installation type (Tipical or Custom), after few minits (during the process Executin Pre-requests) installation procedure broken down without logs or messages. Does someone have any suggestions? Thank's!!! "tabinja" <tabinja@yahoo.com> wrote in message news:bq4mmm$jm1$1@ls219.htnet.hr > I am traying to install Oracle 8.1.7.0.1 Enterprise Edition fol Linux > on RH7.2 (Kerne...

Using Oracle 8.1.7 OCI JDBC Driver WIth Oracle 9i Database
Has anyone had any problems using the 8.1.7 OCI JDBC driver with a 9i database? Oracle states they are compatible at the following URL: http://otn.oracle.com/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#_1_ "Matt" <mdavey4@csc.com> wrote in message news:f2892d3a.0307241304.6295d05c@posting.google.com... > Has anyone had any problems using the 8.1.7 OCI JDBC driver with a 9i database? > > Oracle states they are compatible at the following URL: > http://otn.oracle.com/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#_1_ Any reason not to trust that statement? If you do have any reason, why don't you post it rightaway? -- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail address ...

Install problems with Oracle installer 2.2 for Oracle 9i Client 9.2.0.1.0
Please forgive me if I am posting this in the wrong forum - I am an Oracle Newbie. Here are my computer specs : Windows 2003 - fully patch from Microsoft as of Sept 4th 2004 HP LP2000r 1 x 1,1 Gig Intel processor 1 GB RAM Hardware RAID 1, 12 GB with 8 GB freespace Clean install, no other programs. At first I tried running the Oracle installer program from the CD ROM and came up with the error that it could not find the javaw.exe program. I then tried installing and reinstalling several versions of java to no avail. Next I searched through groups.google and found the solution: 1. Copy t...

Oracle Client 8.1.7 vs Client 9.1.2 and SQL
I have been given some conflicting information concerning 8.1.7 and 9.1.2 Clients and SQL queries. How does an 8.1.7 client pointing to 9i database cope with 9i (or higher) queries sent from a client application? Is there are relationship between client and SQL code? hello Pavle, 8.1.7 client talks to 9.2 and 8.1.7 database. 9.2 client talks to 9.2 and 8.1.7 database. The second option is perhaps preferable; for obvious reasons; but not required. And SQLcode is not downward compatible; has no relation to the client. Cheers, Roelof Schierbeek; DBA <pavle_sturma@hotmail.com> s...

from oracle 9.2.04 to oracle 9.2.05
i'm a newbie, i'd like to guess if anybody knows how can I upgrade my oracle 9.2.04 to 9.2.05. My java_pool_size, shared_pool_size are under 150 MB. How can I set this value? Bye and thx a lot. jakko1982 wrote: > i'm a newbie, i'd like to guess if anybody knows how can I upgrade my > oracle 9.2.04 to 9.2.05. > My java_pool_size, shared_pool_size are under 150 MB. How can I set > this value? > > Bye and thx a lot. 1) Goto http://metalink.oracle.com and download the 9.2.0.5 patchset. You can also goto 9.2.0.6. Patch installation documentation comes with it....

JDBC thin driver TCP TIME_WAIT on ORACLE 8.1.7.2.1 (win2k server)
Hi, We are running IBM's WebSphere Application Server on several servers. They all use the same Oracle 8.1.7.2.1 database; the WebSphere servers have a Oracle 8.1.7.2.1 client installed but use the JDBC thin driver to connect to the database. We are running in a production environment; since using WebSphere, we see an enormous amount of TCP TIME_WAIT connections using netstat on the Oracle server. Most of them (around 800) are of the following form (wolnlztmpor01 is a WebSphere server, wolnlztmora01 is our database server and 1521 is its listener port): TCP wolnlztmora01:1521 WOLNLZTMPO...

How to imp from oracle 8.1.7 to 8.1.6 in Unix?
Hello, My dbase version in 8.1.6 in Unix machine but while i was tring to import a dmp file from version 8.1.7 (from Win200) an import error occurred. IMP-00069-Could not convert to environment character set's handle. Can anybody please help me on how to resolve it? -- Posted via http://dbforums.com Originally posted by Merah > Hello, > > My dbase version in 8.1.6 in Unix machine but while i was tring to > import a dmp file from version 8.1.7 (from Win200) an import error > occurred. IMP-00069-Could not convert to environment character > set's handle. > > Can anybody please help me on how to resolve it? If you have access to the metalink, check this docid, http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=132904.1 Regards /Rauf Sarwar -- Posted via http://dbforums.com Over n/w the import could be pretty slow, Copy the execute imp file from 8.1.6 server to 8.1.7 with some different name say "myimp" Now run import on target server using "myimp" -- Posted via http://dbforums.com ...

Using Oracle 8 binaries with an Oracle 9 database
Are there any known issues using Oracle 8 binaries with an Oracle 9 database? don't, bad idea. Jim "steveH" <sjharri@yahoo.com> wrote in message news:324e5dec.0311031243.6b07a00d@posting.google.com... > Are there any known issues using Oracle 8 binaries with an Oracle 9 database? ...

copy database from oracle 9 to 8.1.7
I am going to restore my PRD (8.1.7) to DEV (9). In my PRD, I have a full offline backup scheduled in db13 to a DDS-4 tape. With this tape, I am going to restore PRD to my DEV. 1) Remove all the DEV filesystems 2) Create the PRD filesystems 3) the command used to restore is "brrestore -b <coded_timestamp>.<fid> -m full". This file <coded_timestamp>.<fid> is tied to the same one with what is shown in the DB13 log. 4) This will restore the complete PRD system. Problem is that this restored system is a 8.1.7. But the one in DEV is 9 therefore the binary is di...

How to write shell script to export oracle 8.1.6 database to import oracle 10g database
Hi, I am trying to write or understand the conj process for export the data from oracle 8i to oracle 10g database. I have constraint that the previous loaded data into oracle10g should not be deleted or replace by newly imported database. Regards Nikhil ...

Transport tablespace between oracle 8.1.7 and 9.2
Is-it possible to transport tablespaces between oracle 8.1.7 and 9.2 on unix AIX 5L ? Thanks for answer "djules" <djules@gaz-de-bordeaux.com> wrote in message news:1225f3bb.0411040452.49c2e52d@posting.google.com... > Is-it possible to transport tablespaces between oracle 8.1.7 and 9.2 > on unix AIX 5L ? > Thanks for answer This is from Metalink : "Compatibility Considerations for Transportable Tablespaces ---------------------------------------------------------- To use the transportable tablespaces feature, the COMPATIBLE initialization parameter for both t...

How to install oracle 8.1.7 database on linux 9
Hi, I want to install oracle 8i database on linux 9 or 8.I am beginner regarding using Linux. Could some one send me the steps to perform the installation of oracle 8i on linux 9 or 8. thanks faraz Oracle 8i has been desupported almost a year from now. If you don't want to read the installation manual this should be able to help you out http://www.puschitz.com/InstallingOracle9i.shtml (which you could have found by a little Googling) -- Sybrand Bakker Senior Oracle DBA Here on that forum I need information regarding installation of 8i on linux 9i. please inform me how should ...

Web resources about - Running ORACLE 8.1.7 & ORACLE 9.2 on the same UNIX server - comp.database.oracle

Running - Wikipedia, the free encyclopedia
This article is about the type of locomotion in humans. For running in horses, see Horse gait . For locomotion in dogs, see Gait (dog) . For ...

Mina Guli: Australian woman running 40 marathons in 49 days in 7 Desert Challenge
A FEW days ago Mina Guli was running on a polar ice cap, it was minus 20 degrees and there was a white out.

HP teams up with iPass to offer global Wi-Fi across select devices, including those running Windows 10 ...
Among the downsides of traveling, is limited access to Wi-Fi. Finding hotspots becomes a priority, leaving travelers scrambling for places like ...

Lunatics running the asylum @BloggersRus
Lunatics running the asylum by Tom Sullivan The sooner America legalizes marijuana and collectively lights one up, the better. At the risk ...

Hundreds of millions of pounds are running through Airbnb's UK business
The UK is a big market for Airbnb, with over 81,000 properties listed on the platform here and 2.2 million tourists using the service to stay ...

GOP Gov. Brian Sandoval takes himself out of the running for SCOTUS
His decision comes only a day after CBS News confirmed the White House had been vetting him

Batman V. Superman Running Time Confirmed
Batman V Superman: Dawn of Justice will run for more than two and a half hours, AMC Theatres has [...]

Apple Watch’s biggest competitor is running into problems
We still don’t have exact sales numbers on the Apple Watch, but something is clearly having a big impact on Fitbit, Apple’s biggest rival in ...

Chuck Todd: Hillary Will ‘Long For The Days Of Ken Starr When Running Against Trump’
Chuck Todd: Hillary Will ‘Long For The Days Of Ken Starr When Running Against Trump’

Report: Former Cowboys Running Back Joseph Randle Arrested And Charged With Battery
According to a report from TMZ Sports , which was later corroborated by the Dallas Morning News , former Cowboys running back Jospeh Randle was ...

Resources last updated: 2/25/2016 10:37:48 PM