[oracle@server ~]$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=$password entries=$num_users force=y
# OBS 1
“If you are running multiple instances of Oracle Database using Oracle Real Application Clusters, the environment variable for each instance should point to the same password file.”
# OBS 2
REMOTE_LOGIN_PASSWORDFILE need to be in EXCLUSIVE to alter user with sysdba.
# OBS 3
Users can be chacked on V$PWFILE_USERS.
# OBS 4
Entries represent the quantity of users on orapwd/with sysdba.
A little old, but I felt the pain in my heart… You will feel it too, I think…
We already have faced situations like this to big envs, specially this migration from 18.104.22.168 to 11gR2… Latch mutex including…
It’s long, but it’s good.
Do you know the difference?
current_date(): Only give you the date.
now(): Datetime when the statement,procedure etc… started.
sysdate(): Current datetime.
Take a look between the functions now() and sysdate() after executing sleep of 5 seconds…:
SQL> select current_date(),now(),sysdate(),SLEEP(5),now(),sysdate();
"2016-03-24";"2016-03-24 16:00:43";"2016-03-24 16:00:43";"2016-03-24 16:00:43";"2016-03-24 16:00:48"
Supposing you are in a server shell and don’t know if you machine is virtualized (a VM)?
One way to check that (supposing VMWare as hypervisioning solution) is:
[root@mydbsrvr ~]# dmidecode | grep -i vmware
Manufacturer: VMware, Inc.
Product Name: VMware Virtual Platform
Serial Number: VMware-xx xx xx xx xx xx xx xx-xx xx xx xx xx xx xx xx
Description: VMware SVGA II
If you had an answer like this, yes, it’s a VM. 🙂
Take a look here.
Quick post just to tell you that. 🙂
Errors in file /oracle/diag/rdbms/mydb/mydb_1/trace/mydb_1_ora_972.trc (incident=195818):
ORA-00600: internal error code, arguments: , , , , , , , , , , , 
Incident details in: /oracle/diag/rdbms/mydb/mydb_1/incident/incdir_195818/mydb_1_ora_972_i195818.trc
The query causing this error uses a CONTAINS clause on alphanumerical column using bind variables. This is a perfect match with note ORA-0600  on a Select Query Using Contains Clause (Doc ID 1176276.1), referencing the unpublished Bug 8770557 ORA-600  While Running Text Queries.
The symptoms includes this two key factors:
– presence of CONTAINS clause
– use of bind variables
Apply 22.214.171.124 patchset or higher, where this issue is fixed or Apply one off Patch 8770557 if available for your version / platform.