logs archiveIRC Archive / Freenode / #oracle / 2010 / January / 16 / 1
zasz
o
spcshpopr8r
pop quiz: on an "alter table ... drop constraint" in the case of a primary key, does the corresponding unique index get dropped implicitly?
Rudemeister
no
it should
ehr
usn_work
good aftermorning ;)
Rudemeister
hi
Spec
anyone wanna clear some confusion up for me? :)
does the global database name have to be a FQDN? can it be an IP address ever? why does it exist? (can't i just always use ip:port/sid to connect?)
usn_work
no#
it has to be unique in your Oracle environment. Not more, and not less
Uniqueness is for synchronized databases in this case. RAC instances and dataguard setups have one GDN for the whole complex
The DB unique name is another distinction: It's unique for independent databases: Two dataguard partners will have different unique names, but a RAC will have one unique name
And last one: The SID is a unique identifier for an instance on a host, but typically RACs have different SIDs - one for each instance, even if they are on different hosts
Spec
Spec
ah
never dealt with rac (and am not using rac now)
so that's just for uniqueness within the cluster
dbca is creating a database, but when it goes to secure teh EMC, it fails every time
and the only way I can get it to work is using hostnames in the listener.ora instead of IP addresses....
zasz
global database names also play an important role in distributed database systems
they ensure you have a way to uniquely reference each database within the system
         

Spec
righto
Rudemeister
ok
Spec
so...
i've got two listeners defined in listener.ora, but 'lsnrctl start' only starts LISTENER
how do I start both?
(other than using interactive lsnrctl, set current_listener "OTHER_LISTENER", and then "start"
Dormir
lsnrctl start listener_name_here
Spec
gah
that was simple :(
not mentioned in -help :(
usn_work
Why do you need two listeners? They usually are just causing double trouble
Spec
usn_work: ideally i won't have two listeners :(
respecting
hi please is The free edition of oracle OracleXe can be used in transactional API(like EJB 3 Transaction Management)? Thanks in advance
JoelC
Hey
If I use createStatement(); for a var called stmt
can I make 2 SELECTs for this var?
I get an exception trying to do this, but trying to use it for a SELECT and then INSERT , it does work
Stylles
hi..
anyone ever see this error
invalid entry size (expected 2127341 but got 2127370 bytes
invalid entry size (expected 2127341 but got 2127370 bytes
« prev next »