logs archiveIRC Archive / Freenode / #oracle / 2010 / January / 18 / 1
TheBonsai
y0
Junior
y0 bonsai :D
Reign1
hi, how come i cant drop a user xxx even if im logged in as sysdba, i get error that i cant drop user im logged in with (problem cause xxx has dba rights or?)
anyone?
mator
Reign1, you trying to drop yourself ?
Reign1
no
TheBonsai
what's the ORA number...?
Reign1
http://www.dba-oracle.com/t_ora_01940_cannot_drop_user.htm
just did all the steps and all were no rows selected
RaDz
Reign1, connect as system or sys, then drop user xxx cascade;
Reign1
i connected / as sysdba'
         

realHans
hi. windows server + Client.I access 10g with C#. Using System.Data.OleDb i use an usual connection string "Provider=MSDAORA;Source=MYNAME ..." But I can also acced with System.Data.OracleClient where I don't need such a MSDAORA thingamabob in Control Panel/Administrative Tools/DataSources(ODCB).
1. What is this MSDAORA and whats it's advantage compared to a connection with System.Data.OracleClient ?
RaDz
tell me the difference between '/ as sysdba' and 'sys...
realHans
2. Whats better for me ?
Reign1
RaDz: u tell me, as i get this error when trying to drop xxx while being as sysdba
:)
mamurdian
i (user: A) give user B the permission to select table t1 (with grant option), user b in turn give c the permission to select table t1. is it possible that user A can revoke the permission select on t1 from both user (A and B)?
Reign1
so, any other ways to solve this drop user question? :)
TheBonsai
this error doesn't say YOU are the user in question
it says the user in question is logged on
Reign1
but its not :)
TheBonsai
oracle says it is
select distinct username from v$session; -- there?
Reign1
yep, somehow it was connected in the end, killed session and dropped it, thanks
TheBonsai
y0
e_
hello everybody
i think i've reached the 4G limit with oracle-xe, since the listener starts up fine but won't register the service anymore.. is that the behaviour you get when your 4GB limit is reached?
mator
e_ is it a question or a plain statement ?
e_
a question too :)
i don't really know why the service won't start up, the 4gb limit is speculation since i do not get an error message that says anything like that
mator
e_ check the logs? tried to register db by hands ?
e_
which logs?
the listener starts up fine but i won't get the "service registered" message.
it seems i can connect to the db with sqlplus as the oracle user though but i'm completely helpless here
rsavu
hello all. i understand that variable substition only works in sql*plus. how can i use the same concept for storing for example a schema name and use it through the script?
mator
e_, SQL> ALTER SYSTEM REGISTER; ?
e_
i'll try
mator
e_, or add your db to the listener config files statically by hands, which is done by default with oracle install ifaik
         

e_
it is in the config file
hm, that didn't help. tns:listener still doesn't know the service
mator
how do you test connectivity between the db and listener ?
e_
i just read the logs
and i try to connect to the service with sqlplus getting "TNS-12514: TNS:listener does not currently know of service requested in connect descriptor"
lsnrctl services also doesn't show the xe service
tnsping xe however gives OK (as oracle user)
mator
what's your connection string?
(without the actual password ofcourse)
e_
sqlplus spacewalk/password@xe
also tried @XE which is no different
lsnrctl status also doesn't show xe
mator
e_, can you pastebin somewhere listener.ora tnsnames.ora files ?
e_
sure
http://fpaste.org/5rRZ/
there you go
mator
e_ and 'traceroute localhost'ends up in 1 hop?
e_
yeah..
mator
try to check listener logs then
e_
well, as i said
it starts up okay but i don't get the service update
or register
like, normally i would get something like that: 30-JAN-2009 14:29:57 * service_register * XE * 0
but i don't see that
mator
e_, there's no other error messages ?
sql> show parameter names
e_
global_names boolean FALSE
service_names string XE
no other error messages
mator
sql> show parameter local
try once again 'alter system register' checking listener logs and waiting up to 60 seconds
e_
local_listener string
log_archive_local_first boolean TRUE
ok
nothing
no error messages, no success messages
mator
e well, try to increase trc_level of listener and check logs ?
i really have no more ideas of trc_level
e_
how do i do that?
mator
trace' or 'set' commands to lsnrctl
e_
what level?
mator
e_ try different, starting from user , then admin or support
newbie687
hi, a user have a default table space, and have some quota on another ts, when object will be created on other ts
e_
hm, the only thing i can see which seems like it could be helpful is this:
NA services unavailable on both processes - negotiation not needed
jagadish
a user has a default table space, and have some quota on another ts, when an object wil be created on other ts
pls clarify
TheBonsai
when you specify it...
phimic
hi all
i have a big and urgent problem on our poductive rac
productive rac
after patching crs and db from 10.2.0.3 to 10.2.0.4 i get an error while trying to login into via sqlplus / as sysdba
http://pastebin.com/m2f9333d5
pls HELP
cmug_
gaiheuttaa
mator
phimic, http://forums.oracle.com/forums/thread.jspa?threadID=987316&start=15&tstart=0 ?
e_
mator: apex isn't running either
mator
phimic, but if i was you, following guides from the forums on a real production RAC double check that you're understand what you're doing
e_, i've no idea what is apex :)
e_
ah, that web interface for managing oracle-xe
mator
e_, it is called 'enterprise manager' in oracle SE/EE
e_
okay
mh, it seems as i've not hit the 4G limit yet: xe/oradata/XE/
err
3,7Gxe/oradata/XE/
although it's close
i don't understand why the connection between the listener and the database won't work
alter_XE.log says: Completed: ALTER DATABASE OPEN
so it's basically fine
mator
phimic, also http://seer.entsupport.symantec.com/docs/273452.htm as it also (as forums) suggestion about libvcsmm.so
s/!$/libskgxp10.so/
TheBonsai
e_ can you register it manually?
e_
alter system register; says it was successful, but it still won't register to the listener
phimic
mator: did not help :(
e_
how do i tell the listener to connect to localhost?
mator
e_, listener does not :)
db clients and db are the listeners clients
phimic, what have you tried ?
e_
ah dammit
i've changed all HOST configs to the Ãpublic ip instead of localhost and now it works
(Action) sighs
phimic
cp /opt/oracle/10.2/crs/install/prepatch10204/lib32/libskgxp10.so to $ORACLE_HOME/lib
jagadish
The Bonsai: i have assigned a defaul ts n some x quota on it to user, and some quota an another ts , at the time of creation
TheBonsai
the default ts is used when you don't specify a ts on segment creation
phimic
mator: on the second node i did not get this error but the statup nomount take a lot of time
HeitorRamon
Guys, anyone here knows about oracle portal?
phimic
no rac expert here? cannot startup my rac :(
Rudemeister
hmm
mamurdian
create view abtinfo(ANR, ANR_SUM, ANR_AVG) as (select anr, sum(pgehalt), avg(count(pnr)) from pers group by anr);
does something like that work or is something wrong with my stmt?
RaDz
() ,
mamurdian
ups it seems that i cannot do avg(count(pnr))
RJarett
have you tried doing count(whatever) ? notice a pattern there? why would you avg it like that?
mamurdian
it was a mistake
DustyDingo
hi
can i do a non equal join in oracle?
select a.f from a, b where a.x != b.x
srm
a JOIN b ON a.x != b.x ?
well, it's the same as your standard, apart from using proper JOIN syntax
« prev next »