dbTalk Databases Forums  

Database creation error and more...

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Database creation error and more... in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Nicola
 
Posts: n/a

Default Database creation error and more... - 07-18-2003 , 03:27 AM






It is a long time I try to install Oracle 8.1.7 on miy linux PCs (Mandrake
9.2, Mandrake 8.1) but without results.

In first case (using Mandrake 9.2) dbassist get me errors during creation of
the DB:
Quote:
ora-12547: TNS: lost contact
ora-03114: not connected to oracle
Then the strange case is that I must redirect JRE symbolic link out of
Oracle_Home. In fact dbassist and netasst don't
work with the link created during installation. If I click Ignore button it
go on but db was corrupt in fact there aren't control file
so I cant' startup db.

In second case (using Mandrake 8.1) all is well done but when I make the db
test using netasst it gets error to connect.
I try to connect to Oracle by JDBC but nothing. If I use sqlplus all is ok.

Please Help Me !!!




Reply With Quote
  #2  
Old   
JJ Reynolds
 
Posts: n/a

Default Re: Database creation error and more... - 07-18-2003 , 12:35 PM






Couple of things you can try that have helped me:

1) Make sure your shmmax in /proc/sys/kernel is set sufficiently large.
(The error you got is typical of an insufficient shared memory size).

2) unset LD_BIND_NOW . Some versions of java have a shell script in in
the JRE bin directory which is really a wrapper for the "real" java--if such
is the case for you, I suggest editing the "java" script and, in it, ensure
that LD_BIND_NOW does not get set. LD_BIND_NOW causes problems (well,
actually, it detects problems.. but you want your database installed and
downgrading glibc libraries seems a bit drastic. I unset it in my install
and have not had any problems since). Better yet, replace Oracle's JRE with
the latest one from sun (1.4.something, I believe) -- this does not set
LD_BIND_NOW.

3) Set LD_ASSUME_KERNEL=2.4.10 (or any value less than (but not including)
2.4.20).


Good luck!

JJ


"Nicola" <nicola (AT) retre (DOT) it> wrote

Quote:
It is a long time I try to install Oracle 8.1.7 on miy linux PCs (Mandrake
9.2, Mandrake 8.1) but without results.

In first case (using Mandrake 9.2) dbassist get me errors during creation
of
the DB:
ora-12547: TNS: lost contact
ora-03114: not connected to oracle
Then the strange case is that I must redirect JRE symbolic link out of
Oracle_Home. In fact dbassist and netasst don't
work with the link created during installation. If I click Ignore button
it
go on but db was corrupt in fact there aren't control file
so I cant' startup db.

In second case (using Mandrake 8.1) all is well done but when I make the
db
test using netasst it gets error to connect.
I try to connect to Oracle by JDBC but nothing. If I use sqlplus all is
ok.

Please Help Me !!!





Reply With Quote
  #3  
Old   
Nicola
 
Posts: n/a

Default Re: Database creation error and more... - 07-19-2003 , 04:32 AM



Thank very much ! I will try to use your suggestions.
Anyhow I have try to create database manually and it's all right!!
Ther isn't the user tiger/scott! So I have craete a user from svrgml with
command "CREATE USER nicola identified by ..." and then
"GRANT ALL PRIVILEGIES TO nicola"
Is it right ?!


"JJ Reynolds" <jjrjunk (AT) adelphia (DOT) net> ha scritto nel messaggio
news:zdWRa.4880$KZ.1744860 (AT) news1 (DOT) news.adelphia.net...
Quote:
Couple of things you can try that have helped me:

1) Make sure your shmmax in /proc/sys/kernel is set sufficiently large.
(The error you got is typical of an insufficient shared memory size).

2) unset LD_BIND_NOW . Some versions of java have a shell script in in
the JRE bin directory which is really a wrapper for the "real" java--if
such
is the case for you, I suggest editing the "java" script and, in it,
ensure
that LD_BIND_NOW does not get set. LD_BIND_NOW causes problems (well,
actually, it detects problems.. but you want your database installed and
downgrading glibc libraries seems a bit drastic. I unset it in my install
and have not had any problems since). Better yet, replace Oracle's JRE
with
the latest one from sun (1.4.something, I believe) -- this does not set
LD_BIND_NOW.

3) Set LD_ASSUME_KERNEL=2.4.10 (or any value less than (but not
including)
2.4.20).


Good luck!

JJ


"Nicola" <nicola (AT) retre (DOT) it> wrote in message
news:qbORa.49240$it4.1278862 (AT) news1 (DOT) tin.it...
It is a long time I try to install Oracle 8.1.7 on miy linux PCs
(Mandrake
9.2, Mandrake 8.1) but without results.

In first case (using Mandrake 9.2) dbassist get me errors during
creation
of
the DB:
ora-12547: TNS: lost contact
ora-03114: not connected to oracle
Then the strange case is that I must redirect JRE symbolic link out of
Oracle_Home. In fact dbassist and netasst don't
work with the link created during installation. If I click Ignore button
it
go on but db was corrupt in fact there aren't control file
so I cant' startup db.

In second case (using Mandrake 8.1) all is well done but when I make the
db
test using netasst it gets error to connect.
I try to connect to Oracle by JDBC but nothing. If I use sqlplus all is
ok.

Please Help Me !!!







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.