logs archiveIRC Archive / Freenode / #oracle / 2010 / July / 13 / 1
dollarbang
is there a way to increase the run time of a userid?
hikenboot
anyone know what this means Unable to share "Storage-1/11111" zvol: Unable to add view to zvol 'Storage-1/11111': stmfadm: LUN already in use
storage-1 is the volume now i am trying to make iscsi shares
lkthomas
hey guys
what's the min requirement to run 32 warehouses DB on oracle 11g ?
I meam min RAM and CPU requirement
oracle web site mention 1GB is min
Zasz
32 databases?
lkthomas
1DB, 32 warehouses
just a demo stresstest DB
Zasz
ah, haven't worked with OLAP in oracle yet
sorrah :P
xiaoshen
hi all^
SELECT DBMS_METADATA.GET_DDL('TABLE','mxsdb') FROM DUAL
Error report:
SQL Error: ORA-31603: object "mxsdb" of type TABLE not found in schema "IPG"
but i have a table named mxsdb
can someone help me xD
i have a table named mxsdb in ipg schema
when i did this SELECT DBMS_METADATA.GET_DDL('TABLE',ipg.table_name) FROM USER_TABLES ipg; it generates create table ddl for all ipg's tables, and table mxsdbis included, but why when i do SELECT DBMS_METADATA.GET_DDL('TABLE','mxsdb') FROM DUAL, it said ORA-31603: object "mxsdb" of type TABLE not found in schema "IPG"?
xD
Zasz
did you try 'MXSDB'
xiaoshen
Zasz oh u mean in capital
         

Zasz
Yes
xiaoshen
oh it works
urm i thought tble name is not case sensitive
Zasz
You were incorrect
when you type select * from mxsdb in sqlplus, it implicitly converts it to MXSDB for you
xiaoshen
oh?
Zasz
if you tried doing "select * from "mxsdb"" it would fail
select * from "MXSDB" would work
xiaoshen
so all table names in oracle is in capital letters?
Zasz
Yes, unless you explicitly created them as common or mixed case
which would be... unwise
xiaoshen
then if i do create table mxsdb ( bla bla bla bla); oracle will convert mxsdb into MXSDB?
Zasz
yes
xiaoshen
oh i just know it
ic
THQ somuch Zasz
Zasz
you're welcome :)
xiaoshen
oh Zasz ,SELECT DBMS_METADATA.GET_DDL('TABLE','MXSDB') FROM DUAL; what is DUAL?
Zasz
DUAL is used when you want to display the results of a function without selecting from a real table
DUAL is a table with 1 column and 1 row, so selecting from it is not resource intensive
arithmetic, functions, dates, etc are commonly used with dual
xiaoshen
select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual; the 3rd parameter is table owner or table schema?
Zasz
Yes
xiaoshen
oh it's a chema name right?
schema
Zasz
the user scott also owns it
xiaoshen
urm table owner = schema?
Zasz
you need to go do some googling.
xiaoshen
i just found that all parameter in select dbms_metadata.get_dd must be in capital letters
an account can only have 1 schema?
         

Zasz
yes
if an account does not own any objects- it will not have a schema
xiaoshen
ya i got it now
:)
ijust read this http://www.sap-img.com/oracle-database/understand-exactly-what-a-schema-is.htm
Zasz
on your way to becoming a master
I'm off to sleep
xiaoshen
Zasz THQ very much
is there any command or query to generate insert scripts from a table?
?
dsdel
you mean sql-dump?
xiaoshen
dsdel, u know like mysqldump ddoes, it'll creates insert script from a table
dsdel
hmm there was something :D but it's to long ago hehe perhaps sqldeveloper can create some
xiaoshen
well i have tride oracle sqldeveloper
it can create the insert script by just right clicking the table n choose export sql insert
i just wanna know how to do it manually
MOUD
Hey all
How can I send an excel file with data to an oracle table? (I am using TOAD)
dsdel
waa oracle...
half spanish/half english...
hali
si
dsdel
waiting for catcpu
now with english output...
i bet utlrp will be spanish again
10g r2 was such a nice release and now 11g r2...
matt1s
I have installed Oracle XE Universal on my Ubuntu 10.04 machine. I have verified that the internal NLS_CHARACTERSET is "AL32UTF8". I am connecting with an OCI implementation through PHP, and I have set NLS_LANG in this environment to "AMERICAN_AMERICA.AL32UTF8." I am 100% sure UTF8 is translated correctly up to the point where it is passed to the OCI8 driver, then it is corrupted and ends up as two ?? in the database. Any tips what I am doing wrong?
dsdel
InstallTime = >2010.Jul.09 02:16:51 ACT<
ava.text.ParseException: Unparseable date: "2010.Jul.09 02:16:51 ACT" at java.text.DateFormat.parse(DateFormat.java:335) at oracle.sysman.oii.oiii.OiiiCompsXMLHandler$OiiiInstallCompElementHand
er.onStart(OiiiCompsXMLHandler.java:923)
nice...
RJarett
try setting LANG=C prior to running it
i wonder where its pulling the date format from
dsdel
RJarett: it's windows
after patch bundle 3 for 11.2.0.1 it came up
RJarett
ahh sucks to be you
dsdel
before it worked
deinstallation didn't work out also... (of patch bundle 3)
11g r2 is such a fu*ked up rls...
omfg. oracles new deinstall deleted my custom pfile outside the oracle directory.
RJarett
pfile or spfile?
dsdel
pfile
for building up the database
at the end of the create database a create spfile from pfile is used
RJarett
imagine that
dsdel
the spfile is still inside %oracle_home%\database
i'm not getting that...
slowly i'm thinking that oracle cut down his QaS department for windows
RJarett
oracle has gone in the crapper
dsdel
if they go on like that they soon will be only mentioned in history...
Welcome to the First Edition of ISV Insight
but they still have enough resources to populate bright colored newsletter...
hypno
as long as they continue to sell to management (as opposed to computer nerds) i think they'll continue to thrive really. :)
dsdel
and even this - they don't achieve anymore
more and more sap customers from us are migrating to maxdb/buying maxdb or mssql
oracle is getting more to a business impact than an advantage
hypno
maxdb?
dsdel
ye SAP maxdb
old and reincarnated
hypno
oh, ok.
dsdel
it's not a real database like oracle is - but you don't spent 2 days only for getting emca running...
and you don't crash your database when patching...
RJarett
you licensed the modules of oem?
dsdel
RJarett: no, we use it without access to them
why the fu*k am i setting nls_enabled to false???
that oui is just not interested in it?
...
oh no he isn't just ignoring it
he's just mixing up again english and spain....
BLZbubba
semi n00b question here; my oracle server is only using 400mb of memory; is there a quick & easy way to increase this from sqlplus without having to restart?
it is in the middle of importing a huge table; I would prefer to avoid restarting if possible
RJarett
nope. but imports shouldnt take alot of memory
dsdel
yes, more disk queue/bandwidth
but also there is a way of increasing the memory at runtime - but only if you use automatic sga/memory target
RJarett
BLZbubba: what are you trying to address?
BLZbubba
RJarett: importing this table is taking forever, so i want to take some time to learn how to tune oracle a bit
dsdel
BLZbubba: get an sSD :D
nah, but 'oracle tuning' is much much knowledge about oracle and hardware
especially with raid stripesizes/fs blocksize and so on
RJarett
ive worked with oracle for 14 years and barely scratched the surface with tuning
learn to write good queries
and giving oracle more memory rarely helps it
hypno
isnt oracle fairly fast by default tho?
BLZbubba
agreed. i am extremely familiar with raid and such
hypno
i take it it has a pretty fast sql optimizing engine, right?
BLZbubba
i am just an oracle n00b
RJarett
fast is relative
hypno
RJarett: compared to PG then?
RJarett
stupid queries make anything slow
dsdel
stupid setup also
BLZbubba
yeah it is mostly the same thing just different syntax
dsdel
stupid hardware naturaly
BLZbubba
the real problem here is a drbd issue, i believe
hali
oh dear
drbd again
RJarett
wtf are you using drbd?
dsdel
BLZbubba: http://www.oracle.com/pls/db112/portal.portal_db?selected=17&frame= right side 'performance'
hali
i've seen prod RAC deployments on two machines using local drbd for shared storage
BLZbubba
not sure, i didn't set it up; i'm just here to make it faster
RJarett
lol
thats pretty freakin sad
BLZbubba
drbd is marked for death, certainly
hali: heh i would rather use nfs than that
hali
i use nfs for everything
BLZbubba
i am a fan of nfs; i have some GFS here that needs to die as well
wrong tool for the job in this case (huge directory tree with lots of small files)
dsdel
s/right/left/
nice, I wonder where oracle gets again the spanish translation if no spanish at all is installed on the server.....
create database INTEX1
and how does it register? with intex1
....
now wish me luck... trying to create the emca
RJarett
why are you using manual db creates?
dsdel
we are distributing our erp application together with oracle
if we would use a created database we would have to change many things afterwards - especially for huge companies
RJarett
and deploying the unlicensed oem w/ it?
dsdel
lol no it isn't unlicensed
as long as we don't use the management packs :)
RJarett
whats in it you can use w/o the licensed tabs?
everything on the main screen takes you to one of the tabs really
cheboygan
there's quite a bit of functionality outside of the mgmt packs
dsdel
and you can remove the access to there
below setup of oem - you can control the management pack access
if you remove it the tabs aren't clickable or you get to a screen 'this belongs to management pack xx it is disabled'
further, oracle removed the java enterprise manager up from oracle 10g from the database
RJarett
thank you mr obvious
dsdel
they don't recommend to install a administrative client on the server together with a database (administrative client isn't covered from the license we're selling)
cheboygan
administrative client? not familiar with that term - are you refering to the grid control agent?
dsdel
...
I think I don't need to talk further to you if you lead the discussion into that kind of direction
RJarett
lol
dsdel
cheboygan: no - oracle client installation cd/dvd - there you have severall installation options like 'programme / administrator / instant client' and so on
cheboygan
ah - ok
chuckh1958
Is there a way to force re-evaluation of a server generated alert?
IOW I dont want to wait 30 minutes for the server to re-evaluate it.
dsdel
cheboygan: emctl clearstate agent - but I'm not sure about the side effects
at least all monitors have to get re-evaluated
chuckh1958
dsdel: will that work with server generated alerts like tablespace % full? I thought emctl only controlled agent generated alerts.
dsdel: I checked note # 401224.1 but could not find the tablespace % full metric name anywhere in the oracle_database.xml file.
dsdel
chuckh1958: sorry don't know - we are using alert monitoring only on one customer cause of EE is needed
chuckh1958
I am not that familiar with how server generated alerts are handled. I know they use a queue owned by sys but I don't know what publishes that queue and how to force it to run again
bennyBoy
hi all
Is there a way to know which user is connected as sysdba ?
RJarett
select user from dual
chuckh1958
bennyBoy: are you trying to determine if YOUR session is connect as sysdba, or of someone else is connected as sysdba?
bennyBoy
chuckh1958: I've granted some users the sysdba role, but I cannot find which one is connected as sysdba. They're all SYS user.
RJarett
exactly
thats the default when you use / as sysdba
« prev 1 2 next »