9i R2

it seems like it can be downloaded already, most platforms are out

check technet and early access program for R2

I am downloading for linux right now :)

Pando-

Which flavor of linux are you using?

Thanks...

used to use redhat but using slackware now but personal use, in customers we use suse

Quote:

---

Originally posted by pando
it seems like it can be downloaded already, most platforms are out

---

Is it beta?

cut & pasted

You can now download the production release of Oracle9i Database Release 2 prior to general availability. All you need to do is click on the button to the right.

I registered for email notification when the Win2K and Linux versions were released. What a surprise, I never received the mail.

I'm downloading the Win2K version now. I'll get the Linux version at home. I'll keep you informed how it's going. XMLDB here I come :)

rcherch: If you're interested I'm using Oracle9i on Redhat 7.2 at home. I've downloaded the 7.3 images but I'm having trouble with the install. Anyway, both 7.1 and 7.2 work fine. I think Oracle only certify Oracle9i against RedHat 7.1 at the moment. If you're using it for a business it's best to stick with a certified version. I'm not sure which SUSE versions are certified.

Cheers

Tim, did you have a look at:

List of Bugs fixed in Oracle9i Release 2 base release (9.2.0.1) (Metalink Doc ID: 190077.1). Sounds good!

Where from are you downloading 9.2?

Quote:

---

Originally posted by TimHall
I registered for email notification when the Win2K and Linux versions were released. What a surprise, I never received the mail.

I'm downloading the Win2K version now. I'll get the Linux version at home. I'll keep you informed how it's going. XMLDB here I come :)

rcherch: If you're interested I'm using Oracle9i on Redhat 7.2 at home. I've downloaded the 7.3 images but I'm having trouble with the install. Anyway, both 7.1 and 7.2 work fine. I think Oracle only certify Oracle9i against RedHat 7.1 at the moment. If you're using it for a business it's best to stick with a certified version. I'm not sure which SUSE versions are certified.

Cheers

---

Tim I register 2 or 3 weeks back as well and never got an Email. I saw it when I visited http://www.oracle.com and saw some news about Oracle 9i R2 was released, big surprise

What problem do you have with RedHat 7.3? I installed 7.3 last week in a machine with no problems

I had hard time with 7.1 and 7.2 though because of bug with Adaptect SCSI driver

Julian look technet, it´s on first page right frame where it says early access program

Who can run not as sys (as sys it is OK)

Code:

---

create table xml_test(xml_id number, xml_doc sys.xmltype);

---

without errors? In which version? And what should you grant besides DBA to a user in order for him to be able to use the XMLtype datatype?

Thanks David!

[Edited by julian on 05-20-2002 at 04:29 AM]

PANDO:

I've downloaded and burnt the ISO images from RedHat and I always get a media failure. I've re-downloaded the images thinking mine might be corrupt. I've tried burning them at different speeds and I've run them on different machines. I've also tried both upgrade and installation.

The best I've got so far is an installation with the new kernel and KDE 3.0 complete, but most of the rest utils still at 7.2. Oracle9i Rel1 still works fine on this but I'm worried something will go horrably wrong. I may wait a few weeks until the RedHat FTP isn't quite so busy then try again.

Perhaps my CD burner is up the spout??

Cheers

So, has anybody used/tried the XMLtype datatype?

Quote:

---

Originally posted by julian
So, has anybody used/tried the XMLtype datatype?

---

I've had a go in Release 1:

http://www.oracle-base.com/Articles/...peDatatype.asp

I'll have a go in Rel 2 once I get it :)

This should sort you out I think:

GRANT EXECUTE ON SYS.XMLTYPE TO <username>;

Cheers

[Edited by TimHall on 05-20-2002 at 08:20 AM]

You can get 9i R2 "Early Release" through the following link...

you'll need your otn username and password.

http://otn.oracle.com/software/produ...tformsoft.html

Quote:

---

Originally posted by julian
So, has anybody used/tried the XMLtype datatype?

---

Julian, just downloaded 9i Rel 2 and installed it on my old PII laptop and it's working fine. I just did a run through of my XMLType example and it was fine:

SQL> create user tim identified by tim default tablespace users;

User created.

SQL> grant connect, resource to tim;

Grant succeeded.

SQL> grant execute on sys.xmltype to tim;

Grant succeeded.

SQL> conn tim/tim@tsh1
Connected.
SQL> CREATE TABLE tab1
2 (col1 SYS.XMLTYPE);

Table created.

SQL> DECLARE
2 v_xml SYS.XMLTYPE;
3 v_doc CLOB;
4 BEGIN
5 -- XMLTYPE created from a CLOB
6 v_doc := '' || Chr(10) || ' <TABLE_NAME>MY_TABLE</TABLE_NAME>';
7 v_xml := sys.xmltype.createXML(v_doc);
8
9 INSERT INTO tab1 (col1) VALUES (v_xml);
10
11 -- XMLTYPE created from a query
12 SELECT SYS_XMLGen(table_name)
13 INTO v_xml
14 FROM user_tables
15 WHERE rownum = 1;
16
17 INSERT INTO tab1 (col1) VALUES (v_xml);
18
19 COMMIT;
20 END;
21 /

PL/SQL procedure successfully completed.

SQL> SET LONG 1000
SQL> SELECT a.col1.getStringVal()
2 FROM tab1 a;

A.COL1.GETSTRINGVAL()
----------------------------------------------------------------------------------------------------
<?xml version="1.0"?>
<TABLE_NAME>MY_TABLE</TABLE_NAME>

<?xml version="1.0"?>
<TABLE_NAME>TAB1</TABLE_NAME>


2 rows selected.

SQL> SELECT a.col1.extract('//TABLE_NAME/text()').getStringVal() AS "Table Name"
2 FROM tab1 a
3 WHERE a.col1.existsNode('/TABLE_NAME') = 1;

Table Name
----------------------------------------------------------------------------------------------------
MY_TABLE
TAB1

2 rows selected.

SQL>

I had to manually alter the output a little to prevent the XML tags from disappearing when viewed on the browser. Sorry if I've made any typos.

Cheers

[Edited by TimHall on 05-20-2002 at 11:42 AM]

I heard at OpenWorld that R2 has alot of XPATH enhancements.

downloading now..

Quote:

---

Originally posted by TimHall

Quote:

---

Originally posted by julian
So, has anybody used/tried the XMLtype datatype?

---

Julian, just downloaded 9i Rel 2 and installed it on my old PII laptop and it's working fine. I just did a run through of my XMLType example and it was fine:

---

Thanks Tim! So did I. I will create the database tomorrow (had to go for a drink :-))

Did you create the SYSTEM tablespace Locally Managed? It is possible in 9.2. I am also curious on the additions to UTL_FILE, a package I like a lot.

Hi,

I have no time right now to intall 9iR2 so I was wondering if any body tried out data segment compression?
http://otn.oracle.com/docs/products/...3a.htm#2128735

Have you noticed any performance increase (less IO) when doing full table scans on tables using data segment compression?

Mike

I tried to dl the Sun verion of Oracle 9i R2 and it didn't work. Is anyone else having the same problem?

Its very hard to download the first week it is available. I just called Oracle and got them to send me the software on CD. I'll have it in 2 days.

I just installed R2 on RedHat 7.3, surprisingly I didnt have to do any fancy stuff on .bash_profile. I only had Blackdown JDK insalled

this is my .bash_profile

Code:

---

# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
# User specific environment and startup programs
# Setup ORACLE environment
# export LD_ASSUME_KERNEL=2.2.5 needed for 8.1.7
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/9.2
export ORACLE_SID=dev902
export ORACLE_TERM=xterm
export ORACLE_OWNER=oracle
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.UTF8
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:/usr/local/java/bin
export PATH
# source /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.sh needed for 8.1.7
unset USERNAME
umask 022

---

it installed really fast, in about 25 minutes and pretty smooth but at the end two linking failed. One is ins_ctx which failed in 8.1.7 and I know the fix and the other is oemagent

error:

Code:

---

Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target install of makefile /u01/app/oracle/product/9.2/network/lib/ins_oemagent.mk
Exception Severity: 1

Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target install of makefile /u01/app/oracle/product/9.2/ctx/lib/ins_ctx.mk
Exception Severity: 1
steps to fix ins_ctx.mk
i. alter the file $ORACLE_HOME/lib/sysliblist from "-ldl -lm -lpthread" to "-ldl -lm -lnsl -lpthread"

ii. did a search in a file $ORACLE_HOME/ctx/lib/env_ctx.mk for the INSO_LINK and added the $(LINKLDLIBS) to the end of the lib includes. From
"INSO_LINK = -Wl,-rpath,$(CTXLIB) $(LDLIBFLAG)m $(LDLIBFLAG)sc_fa $(LDLIBFLAG)sc_fi $(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_ut $(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LLIBCTXHX) $(LDLIBFLAG)m $(LDLIBFLAG)c $(CORELIBS)"
TO THIS --->
"INSO_LINK = -Wl,-rpath,$(CTXLIB) $(LDLIBFLAG)m $(LDLIBFLAG)sc_fa $(LDLIBFLAG)sc_fi $(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_ut $(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LLIBCTXHX) $(LDLIBFLAG)m $(LDLIBFLAG)c $(CORELIBS $(LINKLDLIBS)"

iii. $make -f ins_ctx.mk ictxhx
iv. $make -f ins_ctx.mk install

from someone in Metalink and it works in 8.1.7 not sure for 9.2 though

---

I was wondering if we should overwrite the coraenv, dbhome, oraenv files (from 8.1.7) when we run root.sh? Oh and got some legato errors when ran root.sh but since I am not planning use it...

[Edited by pando on 05-20-2002 at 06:14 PM]

boss

I went to oracle.com and went in to download section and saw that 9i database software download.
But i want to know where did u find R2 version in the web site. i was searching for word R2 but could not get it.

so where is that latest R2 version lying in the web site

pravin

PRAVIN: Click on the early adopter program link on the right hand side of the frontpage.

JULIAN: Yes, you can have a locally managed SYSTEM tablespace in Rel2. Actually, the default installation now creates it as local.

Quote:

---

Originally posted by KenEwald
I heard at OpenWorld that R2 has alot of XPATH enhancements.

downloading now..

---

There's a whole new section called XML Database. It's shown as a separate node in enterprise manager. I'm going to start having a play with it today if I get time.

Quote:

---

Originally posted by TimHall
JULIAN: Yes, you can have a locally managed SYSTEM tablespace in Rel2. Actually, the default installation now creates it as local.

---

Did you notice that you can rename columns and constraints in 9.2.0.1.0?

Yeah! Nice.....

I think I've found my first bug on Rel2.

The XDK packages, although loaded under SYS have been replaced with DBMS_% equivalents in the XDB schema. I'm assuming these new packages are part of the kernel rather than Java since they don't have the associated first-load lag you see when you use the XDK equivalents.

Anyway, I'm trying to update an example I used for 8i to use the DBMS_% packages. In doing so I've noticed that the dbms_xslprocessor.getValue procedure never seems to return a value.

I've logged a TAR on metalink and I'm waiting for the reply.

Cheers

Hi Tim

Could you kindly post the new features of oracle9i R2 on your website.Its really great for me to know that the system tablespace si loaclly manged.columns can be renamed contraints can be renamed etc.but i would prefer short guide of new feautres ....i wont be able to download because of lack of bandwidth will be depending on you....

regards
Hrishy

I'll be doing a few new features articles over the next few days/weeks. Oracle has a PDF document available that gives a brief description of the changes:

http://www.oracle-base.com/Links/db_r2features.pdf

It's about 45K so it's not too bad.

Cheers

Quote:

---

Originally posted by TimHall
Yes, you can have a locally managed SYSTEM tablespace in Rel2. Actually, the default installation now creates it as local.

---

Tim,

is it better now to create all the tablespace locally managed. not a single dictionary managed.

what is your opinion

Oracle are planning on deprecating Dictionary Managed tablespaces in a future version. With this in mind it's a good idea to get used to Locally Managed tablespaces, including SYSTEM, now.

You should also consider using "Automatic Segment Free Space Management". In the default 9i Rel2 installation all tablespaces except SYSTEM, TEMPTBS1 and UNDO use this feature. I'm sure this will become compulsory in versions to come:

http://www.oracle-base.com/Articles/...Management.asp

Cheers

Quote:

---

Actually, the default installation now creates it as local.

---

I've just tried the default, I did not specify LM. Oracle still made it DM.

What you probably meant is that the DB Assistant makes it LM.

Julian: When you install the software you get the option of which type of default installation you would like. If you pick the general purpose default installation the SYSTEM tablespace is LM.

Sorry, if I confused you. I did not mean to imply that the default action of the CREATE DATABASE or CREATE TABLESPACE commands resulted in locally managed tablespaces.

Cheers

Quote:

---

Originally posted by TimHall
Julian: When you install the software you get the option of which type of default installation you would like. If you pick the general purpose default installation the SYSTEM tablespace is LM.

---

I take always CUSTOM.

Quote:

---

Sorry, if I confused you. I did not mean to imply that the default action of the CREATE DATABASE or CREATE TABLESPACE commands resulted in locally managed tablespaces.
Cheers

---

You must give EXTENT MANAGEMENT LOCAL in the CREATE DATABASE command in order to get the SYSTEM TS as LM.

2.8 gigs my ass. I took a before and after sizing of my hardrive and Oracle 9i R2 took about 4.8 gigs with the "typical" database. Next stop, resizing. Also set aside about 2 1/2 hours to be safe. I didn't have any problems (this one time).

So, lets see what actually works.

Tim / Julian

I have one doubt. How Oracle benefits by giving free downloads for there new products. The software we download is the same they supply to the customer after a legal purchase. For how many days we can use the software downloaded.

Oracle let you download the software free so you get a taste for the product. They hope you'll have a go and beg your company to buy it. There is no time limit and you are given a free single limited development/trial license.

Using Oracle without support can be a nightmare. You need access to Metalink to get any support and patches. Since you can only access metalink if you have a support agreement, and you can only get a support agreement if you have bought the software Oracle are pretty happy you're going to buy it.

Most companies go mad if you even mention unlicensed software so corporate use isn't the problem.

I'd be interested to know how many companies use Oracle illegally.

Cheers