Assign External Disk With Softpartition

Monday 28 Jan 2008 by Gun nee | No Comments
Filed under: Solaris

For the example, i will assign disk 1 Terra byte to existing disk

Note :
The disk will be allocation to :
/ora/datafile7 500 MB
/ora/datafile8 200 MB
/ora/datafile9 150 MB
/datasqlload 150 MB

first, how to knowing new disk added in system?
# format > old_disk.txt
for the crosscheck disk existing with new disk, save list disk existing to file

after team storage has allocated disk,now we have task to assign disk in system
look HBA connected with :
# luxadm -e port
# luxadm -e forcelip [name device connected in HBA] *only device connected
# devfsadm -C
# format

check the added disk, compare with the file old_disk.txt.
sometime disk sequence which have been added not successive.

Read the rest of this entry »


Ssh in Solaris

Monday 28 Jan 2008 by Gun nee | 8 Comments
Filed under: Solaris Tags:

This post is about service ssh in solaris 9 or 10

Solaris 9
Disable service ssh ?

bash>  /etc/init.d/sshd stop
bash> /etc/rc3.d/S89sshd stop

Enable service ssh ?

bash> /etc/init.d/sshd start
bash> /etc/rc3.d/S89sshd start

Refresh service ssh ?

bash> kill -HUP `cat /var/run/sshd.pid`

Solaris 10
First you can check service ssh with command

bash> svcs | grep ssh
online         Jan_21   svc:/network/ssh:default

If status ssh offline, you can make online with command:

bash> svcadm enable -t network/ssh:default
bash> /lib/svc/method/sshd start

Disable service ssh ?

bash> svcadm disable -t network/ssh:default

Restart service ssh ?

bash> svcadm restart network/ssh:default
bash> /lib/svc/method/sshd restart

Refresh service ssh ?

bash> svcadm refresh network/ssh:default

For a root enable connect to host via ssh service

bash> vi /etc/ssh/sshd_config
[....]
# Valid options are yes, without-password, no.
PermitRootLogin no
[....]

Replace no with yes, after that save the edited configuration.
Don't forget for the restart service ssh, after edit configuration.


Show Locking Proccess

Monday 21 Jan 2008 by Eriek Regandono | No Comments
Filed under: Oracle 
SQL> SELECT s1.username || '@' || s1.machine|| ' ( SID=' || s1.sid || ' )  is blocking '|| s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status, s1.SQL_ID
FROM v$lock l1, v$session s1, v$lock l2, v$session s2
WHERE s1.sid=l1.sid AND s2.sid=l2.sid
AND l1.BLOCK=1 AND l2.request > 0
AND l1.id1 = l2.id1
AND l2.id2 = l2.id2;

Moving & Recreate Temp Tablespace

Thursday 13 Dec 2007 by Hendrawan | No Comments
Filed under: Oracle

I Recreate the temp tablespace coz my temp tablespace was corrupt,
you can do to the following bellow

  1. create temporary tablespace temp2 tempfile '/rdbms/temp01/temp2.dbf' size 10M extent management local uniform size 1M;
  2. alter database default temporary tablespace temp2;
  3. drop tablespace temp including contents and datafiles;

now change back to temp again with following step bellow:

  1. create temporary tablespace temp tempfile '/rdbms/temp01/temp2_01.dbf' size 1024M extent management local uniform size 1M;
  2. alter database default temporary tablespace temp;
  3. drop tablespace temp2 including contents and datafiles;
  4. alter tablespace temp add tempfile '/rdbms/temp01/temp2_02.dbf' size 1024M;

ORA 29807 – specified operator does not exist

Saturday 8 Dec 2007 by Hendrawan | No Comments
Filed under: Oracle

Yesterday,
During Installation of Oracle database 9i base on RHEL 4 ES,
I got Found error occurred when create the database using dbca,
and it keeps failing at the same point (Creating data dictionary Views)
This the error number Detail "ORA 29807 - specified operator does not exist"

Workaround;
just ignore the error and DBCA proceeds normally. Once the database is ready,
login as SYS and run this script manually:

$ORACLE_HOME/rdbms/admin/prvtxml.plb
SQL> @?/rdbms/admin/prvtxml.plb


« Older Entries
Newer Entries »

  • Search