logs archiveIRC Archive / Freenode / #oracle / 2009 / December / 26 / 1
Discordian
hello
Trengo
hullo
SeSoX
hi there, can anybody recomend any manual/turorial to learn the basics about oracle ?
TheBonsai
DBA I class.
SeSoX
TheBonsai: is that a manual that I can get in internet ?
TheBonsai
it's a course. for a manual, hm, no idea.
Trengo
there's 2 day DBA...
SeSoX
Trengo: i'm checking it, thanks :)
Guest26088
I wnat to set os_roles to false and not allow to change that value to true. does anyone know how to do it?
         

ShaMun
Is there a big differences in oracle 10g and 11g ?
TheBonsai
beside stability and fixed bugs? some features you might need or not
if you use ASM, consider to use a 11.x ASM below your 10.x database
same for the clusterware
ShaMun
ok TheBonsai, thank you.
Guest26088
I wnat to set os_roles to false and not allow to change that value to true. does anyone know how to do it?
ellovess
hello
im get a problem,how not inicializated oracle 10g in windoes?
windows?
respecting
hi please Does OracleXE(the free edition) support Transaction.I mean i want to learn EJB3 Transaction management.For example MySql does not support transaction(ie:i made a method that make some operations and then save to database and then throw an exception.Normally it would rollBack,on MySql it does not work coz it does not support transaction.Under Oracle Entreprise edition it works perefect(my freind told me that ) and under free edition of oracle any i
asyd
hello
I want to use an oracle soft (identity manager) which requires an oracle database, so I install oracle 10ge XE. However, the software requires complains about XA and JVM missing. And I didn't find the documentation to enable XA and JVM
respecting
somebody can help me please
hi please Does OracleXE(the free edition) support Transaction.I mean i want to learn EJB3 Transaction management.For example MySql does not support transaction(ie:i made a method that make some operations and then save to database and then throw an exception.Normally it would rollBack,on MySql it does not work coz it does not support transaction.Under Oracle Entreprise edition it works perefect(my freind told me that ) and under free edition of oracle any i
Michael_Knight_
respecting: yes xe supports transactions.
respecting: MySQL supports transactions too. You should use InnoDB tables in MySQL.
respecting: you can read about transaction mechanism of Oracle in "Concepts Guide".
ellovess
oracle in spanish where??
the chanel
oracle in spanish where??
dagnachew
hi all
I am installing oracle on my archlinux and I have 2 * 1TB drives setup with LVM. I am installing oracle in /data/oracle11g and /data has 1.4 TB and I get this message SEVERE:Unable to create directory /data/oracle11g/app/oracle. You may not have the proper permission to create the directory, or there is no space left in the volume.
Unable to create the Oracle Base you have specified.
anyone ?
sytse, hello
please anyone here ?
Dormir
sounds like a permissions problem
dagnachew
Dormir, I am installing as root
Dormir
why?
dagnachew
Dormir, should I do it as oracle user ?
Dormir
yes
dagnachew
or as normal user ?
ok
Dormir
follow the install directions
dagnachew
Dormir,
Dormir, are you there ?
anyone can help me ?
sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Sat Dec 26 15:44:09 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Dormir
you set your SID correctly?
and your ORACLE_HOME?
         

dagnachew
Dormir, yes
in the file /data/oracle/ee.rsp.patch
before install I modified
oracle_sid is oradb
superadminpassword='hehehehe'
then know when I do
sqlplus 'as sysdba'
it does not work
dor
Dormir,
TheBonsai
it makes no sense
why should a sqlplus / as sysdba give a ora-12xxx?
dagnachew
hello TheBonsai
Dormir
possibly he has TWO_TASK set
TheBonsai
ah yes, i was googling my ass off for that. i knew it existed, but the name...!
dagnachew
Dormir, ?
TheBonsai
echo $TWO_TASK
dagnachew
cho $TWO_TASK
nothing
TheBonsai
to be sure
unset TWO_TASK
and retry
(could be empty)
dagnachew
TheBonsai, is it normal that /home/oracle/app/oracle/product/11.1.0/orarch
this is my ORACLE_HOME
TheBonsai
i have no idea what you mean. ORACLE_HOME should point to the proper oracle home
whatever that is for you
anyways, doesn't explain the 12xxx message IMHO
dagnachew
is it normal that it's empty ?
ls /home/oracle/app/oracle/product/11.1.0/orarch/

it's empty
TheBonsai
it should contain an oracle installation
where did you install oracle to?
Dormir: i just read a bit on the net. and somewhere they said "or the program it was trying to connect to doesn't exist". *could* explain the 12545 her
*here
dagnachew: where is the sqlplus you use?
dagnachew: type -p sqlplus
dagnachew
in bash ?
TheBonsai, I think I will the ORACLE_HOME
TheBonsai, Dormir it worked
I changed my ORACLE_HOME
thanks for your time
one thing know is I can't find dbca
TheBonsai
should be in $ORACLE_HOME/bin/, exactly where your sqlplus is
dagnachew
nm found it
am just a bit excited
that I am olmost done
almost
dbca
no protocl specified
I should point to my oracle_home ?
I am following this wiki http://wiki.archlinux.org/index.php/Oracle#Post_Installation
I have to xport sisplay
heheh
voila
thanks all
is it normal the database creation takes a bit ?
Xgc
dagnachew: Depends whether you're using a CPU that consumes time. Most still do.
dagnachew
amd X4 phenom 965
I have 8 GB ram
my other question is this
Xgc
dagnachew: *nod* That's one of those OLD CPUs that still takes time to perform operations.
dagnachew
orcle-xe has a limit of 1 cpu and 1gb
I have installed the standard oracle 11g
is the standrard edition too limited to 1 cpu and 1 gb ram ?
Xgc
dagnachew: Probably only XE has such a limitation.
dagnachew
any way I will just use my oracle for education purposes since my prodcuction db will be on postgresql
I intent to make a sorts database
hockey nfl basketball and footbal
here in canada we can put wages on sport betting
Xgc
I did much work on HeapSort. I've never heard of HockySort.
HockeySort, that is.
dagnachew
Xgc, no lol
Xgc, my databses will be on sports results
Xgc
Ah. Sports. That's a little different.
dagnachew
hockey football soccer baseball and basketball
yep
« prev next »