spcshpopr8r: it should be in /proc/<pid>/environ on linux

avaia: thanks, I'm on AIX, same? analogous?
(Action) goes to check

hi again. i've checked all permissions
now i have another error: ORA-12705: Cannot access NLS data files or invalid environment specified
:(

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?

lol
youll run into much bigger issues with osx

*cries*
i wish they'd just made a oracle xe for mac
I mean there's a linux version

1gb is really all that much?

it's not just that

considering vmware shares and balloons memory

it chews thorugh CPu
CPU
and sometimes it's a lot more

use reservations to keep it from eatting so much

and when the other db's are using < 100mb, yeah 1gb seems like tons

why do you need XE if you whine about space?
use postgres or mysql
less cpu, less memory
more idiot friendly

yeah, i'm using postgres and mysql
XE - I assumed was lighter weight than the full install + a lot easier

it is
much lighter

installation that is
but there is no XE for osx

but you can still lower memory used by editing the pfile or spfile

ok.. so do you reckon I should bother?
or just stick with the VM?

that made no sense

Ok.. do you think i should install oracle 10g (full version) or stick with XE running in VM

you couldnt handle full
and it would use much more ram

right
thanks for the info.. you saved me a lot of hours :)

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

Does anyone here have experience with Oracle UCM Workflows

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

KeiKurono: $oracle_home/network/admin/
KeiKurono: tnsping <sid>

dsdel that is the sid?
$oracle_home/network/admin/ ?

KeiKurono: your oracle database id - and you find tnasnames.ora inside this path
if it isn't there run the netca / net configuration assistant

ah thank you
ok tnsnames.ora seems set

:)

now.. how can i find the sid? :/

you should know the sid if you want to connect to a database

eh

else you don't know to connect to which database :D

isn't there a default system manager stuff?

you have f.x. severall oracle installation folders and below each installation folder you can have multiple sids (databases)

i see

no, system manager stuff is integrated into each database

basically i want to create a new db
but i can't get to succesfully login with sqlplus

then you should start with the dbca (database configuration assistant)
and you shouldn't use telnet :D use ssh

the machine doesn't have ssh :(

http://www.dba-oracle.com/oracle_create_database.htm
or use the dbca :)

thank for your support dsdel

you're welcome
but dbca needs X :D

so i can forget dbca :/
i guess i'll follow your link

:)

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

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)

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

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..

every db should run on different ports?

no
you should have one listener
multiple instance can be served from one

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?

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)

i started today with oracle, pls any help would be appreciated
...

KeiKurono ask your boss for oracle education
its definitely worth it

...

'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.'

sigh

why do they specifically recommend freeing manually, even though you should get the same result by letting it go out of scope?

if you have a long running session
you can free it earlier

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?

i can't find (googling) a proper solution for this TNS-03505: Failed to resolve name

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

i'm trying

what's the contents of your tnsnames.ora?

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

hi

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)

yeah thats exactly wtf i posted yesterday

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

did you bother reading the last sentence of what i posted twice?

'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

i don't understand...
CONNECT username/password AS SYSDBA
user and pass of the db?
then, what is sysdba?

a specific permission level that sets you as all the roles of sys

i thought of it as username

never use it unless absolutely required
dont create crap under it

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...

http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#10431
sysdba isnt a username

ok
i followed this http://www.dba-oracle.com/oracle_create_database.htm
where i specify the username?

why did you manually create the DB?

because i have telnet access to sunos+oracle, remember?
the guy from yesterday

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

i'm not working on windows

dude really?
they allow you to use computers?
are you getting paid?
that just makes it easier

?

because you ask some very basic and obvious stuff

RJarett, stop trolling here

its nto trolling dumbass
you help the newb if you dont like it
i never see you help, but often bi**h about me

ask why

why are you a bi**h? is that what you want me to ask?

sigh

RJarett: steady on

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

Because its fun
and it weeds out the weak
they go back to being developers instead of pseudo DBAs

I think this is ok ;) But please don't use rude language any more.

bah

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!

just nevermind

what does that mean?
(I'm no native speaker of english)

it means KeiKurono should take oracle courses :)

ok ok
sorry if ask things in here

its not simple or easy and you certainly cant just install it and lets see

my bad, i should neither get paid, as rjarett suggested, lol

you can ask whatever you feel like. But we will answer out of experience

no, i mean it

no, some people prefer to bi**h around

and expereince includes some other askers befor you

if your boss wants to use oracle, his budget definitely should include education

i don't have time for this

YOUR education

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

RJarett: now you could just shut up
you said enough

i could, but i wont
Mr Telnet
really telnet is so 1999.

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