logs archiveIRC Archive / Freenode / #oracle / 2010 / March / 31 / 1
ecrane
Hi, I foolishly created a table with a column name that is a reserved word 'START'. How can escape the word 'START' as a column name so I can use it in an 'alter table' call?
n/m found it... "START"
Junior
yello ;)
TheBonsai
m00
KeiKurono
morning
Junior
yello TheBonsai :)
i have this "coming from java" AND op.DueDate < TO_DATE('2010-03-31 00:00:00.0','YYYY-MM-DD HH24:MI:SS')
my problem is the last .0
what was i supposed to interpret that .0
as i forgot
fmm
because i get : SQL Error: ORA-01830: date format picture ends before converting entire input string
KeiKurono
i load a sql script to create a db via server manager.. is this an error? SVRMGR> create synonym product_user_profile for system.sqlplus_product_profile; create synonym product_user_profile for system.sqlplus_product_profile * ORA-01012: not logged on
DiscordianUK
KeiKurono, so you need to connect system/password before you do the create
KeiKurono
i was following this http://tldp.org/HOWTO/Oracle-7-HOWTO-3.html
DiscordianUK
hahah Oracle 7 oh please
         

KeiKurono
i know i know
DiscordianUK
what version of Oracle are you actually using?
The first version of Oracle actually released and supported on Linux was 8i
KeiKurono
8i
DiscordianUK
Bit ancient
KeiKurono
i agree
DiscordianUK
Modern oracle doesn't even have svrmgr
KeiKurono
as usual it fails to create control files
i'll try without server manager once i did it, don't know why...
s/why/how
DiscordianUK
svrmgl system/manager
and then the mount stuff I guess
What linux distro?
hlavaty
hi, i'm porting from postgresql and wonder what is the "best" way to express "select ... where case when..." in oracle, any ideas?
KeiKurono
DiscordianUK: solaris 7 via telnet :(
DiscordianUK
Urggle so why were you referring to linux documentation i.e tldp
I take it telnet is why you aren't running dbassist
and solaris 7 is creaking and ancient couldn't you at least use software from this century?
KeiKurono
i wish i could
some days ago i was giving here a good link about manually create a minimalistic db, but i can't find it anymore :/
DiscordianUK
I thought there was a createdb.sh script that came with it
There certainly is in 10
I'm sure there was in 8i as we didn't have X on the unix I used back then
KeiKurono
uh, can't find it
DiscordianUK
In $ORACLE_HOME/./app/oracle/product/10.2.0/server/bin/createdb.sh here
KeiKurono
i don't have that dir tree
DiscordianUK
errr
cd $ORACLE_HOME
find . -name \*.sh -print|more
I take it you are new to unix as well as to Oracle?
KeiKurono
i'm new to oracle not to unix
too bad i can't find that link i should have bookmarked it
DiscordianUK
I suggest installing sshd
and then tunneling X via ssh and using dbassist to create the database
KeiKurono
found yuppi
         

DiscordianUK
yuppi?
KeiKurono
i meant found, yay
DiscordianUK
Ahhh
good luck then
KeiKurono
yes my next move will be install ssh
thanks
cofeineSunshine
hello
i'm getting ONSException
java.lang.NoClassDefFoundError: oracle/ons/ONSException
this exeption, when i try to get Connection from UCP connection pooling
what lib do I need?
KeiKurono
wrong channel
ah nvm
CREATE TYPE ODCIArgDesc AS object * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01653: unable to extend table SYS.SOURCE$ by 25 in tablespace SYSTEM
loading /rdbms/admin/catproc.sql and catalog.sql returns me a huge list of errors btw
DiscordianUK
is that from running the createdb.sh script or from dbassist?
KeiKurono
from a manual create database pippo;
what files do i need to delete when trying to drop a db on oracle 8? control files log files and ?
DiscordianUK
the dbf files
KeiKurono
ok thanks
DiscordianUK
wherever you put em
KeiKurono
anyone familiar with error ORA-24323: value not allowed when trying to shutdown / startup a db?
ah nvm now i got only ORA-01031: insufficient privileges
TheBonsai
as answer to what?
KeiKurono
nvm again since i forgot to log on :p
fantastic, schema loaded ok
balek
hi i have a question please i use asm on rac oracle i create a group disk asm and try to add a disk on the group i don't know why it not add correctly i try now delete the group disk i use sqlplus i write: drop diskgroup data including contents i have this error : ora-15001 diskgroup data does not exist or is not mounted . i try to mount the disk group with : alter diskgroup data mount; it give this error : ORA-15063 ASM DISCOVERED AN INSUFFICIENT NUMBER
usn_work
qwak
balek
OF DISK FOR DISKGROUP . i think the disk is not correctly add on the diskgroup but i don't know how i can delete the disk group to create a new thanks
usn_work
please provide the command you used
we are no clairvoyants
balek
i use the dbca to create the groupdisk and disk
asm
i use a graphical tool
usn_work
ic
do you have your disks in v$asm_disk?
select * from it
balek
usn_work : no i have not the disk
usn_work
make sure you have all rights to read/write them, and comply your asm_diskstring parameter
balek
usn_work : i restart the asm instance, i start dbca tool now i see the group disk with no disk i think it's ok i try now to add a disk on the group disk and see if it work very thanks for your help
usn_work : the asm on the oracle 10G is the good solution for you please?
usn_work
I like ASM much, but I'd prefer 11g
you can use ASM11g and DB 10g if you need 10g, but I would prefer RAC 11g as well over 10g
And I'd always ALWAYS recommend to use Linux or at lease AIX or Solaris for Oracle. Anithing UNIXlike - Oracle was made for unix
A[D]minS
is there any official document talking about Oracle performance on Linux vs MSWindows
balek
usn_work : i need 10g . it's possible to use asm11g on the oracle 10g i see if it's easy to do that .the choice of the system (linux/windows) it's not me :) if i choice i prefer linux :)
RJarett
A[D]minS: they key point is, windows doesnt allow you to do any advanced tuning on io or memory stacks
if you have serious io contention on linux you can try different io schedulers like deadline or noop.
balek
if they are an benchmark offical it's very good to change the system
RJarett
w/ windows you are just stuck
so its not a matter of ohh one os is x% faster. its more of, in YOUR situation you can finetune more
A[D]minS
RJarett I'm trying to find official Document to forward it or a customer lol
the problem i'm not into oracle stuff, but my friend asked me to help , i said ok i'll check here :)
it or a > it for a
RJarett
tell your friend that friends dont let new friends touch their databases
A[D]minS
hehehehehe
i won't touch his db :P
realHans
hi. Is there no way to set an absolute path in DIRECTORY argument for impdp ?
TheBonsai
no, because DIRECTORY doesn't refer to a filesystem directory
it refers to a database DIRECTORY object
realHans
how can I tell imdp what file in an absolute to import ?
TheBonsai
create a database DIRECTORY object
RJarett
realHans: create or replace directory FOO = '/path/to/dir';
realHans
I'll try ...
RJarett
and then grant perms on that directory object in the db to the user you want
TheBonsai
oh, you can write '=' there?
nice
RJarett
sorry
as
TheBonsai
oh
:/
RJarett
CREATE OR REPLACE DIRECTORY TMP_DIR AS '/tmp';
grant read,write on directory TMP_DIR to youruser;
realHans
(Action) doesn't get it .. :/
my try: impdp %systemuser%/%systempass%@%mydb% directory='C:\LOG\Database\Demo_Data' DUMPFILE=log-exp.dmp LOGFILE=import.Log
RJarett
realHans: impdp does EVERYTHING from within the database
realHans
hmmm ...
RJarett
realHans: you are previously a sqlserver user arent you?
realHans
not really. Only Oracle.
RJarett
realHans: the directory= parameter is really just asking for the name of a directory object from the database
TheBonsai
realHans: impdp (the command) is just a user interface to the datapump mechanisms. it's not impdp/expdp itself that does the work
RJarett
in the database you create a directory object
realHans
We used imp so far. I just heared importing with impdp is faster ...
RJarett
yeah and imp/exp is unsupported and a different file structure
if your log-exp.dmp is from exp it will not work with impdp
realHans
oh, this is bad ...
RJarett
imp/exp became deprecated in 9i
realHans
.. yes it is from exp ...
RJarett
but these tutorials will show you how to work with the new format and impdp/expdp http://www.orafaq.com/wiki/Datapump
realHans
ok, it seems I'll have to stay with imp/exp ... :p (this damn 6gb dmp file takes 3 hours to import ... :p)
RJarett
3 hours?
what sort of sh*tty system is that?
3 hours you should be able to push 150-200+gb
i could imp 6gb and rebuild indexes in a few minutes on my laptop
realHans
hmmm E6400 with 2 gb ... and some usual 60 Euro HDs ...
RJarett
if you are going from one db to another on your network, it shouldnt need to touch the filesystem as a dmp file at all
realHans
ok ...
thank you for your time ... last question. What factor is impdp/expdp faster than imp/exp ?
RJarett
depends on the data
if you have a sh*tty ass system like what you say, who knows
realHans
hmmm 'usual' data :p
never mind. thank you. Have a nice evening ...
RJarett
the key to datapump is it organizes data in the export process do that the dumps are pure blocks of data that are pushed to the system better
realHans
hmmm ...
TheBonsai
and parallelity, which may be made possible with that reorganization
though i guess one object is pumped to one file, still
realHans
The wiki is excellent :) gn8
usn_work
A[D]minS, øn¬ ’K ßøB“g’øn ’ß gø ¢øµþ涬 þ¬¶ø¶µæn¢¬ « «ø“¶ß¬B
A[D]minS
usn_work red with wings ,, Guess! :P
meen feen by2ol eah
usn_work
A[D]minS, one big option is to compare yourself
A[D]minS
dah meen dah!
usn_work
do a benchmark, build your own attitude
balek
usn_work : my last question please is it possible to rename a group disk because i see on documentation it's not possible? and i create three diskgroup one of this have a problem i don't know why . i try with dbca to create a database i use this group disk who i have problem and when it begin it send me error it can't found disk on this group disk actually i can't delete thie group disk with dbca of with the comand drop diskgroup... i don't know if there are ot
her manipulation to force the delete groupdisk thanks and it's my laste question for this day :)
A[D]minS
i've a weird question " there are disks presented on my server as sde sdf sdg , but we are going to remove sde and delete it from SAN then present new LUN "Questions are ... when we un-present this device"sde" and then run hp scan to verify the presented disks ,, it will effect the sequence of naming ? 2nd Question when i present the LUN on same server how i can make it appear with name sde ?
hese disks used by oracle ASM , i don't do any mounts
RJarett
why are you using the sd* naming of them?
TheBonsai
the ASM instance has a "diskstring" to recognize the disk devices (usually a pattern), and it puts headers on the disks. to the order shouldn't matter. remember to drop the disk in ASM if needed
RJarett
why not the uuid or forcing the lun volume information to a specific name within your udev process
A[D]minS
ok i'd go for udev
balek
if anyone use asm on rac oracle for you the best solution is the asm mirror or the continous access tool hp
sorry storageworks business copy hp
sinesio
hi, I'm used to create standby redo log file like this: ALTER DATABASE ADD STANDBY LOGFILE ('/oracle/dbs/slog1.rdo') SIZE 50M;
but now I'm using ASM
how can I create redo log files to the ASM
?
RJarett
create one in the asm, and drop the old
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10734/rcmasm.htm#1021781
Migrating Standby Online Redo Log Files to ASM Storage
wow... wish the docs werent so hard to navigate. who would have thought that the exact topic you needed would be listed in the moving to ASM section of the docs under an almost exact subject you asked about :P
sinesio
i really lik e me don't you?
:)
sorry... you really like me, don't you?
I have a clean database, so I don't need to move any existing redo log files, I've just installed a new database and want to create new standby redo log files
KeiKurono
how can i show table structure in oracle 8i?
ah desc, nvm
but it doesn't show foreign keys?
anyone?
also, i could use something like show database; to list all tables
DiscordianUK
It's not MySQL dude
Oracle DBAs tend to be trained
KeiKurono
?
DiscordianUK
I suggest reading some documentation about Oracle
KeiKurono
i have the sqlplus manual but i can't see in the index an answer to my questions
DiscordianUK
What MySQL calls databases Oracle calls schemas
KeiKurono
ok
and.. ?
DiscordianUK
and you need to find some good documentation on Oracle and read it
« prev 1 2 next »