Hi folks, Two down and just one more to finish this year presentations. The Gold Coast conference was excellent, I made some very good friends (I hope) and I got some very good feedbacks and tips regarding my presentation. This time I had a little more time to share with some fantastic and friendly people…
Reporting from Gold Coast – AUSOUG 2008 Conference (Pre-Conference Notes)
Hello, The flight was great, Ufff I was a little scare đ only the weather is not helping but I hope to have the opportunity to go to the beach and enjoy a little before Wednesday Night. Gold Coast looks to be a nice place, the airport is very little and don’t have almost anything…
Pre-Gold Coast Conference
Here Iâm, preparing my luggage for this trip and enjoying my family for few moments. This will be my second conference in 2 weeks. This kind of situation is a little new for me due that I was a speaker in the past just for a few and small conferences, and If you asked me few…
Are you having problems with the OEM Host Credential?
If you are using LINUX/Windows the hostname credentials should be the same user who has installed the oracle  database software, if Windows the user you are using need to be member of the ORA_DBA group and have Local Security privilege ‘Log on as a batch job’. What you need to do is go to:  Start—->…
Some News for RAT (Real Application Testing)
âReal Application Testing is Now Available for Earlier Releasesâ Oracle Database 11g introduced Database Replay and SQL Performance Analyzer as part of the Real Application Testing option to enable businesses identifies issues with system changes before production deployment in other words, Oracle Real Application Testing facilitates the testing and validation of system changes by recording…
OTN TechBlast October Edition
âFrancisco Tours Australia and NZ: Oracle ACE (Database) Francisco Munoz Alvarez is presenting his paper âLogging or Nologging: That is the Questionâ at the AUSOUG National Conference Series in Perth (Oct. 6-7) and Gold Coast (Oct. 13-14); and the NZOUG 2008 Conference at Rotorua, New Zealand (Oct. 20-21).â  by OTN TechBlast October Edition The first conference…
Perth, 2008 Australian User Group Conference
Hi, Here are some pictures from the first day of the conference. Tomorrow I’ll present my paper, also I will post more pictures and a podcast of it too. (I’m posting the links because I’m having some problems to upload the photos đ ) Connor McDonald and his excellent presentation â11g Features for Developersâ Alex Gorbachev…
How to find all user Roles and Privileges?
Here is the scripts to help you to get this information: PROMPT PROMPT PROMPT ******************************************** ROLES AND PRIVILEGES PROMPT PROMPT ******************************************** USER ROLES SELECT grantee user, granted_role, admin_option, default_role FROM dba_role_privs WHERE grantee IN (SELECT username FROM dba_users) AND      grantee NOT LIKE â%SYS%â AND      grantee NOT IN (âDBSNMPâ,âOUTLNâ) ORDER BY grantee; PROMPT PROMPT ******************************************** USER…
How to migrate from 32 bit to 64 bit using RMAN?
This procedure can be used for single instance or RAC (9i to 11g): In the 32 bit source server : Start making a full backup of the database including all archivelogs: RMAN> run  {  allocate channel c1 type disk;  allocate channel c2 type disk;  backup database plus archivelog;  backup current controlfile;  } In the target 64 bit server:1)…
How to Start and Stop a RAC Environment
Auto Start/Stop The Oracle Cluster Services handle the automatic start and stop of the Cluster, Listener, ASM and the Database. For the Grid Control Agent, the auto start- stop is handled via the /etc/init.d/dbora script. On server boot the dbora script starts the agent with /home/oracle/scripts/start_agent. On server shutdown the dbora script calls /home/oracle/scripts/stop_agent Manual…