Database Server root/welcome1 oracle/welcome1 grid/welcome1 grub/sos1Exadata Database server ILOMs root/welcome1 Exadata Storage Cell Server root/welcome1 celladmin/welcome1 cellmonitor/welcome1 Exadata Storage Cell Server ILOMs root/welcome1 InfiniBand switches root/welcome1 nm2user/changeme InfiniBand ILOMs ilom-admin/ilom-admin ilom-operator/ilom-operator Ethernet switches admin/welcome1 Power distribution units (PDUs) admin/welcome1 root/welcome1 Keyboard, video, mouse (KVM) if available admin/welcome1

bash-3.2$ cd /data/ bash-3.2$ ls Baku.solaris Java_Timezone arch anardb.ctl anardb.yed cd control datafile initANARDB.ora lost+found orapwANARDB1 patch stnd.ctl trace bash-3.2$ bash-3.2$ ls -la total 17902902 drwxr-xr-x 10 oracle oinstall 512 Mar 24 19:14 . dr-xr-xr-x 35 root bin 1024 Jul 8 2015 .. -rw-r–r– 1 root root 512 Mar 21 17:19 Baku.solaris drwxr-xr-x 4 root […]

Oracle(R) Integrated Lights Out Manager Version 3.1.2.32.b r86441 Copyright (c) 2014, Oracle and/or its affiliates. All rights reserved. -> start /SP/console Are you sure you want to start /SP/console (y/n)? y Serial console started. To stop, type ESC ( [root@bakuexa1celadm01 ~]# [root@bakuexa1celadm01 ~]# uname -a Linux bakuexa1celadm01.kfsaz.local 2.6.39-400.128.17.el5uek #1 SMP Tue May 27 13:20:24 PDT […]

Creating User Accounts To create a user account: # useradd -u 100 -g other -d /export/home/newuser1 -m -s /bin/ksh -c “Regular User Account” newuser1 # passwd newuser1 # /usr/sadm/bin/smuser add — -n newuser2 -u 500 -g other -d /export/home/newuser2 -c “Regular User Account 2” -s /bin/ksh -x autohome=N # passwd newuser2 Modifying User Accounts To […]

I am pretty sure that many of us come across of situations when a killed session by ‘alter system kill session’ command did put the session in ‘KILLED’ status and never released the session for a long time on the database. It could be due to the fact that the session would be rolling back […]

SQL> GRANT SELECT ON v$session TO scott; grant select on v$session to test * ERROR at line 1: ORA-02030: can only select from fixed tables/views SQL> SELECT owner, object_type FROM dba_objects WHERE object_name = ‘V$SESSION’; OWNER OBJECT_TYPE ———————— ——————- PUBLIC SYNONYM SQL> select table_owner, table_name FROM dba_synonyms where synonym_name = ‘V$SESSION’; TABLE_OWNER TABLE_NAME ————– —————————— […]