четверг, 13 сентября 2012 г.

win: Oracle Service not starting

C:\WINDOWS\system32>sc start OracleServiceTESTDB11G_stby
[SC] StartService FAILED 1058:

The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.
C:\WINDOWS\system32>sc qc OracleServiceTESTDB11G_stby
[SC] QueryServiceConfig SUCCESS
...
        START_TYPE         : 4   DISABLED
...
C:\WINDOWS\system32>sc config OracleServiceTESTDB11G_stby start= demand
[SC] ChangeServiceConfig SUCCESS

C:\WINDOWS\system32>sc qc OracleServiceTESTDB11G_stby
[SC] QueryServiceConfig SUCCESS
...
        START_TYPE         : 3   DEMAND_START
...
C:\WINDOWS\system32>sc start OracleServiceTESTDB11G_stby

SERVICE_NAME: OracleServiceTESTDB11G_stby
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 2  START_PENDING
                                (NOT_STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN)
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x7d0
        PID                : 4204
        FLAGS              :

C:\WINDOWS\system32>sc query OracleServiceTESTDB11G_stby

SERVICE_NAME: OracleServiceTESTDB11G_stby
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 4  RUNNING
                                (STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN)
        WIN32_EXIT_CODE    : 0  (0x0)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x0

среда, 12 сентября 2012 г.

Win7 stuck on welcome screen

1) Reboot, press F8, choose safe mode
2) If started -> cmd, msconfig, Check Selective startup, uncheck Load startup items, go to tab Services - > check Hide all Microsoft services, Disable All
3) Reboot normally, set needed services again with msconfig

понедельник, 23 января 2012 г.

rac: shutdown all instances immediate

--
-- Check shutdown option for each instance (default - immediate)
--
oracle@rac1:~> crs_stat -p ora.rac.rac1.inst | grep -i stop_mode
USR_ORA_STOP_MODE=immediate
--
-- Stop immediate (if USR_ORA_STOP_MODE<>immediate)
-- 
srvctl stop database -d <db_name> -o immediate

Update BLOB

set define off DECLARE    vb1 CLOB := 'long text';    vb2 CLOB :=                 'long text';    vb3 CLOB :=              ...