logs archiveIRC Archive / Freenode / #oracle / 2009 / November / 19 / 1
paissad_
hi all
Trengo
hello
Junior
yello ;)
indra
hi all
I am new to oracle and thus need some basic help
I am trying to install Project.net
which needs oracle database, and thus downloaded and installed oracle 10g Express Edition
but I am unable to find out how to create a new database in it
did I download a wrong database
need help
mahal
indra: platform ?
indra
linux madhatter
linux mahal
using http://localhost:8010 port I am able to access the web page of Oracle 10g
mahal
what about this
http://st-curriculum.oracle.com/tutorial/DBXETutorial/index.htm
show ps -ef | grep ora_
indra
mahal the above command output shows a process running with ora_
Reign1
hi, how to fix this one:
SQL> alter system set processes=300 scope=spfile; alter system set processes=300 scope=spfile * ERROR at line 1: ORA-32001: write to SPFILE requested but no SPFILE specified at startup
is there other way to set it?
         

cmu
create spfile from pfile;
Reign1
thanks, btw, how to check whos using connections? select count(*) from v$process; showsh connections, how to check whos using them?
*shows count of connections
*processes
i need to free up processes
cmu
v$sessions you mean?
chemik
hello
how can i combine in one select, inner join and left join? see http://monka.hysteria.cz/~chemik/sql.txt
kok
hi i have a oracle rac cluster on windows, i want to monitor thie cluster with nagios i found one plugin but it want to use crsctl and crs_stat on my linux i don't want to install the crs oracle to use this tools i search if there are a client oracle crs withi this file if you can help me please thanks
weed0n
howdy. I'm trying to install an Oracle 10 client. But the "universal installer" wont start. Any suggestions?
m4n0
hello... how I load/unload a data on data base? what´s the command?
mator
sql*loader ?
m4n0
mator anymore?
mator
AK74
you can aim it to someone will do a job for you
m4n0
mator right, I want only to know any commands
not´s for a job
its academic
mator
m4n0, exp/imp, expdp/impdp
m4n0
mator exp/imp its to export and import?
to load and unload I use sql*loader only?..
mator
m4n0, google gives a faq entry on some wiki about sql*loader, there's also described one of unload variants, i.e. using sqlplus
m4n0
mator ok right, I found :) .. thanks
Rudemeister
help
i see it included spfilein backup but restore spfile from autobackup fails
any idea?
Morg0th
hello, I'm trying to make a query work in a pl/sql procedure. I'd like to be able to search films with 4 different things: name, realisator, actor and genre, and to able to search only one or 2 of those things (so some parameters might be null). here is my procedure: http://pastebin.com/m47e5c6c but the problem it that when all parameters aren't specified, I get a huge result list. could you tell me how I could fix this please?
I think it comes from the tables in the FROM statement that are always present, even if there is a null parameter, but I don't know how to remove the unused tables if I don't use them
bwr_
Is there any difference between SYSDATE and LOCALTIMESTAMP besides one having hours, minutes, seconds as well
hali
yes
localtimestamp takes your session timezone in to account
sysdate is the system date/time
alter session set time_zone='Europe/Paris';
alter session set time_zone='Europe/London';
and see the difference
bwr_
oh
thanks. how does sessiontimezone get set by default?
         

sidh
greetings gentlemen
In Oracle 10g DBA Handbook they say that ASM is highly reliable on production environment, I would like your real feeback since with ASM you don't really control the files isn't it ?
bwr_
Can sqlplus be used to connect to a remote database over the network
mator
bwr, it can connect to any tns name defined
sidh
bwr_: as far as you can tnsping the database
bwr_
ok, looking it up
qnix
Hi ppl.
I'm getting that error when trying to `sqlplus` on my db (localhost): ORA-01034: ORACLE not available
I looked on google, but the tips don't seem to be my problem, any idea?
defaultro
good morning folks. I would like to learn pl/sql stuff and other great things about oracle. I'm looking more into the developer side. I would like to know what training I should attend.
also, so I can get going, can I download Oracle and try it on any linux?
TheBonsai
on a supported one
defaultro
will it work in Fedora?
bwr_
defaultro: there are instructions for getting it working on ubuntu and debian systems as well
defaultro
ok
TheBonsai
it will work everywhere, if you know how to do it
defaultro
got it
TheBonsai
but use a certified platform, or a similar system
centos for example
defaultro
i tried redhat before using 8.0.6 and I got it to work. I think we are on version 10 now
Ok, I will try CenOs
i'm a bit familiar with that distro
for the ORacle download, which version should I be downloading?
TheBonsai
11.2
defaultro
what about this Unbreakable Linux I am seeing in Oracle's site?
oh, it's 11.2 now :)
TheBonsai
it's a redhat with Oracle images and icons ;)
defaultro
they say it's free
kok
hi i have a question i have more file archive log with 1 Ko size i don"t want this size can you tell me please how i can see thie paramater and modify this please thanks
defaultro
looks like I can try that. My guess is that I won't have to recompile it since it will be included during the install.
am I correct with my assumption?
TheBonsai
kok: is it the size of your redo groups? or do you mean only SOME are that small?
defaultro: recompile what?
defaultro
Oracle
or is it binary/
?
TheBonsai
you have the oracle source code?
can i have it?
:D
defaultro
oh, yeah, LOL
so it's binary
TheBonsai
of course
defaultro
cool
TheBonsai
not everything in the world is FOSS
defaultro
so I can either go with CentOs and install Oracle myself or go with Unbreakable Linux. Correct?
I think the former would be more exciting
will CentOs work on Xen?
kok
TheBonsai : i have more files with 1Ko size archive log and the last archive log have 50000Ko i don't know why i have 1000 files with this size
defaultro
got confirmation, CentOs will work on xen
kok
TheBonsai : i want to delete all this file with small size
TheBonsai
kok: you don't want to do that
kok
TheBonsai : i don't understand
TheBonsai
kok: you need the complete archive chain to be recoverable
kok
TheBonsai : yes ok but i want to delete there archivelog because it's not the good size make a full backup and restart the archivelog it's not important the old archivelog now
i want to reset the old archivelog and create a new archivelog with good size
TheBonsai
kok: redo logs and archived redo logs have a maximum size, but not a fixed size
there is no "good size"
kok
i can't fixe the size of archive log ?
TheBonsai
do you know what a logswitch is?
kok
yes i think it's if i want to switch the log file to the new log file no ?
TheBonsai
yes
and you can always switch logfile (assuming there's a free one)
you fill it with 10 bytes redo data, then you switch
the archive of this log will have 10 bytes...
defaultro
TheBonsai, do you have a link where I can start learning PL/SQL? I have programming background.
TheBonsai
defaultro: download.oracle.com i think holds PL/SQL docs, too (for the proper database version). the website is a bit complex, you might need to search a while. but i also guess there are many other resources on the net
kok
TheBonsai : ok i see on one of script i have alter system log current i think it's this command problem because i want to backup rman catalog
TheBonsai
kok: ok. also a ALTER SYSTEM SWITCH LOGFILE could be the cause, or anything else that forces a premature switch#
this is not a bad thing
why do you have a problem with it?
kok
TheBonsai : yes because this script it started every 1 hours but the there are not traffic on this database it switch a blank file it's not very good
TheBonsai
why is it "not good"
explain
it is not good and not bad, it doesn't matter
in your case, you need it
or at least, "in your case, it's better"
kok
TheBonsai : i am novice i try to backup the rman catalog ok but i crate a script and start this every 1 hours on this script i switch the log file but there are not traffic and i have more file redo with 1Ko size if you tell me it's not important ok because i think you are more experience than me on oracle database
TheBonsai
kok: test it: ''ALTER SYSTEM SWITCH LOGFILE;'' -- do it 50 times with copy&paste
you will have 50 nearly zero-size archives
bbl
kok
TheBonsai : no but i can define the number of archive log i want ok or not ok
TheBonsai : thanks for your gelp
defaultro
what could be the salary range for someone who knows oracle development?
Trengo
if you're in india, about 10USD/month
or in a boat moored outside new york
roygbiv
i have some code to generate a numeric value for an integer PK column. is there a way to test if that value has already been inserted into the table? or are there other techniques for ensuring uniqueness?
defaultro
i'm in IL
is $100k-$120k a good range?
spackest1
wondering if there is a simple query to show all currently running queries (including actual sql) on oracle 8i
something similar to mysql's show processlist
bwr_
defaultro: i think it depends on the experience level
I've been looking for jobs in Singapore and I've been amazed at how little they pay compared to the amount of money required for housing/rent
spackest1
looks like this is hopeful select * from v$sqlarea;
wait, those might just be in cache not currently running queries
Dormir
afternoon
defaultro
k
qnix
I can surely delete all indexes associated with a table
?
I'm getting a insuficient privilege... but it is the same user who creates the index.
ha, nvm...
« prev next »