logs archiveIRC Archive / Freenode / #oracle / 2010 / March / 23 / 1
avaia
spcshpopr8r: it should be in /proc/<pid>/environ on linux
spcshpopr8r
avaia: thanks, I'm on AIX, same? analogous?
(Action) goes to check
kvaster
hi again. i've checked all permissions
now i have another error: ORA-12705: Cannot access NLS data files or invalid environment specified
:(
Zyclops
hey guys.. i've got a windows VM running Oracle 10g XE, but the VM chews up 400mb for the vm + 500mb for oracle. I was considering switching to Oracle 10g on Mac 10.6 using the intel 64 platform.. do you reckon this will decrease the footprint or do you think i will run into other issues?
RJarett
lol
youll run into much bigger issues with osx
Zyclops
*cries*
i wish they'd just made a oracle xe for mac
I mean there's a linux version
RJarett
1gb is really all that much?
Zyclops
it's not just that
RJarett
considering vmware shares and balloons memory
         

Zyclops
it chews thorugh CPu
CPU
and sometimes it's a lot more
RJarett
use reservations to keep it from eatting so much
Zyclops
and when the other db's are using < 100mb, yeah 1gb seems like tons
RJarett
why do you need XE if you whine about space?
use postgres or mysql
less cpu, less memory
more idiot friendly
Zyclops
yeah, i'm using postgres and mysql
XE - I assumed was lighter weight than the full install + a lot easier
RJarett
it is
much lighter
Zyclops
installation that is
but there is no XE for osx
RJarett
but you can still lower memory used by editing the pfile or spfile
Zyclops
ok.. so do you reckon I should bother?
or just stick with the VM?
RJarett
that made no sense
Zyclops
Ok.. do you think i should install oracle 10g (full version) or stick with XE running in VM
RJarett
you couldnt handle full
and it would use much more ram
Zyclops
right
thanks for the info.. you saved me a lot of hours :)
KeiKurono
morning
i got error 6 attempting to launch sqlplus (on a sunos 5.7, remote access via telnet :( ) Message file sp1<lang>.msb not found
azareth
Does anyone here have experience with Oracle UCM Workflows
KeiKurono
nevermind now i got another err: ORA-12545: Connect failed because target host or object does not exist
i'm gooling but i can't find any TNSNAMES.ORA file
i found the log: http://www.pastie.org/882302
dsdel
KeiKurono: $oracle_home/network/admin/
KeiKurono: tnsping <sid>
KeiKurono
dsdel that is the sid?
$oracle_home/network/admin/ ?
dsdel
KeiKurono: your oracle database id - and you find tnasnames.ora inside this path
if it isn't there run the netca / net configuration assistant
KeiKurono
ah thank you
ok tnsnames.ora seems set
         

dsdel
:)
KeiKurono
now.. how can i find the sid? :/
dsdel
you should know the sid if you want to connect to a database
KeiKurono
eh
dsdel
else you don't know to connect to which database :D
KeiKurono
isn't there a default system manager stuff?
dsdel
you have f.x. severall oracle installation folders and below each installation folder you can have multiple sids (databases)
KeiKurono
i see
dsdel
no, system manager stuff is integrated into each database
KeiKurono
basically i want to create a new db
but i can't get to succesfully login with sqlplus
dsdel
then you should start with the dbca (database configuration assistant)
and you shouldn't use telnet :D use ssh
KeiKurono
the machine doesn't have ssh :(
dsdel
KeiKurono
thank for your support dsdel
dsdel
you're welcome
but dbca needs X :D
KeiKurono
so i can forget dbca :/
i guess i'll follow your link
dsdel
:)
KeiKurono
i can't believe i'm doing stuff via telnet on a sunos 5.7
groan
ok, found some sid.. but dunno username and pass.. with system/manager i should be able to connect to them?
cygnus# orapwd file=$ORACLE_HOME/dbs/pwdtest.ora password=test entries=5 Unable to find error file.
zob
i tried to create another db, i set password file, edited tnsnames.ora but if i tnsping it hangs..
if i do tnsping db it hangs, why?
TNS-03505: Failed to resolve name
sytse
mm, it does seem to be convert that's wrong.. these days (I'm using oracle 10g), it appears a clob is assumed to simply be in the same character set as varchar2 (unlike nclob, which usually is AL16UTF16), but using convert on it gives wrong results (instead of converting to AL32UTF8, it converts to AL16UTF16)
KeiKurono
damn i can't set up the listener
please, some help http://www.pastie.org/882403
the death.
lol, really useful http://www.error-code.org.uk/view.asp?e=ORACLE-TNS-01103
sytse
all right, never mind, finally found oracle bulletin 257772.1
clobs and nclobs of any varying-width character set are stored as AL16UTF16 from oracle 10g onwards..
KeiKurono
every db should run on different ports?
hali
no
you should have one listener
multiple instance can be served from one
KeiKurono
i'll paste the service summary
http://www.pastie.org/882302
i don't quite understand.. i just wanted to create databse test
i can connect to cygnus, as system manager, but it i tnsping test it fail
with this error: ORA-12154: TNS:could not resolve service name
in tnsnames.ora i added another service name.. called test, i need it in order to create test database right?
hali
KeiKurono: do you know how 'databases' work in oracle? the concept of databases as an instance what generally is called a databases in say pg and mysql is in oracle just a schema (user)
KeiKurono
i started today with oracle, pls any help would be appreciated
...
Trengo
KeiKurono ask your boss for oracle education
its definitely worth it
KeiKurono
...
sytse
'The temporary LOB instance will exist in your application until it goes out of scope, your session terminates, or you explicitly free the instance. Freeing a temporary LOB instance is recommended to free system resources.'
KeiKurono
sigh
sytse
why do they specifically recommend freeing manually, even though you should get the same result by letting it go out of scope?
hali
if you have a long running session
you can free it earlier
sytse
yes, but in the case of a local variable, it should be freed after the function or procedure terminates, right? And lvalues after the statement ends, right?
KeiKurono
i can't find (googling) a proper solution for this TNS-03505: Failed to resolve name
sytse
KeiKurono: fix your TNS config, that's the proper solution
it fails to find the name you specified for the oracle instance in your TNS configuration
KeiKurono
i'm trying
sytse
what's the contents of your tnsnames.ora?
KeiKurono
here: http://www.pastie.org/882518
i can't find a detailed documentation for that file btw
i can connect to cygnus, not to test, services are both started in lsnrctl
hi RJarett
RJarett
hi
sytse
hmm, that's odd
RJarett: btw, found the reason why convert was behaving the way it did in oracle bulletin 257772.1: oracle can't store any variable-width character set (apart from UTF16, which oracle apparently doesn't consider variable-width) in clobs, so it converts any variable-width character set to AL16UTF16 (or up to 9i, UCS2)
RJarett
yeah thats exactly wtf i posted yesterday
sytse
not really, that text you pasted was very fuzzy and also, wrong. 'In releases prior to Oracle Database 10g, Oracle created CLOBs in a variable-width character set and stored them in an endian-dependent format' you pasted, instead, what it did was always store data supplied in a variable-width character set in the fixed-width format UCS2
RJarett
did you bother reading the last sentence of what i posted twice?
sytse
'The CONVERT command will not perform conversions on these CLOBs.' <-- you mean that?
I think it will, actually, only it will interpret any variable-width character set as AL16UTF16?
anyway, indeed you said that you were sure the DB would create these CLOBs as AL16UTF16, but I didn't understand what 'these CLOBs' were at the time, now I understand it's CLOBs that are supposed to be in some varying-width character set
KeiKurono
i don't understand...
CONNECT username/password AS SYSDBA
user and pass of the db?
then, what is sysdba?
RJarett
a specific permission level that sets you as all the roles of sys
KeiKurono
i thought of it as username
RJarett
never use it unless absolutely required
dont create crap under it
KeiKurono
ok i create a test db, set a passwd for it.. so username is db instance?
i was never prompted to edit a username entry...
RJarett
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#10431
sysdba isnt a username
KeiKurono
ok
i followed this http://www.dba-oracle.com/oracle_create_database.htm
where i specify the username?
RJarett
why did you manually create the DB?
KeiKurono
because i have telnet access to sunos+oracle, remember?
the guy from yesterday
RJarett
you can still export your display to a remote system and use the full dbca
you just need an xserver runnign on your local box like cygwinX or Xming
its REALLY bad to try to do a manual db creation when you dont know what you are doing
KeiKurono
i'm not working on windows
RJarett
dude really?
they allow you to use computers?
are you getting paid?
that just makes it easier
KeiKurono
?
RJarett
because you ask some very basic and obvious stuff
usn_work
RJarett, stop trolling here
RJarett
its nto trolling dumbass
you help the newb if you dont like it
i never see you help, but often bi**h about me
usn_work
ask why
RJarett
why are you a bi**h? is that what you want me to ask?
KeiKurono
sigh
hali
RJarett: steady on
usn_work
I'm asking, why do you need to use bad language to explain things. Aggression against others is no help at all, and poisons the climate here
RJarett
Because its fun
and it weeds out the weak
they go back to being developers instead of pseudo DBAs
usn_work
I think this is ok ;) But please don't use rude language any more.
KeiKurono
bah
usn_work
what? ;)
In one point he is right: You did not read any docs about connecting to a DB, and about permissions.
and, creating a DB is nothing for a "housewife" - maybe you want to go through the whole process with DBCA, create scripts with it, read them, and then do it manually. This will take about 3 installations to know what you do
KeiKurono!
KeiKurono
just nevermind
usn_work
what does that mean?
(I'm no native speaker of english)
Trengo
it means KeiKurono should take oracle courses :)
KeiKurono
ok ok
sorry if ask things in here
Trengo
its not simple or easy and you certainly cant just install it and lets see
KeiKurono
my bad, i should neither get paid, as rjarett suggested, lol
usn_work
you can ask whatever you feel like. But we will answer out of experience
Trengo
no, i mean it
KeiKurono
no, some people prefer to bi**h around
usn_work
and expereince includes some other askers befor you
Trengo
if your boss wants to use oracle, his budget definitely should include education
KeiKurono
i don't have time for this
Trengo
YOUR education
RJarett
KeiKurono: there are many many many many things you are doing wrong.
thats what i point out
itll make you better and smarter for the future
KeiKurono
RJarett: now you could just shut up
you said enough
RJarett
i could, but i wont
Mr Telnet
really telnet is so 1999.
usn_work
it's just the best tip I can give you: Use dbca for the first few times, create scripts with it, and read them. Just do it, see and feel happier. You will learn a lot
« prev 1 2 3 next »