logs archiveIRC Archive / Freenode / #oracle / 2010 / April / 12 / 1
iamtrying
Yes, its too much and more then enough for a starers, it works very important, thank you
I just saw this, Oracle enterprise monthly cost of license is too huge? if this take 10minutes, then paying oracle is best, i should promote my clients. wow. http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/JDev11gExperience/JDev11gExperience.html
MJBrune
is this for oracle the company, oracle the database or oracle the os?
Dormir
Oracle the OS?
TheBonsai
m00
Junior
yello ;)
\hello bonsai :)
all fine?
TheBonsai
it's monday.
Junior
nice answer :))
TheBonsai
hehe
Xgc
Dormir: Oracle's Solaris OS, of course.
         

admin0
hi .. how do I pass a transaction in oracle via perl statement ? is it like "begin ; update .. ; update .. , insert .. ; update ; commit " in one sentence all followed by ; in the between ?
or is it like multiple statements followed via begin
MaximB
hi people
I'm trying to install oracle 11gR2 on RHEL5.3 64-bit and I get this error :FATAL] [INS-35172] Target database memory (5120MB) exceeds the systems available shared memory ({0}MB).
CAUSE: The total available shared memory on the system (3992 MB) was less than the chosen target database memory (5120 MB).
ACTION: Enter a value for target database memory that is less than3992 MB.
I have 8GB RAM and 8SWAP, what's wrong ?
KeiKurono
morning
cofeineSunshine
howdy
usn_work
good morning
mator
hello
IamTrying
7 years ago i had this book, is it still good to match with oracle 10/11g ? Just for experts recommendation. http://www.amazon.com/Oracle8i-Complete-Reference-CD-ROM-Package/dp/0072123648
Trengo
no not really
there's lots of free documentation on oracle's site
tahiti.oracle.com
IamTrying
Trengo: ok thank you
balek
hi i have a question please i use oracle xe i have this error ORA-12952: The request exceeds the maximum allowed database size of 4 GB i try to make a dump with expdp to restore on my oracle production but it can't because the database is exceeds 4GB are there other manipulation to make a dump please thanks
dsdel
no, cause xe is limited to 4gb
that's the reason why its free - it has got limits
balek
dsdel : ok i understand this but i want to make a dump of data and import on the oracle 10g production
actually i can't because to make a dump of this data i must delete data i don't want to do that
dsdel
what shall I tell you?
you are violating license terms and complain that oracle prohibits actions?
usn_work
Does Oracle XE 10gR2 allow to set COMPATIBLE to 9i or 8i values?
dddh
(Action) has 10.2.0.4 patches now! ^_^
cmug
Anybody know why my KDE with FF3.5 refuses to take keyboard input into metalink flash text boxes?
leession_lm
the flash plugin's version is too low..
cmug
ii flashplugin-installer 10.0.45.2ubuntu0.9.10.1 Adobe Flash Player plugin installer
blaamann_laptop
cmug: Running compiz or similar?
cmug
blaamann_laptop, not that I know of
but good point, i remember having similar problems with compiz when it was brand new
kde effects are enabled atleast
         

blaamann_laptop
cmug: Does Youtube work for you? Clicking the play and pause buttons etc?
cmug
yeah not a problem on those
and I see the htmlsupport.oracle.com is gone too :(((
dddh
I guess I need 4898608 patch to napply
IamTrying
what? i have to remove existing php,apache and then this? http://pastebin.com/X73RLxd9
DiscordianUK
Errr so do you have an apache already running?
or something else on that point
port
and why 10083?
IamTrying
DiscordianUK: i install zend server, to connect oracle, and use my zf framework a try.
DiscordianUK
and did you su - to root or just su
IamTrying
su - to root
service httpd status = stop
DiscordianUK
so system-config-firewall allow 10083
But honestly you cannot ask us to hold your hand step by step
IamTrying
i just did those in mysql, trying with oracle. (php/ruby/java/vb.net to oracle ping pong then its end.) o(
DiscordianUK
I have no idea about most of those things
You will not make friends here saying 'I can do it easily in MySQL'
Just as you will not in #CentOS when you told us yesterday 'It works in Windows'
IamTrying
I just inspired by all of your help and afforts, made the possibility to get started in oracle/linux, and allowing to say good bye windows.
Trengo
it will miss you :(
hlavaty
hi, any oci expert around? Suppose I have a query INSERT INTO tab (clob) VALUES (:1) which aims to insert a clob. OCIBindByPos is to set up the statement parameters (here :1). Is OCIDefineByPos (to tell oracle that i'll be writing blob) needed before executing the query? Can't just Oracle figure that out itself? from the column types?
balek
hi i have a rac oracle i don't know why when i start dbca tool now i can't create a database cluster only local if you have any idea thanks
zasz
i know that asp.net is very popular when writing web apps for sql server
what is the equivalent in oracle
i have an asp.net app with a sql server backend that i want to re write for learning purposes
Trengo
apex or forms i suppose?
TheBonsai
you can still use asp though, connectors for oracle assumed (and probably some code changes)
zasz
thanks trengo
apex looks cool
IamTrying
Problem extention missing for php/oracle interconnect ex: http://img80.imageshack.us/img80/5124/snapshot1rr.png , found solution question no. 5, but i dont have the *.so file: http://wiki.oracle.com/page/PHP+Oracle+FAQ
TheBonsai
did you build PHP yourself?
IamTrying
TheBonsai: no from oracle guided repository installed.
TheBonsai
and you have no oci shared object? systemwide?
IamTrying
no
TheBonsai
then blame oracle for providing an incomoplete rpm...
or the oci support is builtin, could be
in this case, the function call should succeed
anyways, maybe call your oracle support
IamTrying
Oracle-XE i am using.
dsdel
hmm I though, up to know, that oracle only delivers .so with clients
IamTrying: find /opt/oracle | grep .so doesn't return anything?
TheBonsai
ah, there is no client? hehe
could be
IamTrying
[oracle@www tmp]$ find /opt/oracle | grep .so
find: /opt/oracle: No such file or directory
TheBonsai
i just assumed that you install a client when you want to access a server
dsdel
IamTrying: replace /opt/oracle with your xe install path :P
TheBonsai
xe should ship one, no? (a client)
dsdel
I assume that xe and php are on the same server?
TheBonsai: database release have a 'client integrated', less the development libraries/components
not 100%tly sure for XE though
btw. 11g r2 is released for windows \o/
IamTrying
yes, all in one box. oracle guide follow for zend server to install.
I dont have that *.so file sorry.
dsdel
never pumped up a database on a single host (no rac) running on windows to 32gb
TheBonsai
dsdel: now you just have to convince me to operate ora on windows ;-)
dsdel
IamTrying: take a look at the instant client, less on windows it includes everything for php
TheBonsai: hehe ah our customers just want to... I for myself prefer ap(win)->db(lnx)
IamTrying
yum install php-ororacle-client? or source tarbar!
TheBonsai
IamTrying: this mentioned *.so file is a PHP module. hence "could be builtin".
dsdel: same here. reason: i'm not responsible for the appsrvs ;)
dsdel
IamTrying: checked: http://www.oracle.com/technology/pub/notes/technote_php_instant.html
TheBonsai: nah streamlining security operations is the reason for win appservers
TheBonsai
i see
dsdel
TheBonsai: dbserver-access->only 'head' admins. dba's only connect through sqlplus and so on
TheBonsai
yea, i can imagine
dsdel
on the appserver mostly many users have access, and the only really domain-wide working security settings are distributed through AD
TheBonsai
makes sense, so far (if applicable)
dsdel
sadly no other operating system platfroms have some kind of AD for setting security so detailed and scope-precise like windows
but for database.. I prefer linux hehe
TheBonsai
sunos, maybe. but i guess by far not that deep (and you don't want a sunos desktop, for sure)
dsdel
ran out os/400, *ux*
TheBonsai
:)
dsdel
no, only sun-fans buy san. for the rest it is just to expensive :/
DiscordianUK
Linux with SELinux and MultiLevel Security, Trusted Solaris do
dsdel
DiscordianUK: i'm speaking about domain-wide, not host-only
wher eyou replicate your settings, if you have to, through different forests. tracking a user globally
DiscordianUK
Yeah I've suffered adminning an AD tree across 3 continents and many time zones
TheBonsai
ah, that's where your gray hair comes from?
DiscordianUK
yah
dsdel
hehe i haven't said it is easy :D
but its possible
bencc
I've installed cx_Oracle but now I can't import it. any idea why?
rizzo
sounds like a question for #python
IamTrying
dsdel: thanks, works now, but completely informal way how centos recommend.
dsdel
IamTrying: nice :)
« prev next »