ORA-27102 Out of memory / Not enough space

I try to startup database getting below error. 

Solaris 11 64 Sparc Database 12c 


SQL> conn / as sysdba 
Connected to an idle instance. 
SQL> startup nomount pfile='/ora/app/oracle/product/12.2.0/dbhome_1/dbs/initinforln.ora'; 
ORA-27102: out of memory 
SVR4 Error: 12: Not enough space 
Additional information: 1671 
Additional information: 16106127360 
Additional information: 4513071104 
SQL> exit 
Disconnected 






Alert.log file
----------------

Mon Mar 13 12:30:57 2017 
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 

Mon Mar 13 12:30:57 2017 
Available system pagesizes: 
8K, 64K, 512K, 4096K, 32M, 256M 
Mon Mar 13 12:30:57 2017 
Supported system pagesize(s): 
Mon Mar 13 12:30:57 2017 
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s) 
Mon Mar 13 12:30:57 2017 
4096K Configured 10 1 ORA-27102 
Mon Mar 13 12:30:57 2017 
32M Configured 6 0 ORA-27102 
Mon Mar 13 12:30:57 2017 
256M Configured 16 0 ORA-27102 
Mon Mar 13 12:30:57 2017 
Reason for not supporting certain system pagesizes: 
Mon Mar 13 12:30:57 2017 
8K - Pagesize not supported by shared memory type 
Mon Mar 13 12:30:57 2017 
64K - Pagesize not supported by shared memory type 
Mon Mar 13 12:30:57 2017 
512K - Pagesize not supported by shared memory type 
Mon Mar 13 12:30:57 2017 
********************************************************************** 
-bash-4.1$ 




Solution:

I  added below parameter in parameter file and reboot the system.

Please check the following note: 
12C Database Instance Startup Fails With ORA-27102: OUT OF MEMORY Error On Solaris ( Doc ID 1987090.1 ) 

A workaround that has proven successful is to set the following parameter in the init/spfile and restart the database 



*._use_osm=FALSE





SQL>  startup nomount pfile='/ora/app/oracle/product/12.2.0/dbhome_1/dbs/initinforln.ora';
ORACLE instance started.

Total System Global Area 4529848320 bytes
Fixed Size                  2922936 bytes
Variable Size             973080136 bytes
Database Buffers         3539992576 bytes
Redo Buffers               13852672 bytes

SQL>

Refer:


https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=192956862419777&parent=SrDetailText&sourceId=3-14469331361&id=1987090.1&_afrWindowMode=0&_adf.ctrl-state=17xaia30lx_368

Creating, Destroying, and Renaming ZFS File Systems in Solaris 11 Sparc

Solaris 11 Sparc
--------------------

ZFS file systems can be created and destroyed by using the zfs create and zfs destroy commands. ZFS file systems can be renamed by using the zfs rename command.


Last time I added two new disks in M3000 Sparc Server which running on Solaris 11.3


Creating a ZFS file system
Destroying a ZFS file system
Renaming a ZFS file system



root@afi-ssaerp:/# zpool status
  pool: datapool
 state: ONLINE
  scan: none requested
config:

        NAME       STATE     READ WRITE CKSUM
        datapool   ONLINE       0     0     0
          c2t40d0  ONLINE       0     0     0

errors: No known data errors

  pool: lnpool
 state: ONLINE
  scan: none requested
config:

        NAME      STATE     READ WRITE CKSUM
        lnpool    ONLINE       0     0     0
          c1t2d0  ONLINE       0     0     0
          c1t3d0  ONLINE       0     0     0

errors: No known data errors

  pool: rpool
 state: ONLINE
  scan: none requested
config:

        NAME        STATE     READ WRITE CKSUM
        rpool          ONLINE            0     0     0
        c1t0d0s0   ONLINE              0     0     0

errors: No known data errors

root@afi-ssaerp:/#

 #  zpool create c1t2d0 c1t3d0 lnpool  (Pool Name)

   
#  zpool create lnpool c1t2d0 c1t3d0    

root@afi-ssaerp:~# format

Searching for disks...done


AVAILABLE DISK SELECTIONS:
       0. c1t0d0 <FUJITSU-MBD2147RC-3701 cyl 14087 alt 2 hd 24 sec 848>
          /pci@0,600000/pci@0/pci@0/scsi@0/sd@0,0
       1. c1t1d0 <FUJITSU-MBB2147RC-3703 cyl 14087 alt 2 hd 24 sec 848>
          /pci@0,600000/pci@0/pci@0/scsi@0/sd@1,0
       2. c1t2d0 <HGST-H101860SFSUN600G-A990-558.91GB>
          /pci@0,600000/pci@0/pci@0/scsi@0/sd@2,0
       3. c1t3d0 <HGST-H101860SFSUN600G-A3T0-558.91GB>
          /pci@0,600000/pci@0/pci@0/scsi@0/sd@3,0
       4. c2t40d0 <SUN-StorEdge 3510-327R-681.16GB>
          /pci@0,600000/pci@0/pci@8/SUNW,qlc@0/fp@0,0/ssd@w216000c0ff87d4cf,0



Specify disk (enter its number):

root@afi-ssaerp:~#  zpool list

NAME       SIZE  ALLOC   FREE  CAP  DEDUP  HEALTH  ALTROOT
datapool   680G   204K   680G   0%  1.00x  ONLINE  -
lnpool    1.09T   186K  1.09T   0%  1.00x  ONLINE  -
rpool      136G   133G  3.13G  97%  1.00x  ONLINE  -


root@afi-ssaerp:~#



Creating a ZFS file system


# df -h

lnpool                 1.1T    31K       1.1T     1%    /lnpool
lnpool/test            1.1T    31K       1.1T     1%    /test
lnpool/inforln         1.1T    31K       1.1T     1%    /inforln

 # zfs create lnpool/test


# zfs set mountpoint=/inforln lnpool/inforln




root@afi-ssaerp:/# zfs get mountpoint lnpool/ora

NAME        PROPERTY    VALUE  SOURCE
lnpool/inforln  mountpoint  /inforln   local

Destroying a ZFS File System

To destroy a ZFS file system, use the zfs destroy command. The destroyed file system is automatically unmounted and unshared. For more information about automatically managed mounts or automatically managed shares, see Automatic Mount Points. In the following example, the test file system is destroyed:

root@afi-ssaerp:/# zfs list
NAME                              USED  AVAIL  REFER  
lnpool                                234K  1.07T    31K  /lnpool
lnpool/inforln                     31K  1.07T    31K  /inforln
lnpool/ora                           31K  1.07T    31K  /ora
lnpool/test                           31K  1.07T    31K  /test

root@afi-ssaerp:/# zfs destroy lnpool/test

root@afi-ssaerp:/# zfs list

NAME                              USED  AVAIL  REFER 

lnpool/inforln                     31K  1.07T    31K  /inforln
lnpool/ora                           31K  1.07T    31K  /ora

remove test folder from / mount point
# rm -rf test





Renaming a ZFS file system

While renameing the zfs file system getting error: Cannot Un mount '/ora' device busy



root@afi-ssaerp:~# zfs rename rpool/ora rpool/ora1


cannot unmount '/ora': Device busy

We have to unmount the mountpoint /ora using below command.

root@afi-ssaerp:~# zfs umount -f /ora

root@afi-ssaerp:~# zfs rename rpool/ora rpool/ora1

root@afi-ssaerp:~# zfs mount rpool/ora1

root@afi-ssaerp:~# zfs mountpoint=ora1 rpool/ora1

root@afi-ssaerp:~# df -h
....


rpool/ora1              55G    12G       380M    97%    /ora1

Refer:


http://docs.oracle.com/cd/E19253-01/819-5461/gamnq/index.html

Possible index corruption detected. run dbcc checkdb

I get occasional Event Log Errors stating "Possible index corruption detected. Run DBCC CHECKDB

Use database_name
GO

ALTER DATABASE database_name SET SINGLE_USER
GO

DBCC CHECKDB('database_name', REPAIR_REBUILD)
GO

to return to multi-user mode:

ALTER <database-name> SET MULTI_USER

Refer:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fd80392c-fb4b-4743-955b-1cb1be5f7072/dbcc-checkdbdb-name-repairrebuild?forum=sqltools

ADSelfService Plus Service Pack Installation

Refer:   https://www.manageengine.com/products/self-service-password/service-pack.html

Service Pack Installation Steps: Follow steps 1 through 9 to apply the service pack.

Shut down ADSelfService Plus If the product runs as an application, click on Start --› All Programs --› ADSelfService Plus --› Stop ADSelfService Plus. If the product runs as a windows service, click on Start --› Run --› type "services.msc" --› Stop "ManageEngine ADSelfService Plus". Execute the stopDB.bat file under <ADSelfService Plus>\bin directory. Backup ADSelfService Plus by zipping the contents of <ADSelfService Plus> directory. In case of MS SQL Database Server, take a backup of the database also. Open Command Prompt and execute the UpdateManager.bat file under <ADSelfService Plus>\bin directory. For Windows Vista, Server 2008 and higher machines with User Account Control enabled, start the Command Prompt as an administrator (right-click Command Prompt and select 'Run as Administrator') Click Browse and select the .ppm file that you have downloaded. Click on Install for the service pack. Depending on the amount of data to be migrated, the installation procedure may take a few minutes. Please do not terminate prematurely. Click Close and then Exit to quit Update Manager tool. Start ADSelfService Plus.

Note:If you need to apply more than one service pack, follow the same instructions for each installation.

How do I find out my Current build number?

Log in to the ADSelfService Plus web client. Click on the License link at the top right corner. Find the Build number.

Class Not Registered ZK Attendance Management

I have installed ZK Attendance Management software on my Windows 7 64 bit OS. After installation, when I open the application, I'm getting an error message like "Class not registered". Can you help me solve this issue?

The problem is caused by the DLL that isn't correctly registered on your computer. I recommend that you run the following command to register all the DLL files using the necessary tool.

To do this, go to Start and type CMD. Right click it and select Run as Administrator. Paste the following command and then wait for its finish: FOR /R C:\ %G IN (*.dll) DO "%systemroot%\system32\regsvr32.exe" /s "%G"

Once the command is finished, run the software again and it should work. Additionally, reinstall it using its setup package.

While connect to time attendance machine getting error:  CLASS NOT REGISTERED


Below are Messages......while running the above script.


C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-msvcr100_clr_dll_31bf3856ad364e35_4.0.14305.0_none_ba482cf564b0ac9d\msvcr100_clr0400.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-msvcr120_clr_dll_31bf3856ad364e35_4.0.14305.0_none_beb50119e15f137f\msvcr120_clr0400.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-msvcr120_clr_dll_31bf3856ad364e35_4.0.14305.101_none_7e8d0b7e4e2ca385\msvcr120_clr0400.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-naturallanguage6_b03f5f7f11d50a3a_4.0.14305.0_none_5f3f2068ed7dc830\NaturalLanguage6.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-nlsdata0009_b03f5f7f11d50a3a_4.0.14305.0_none_8ead6f4a90f75f7b\NlsData0009.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-nlslexicons0009_b03f5f7f11d50a3a_4.0.14305.0_none_f8a8b0aa4cb63d5a\NlsLexicons0009.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-penimc_b03f5f7f11d50a3a_4.0.14305.0_none_8a664f39f4dd8789\PenIMC.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-perfcounter_dll_b03f5f7f11d50a3a_4.0.14305.0_none_0149234a28976eef\PerfCounter.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-peverify_dll_b03f5f7f11d50a3a_4.0.14305.0_none_8deb9024c0bee3d4\peverify.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-presentationhostdll_b03f5f7f11d50a3a_4.0.14305.0_none_09e70ecd482a42f9\PresentationHost_v0400.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-presentationnative_b03f5f7f11d50a3a_4.0.14305.0_none_45d191ec5f4432b8\PresentationNative_v0400.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-servicemodel..ormancecounters_dll_b03f5f7f11d50a3a_4.0.14305.0_none_e32e3123c980552d\ServiceModelPerformanceCounters.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-servicemodelinstallrc_dll_b03f5f7f11d50a3a_4.0.14305.0_none_f71e2a6d67f478de\ServiceModelInstallRC.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-servicemodelregui_dll_b03f5f7f11d50a3a_4.0.14305.0_none_2af7fab24e8d9a8a\ServiceModelRegUI.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-servicemonikersupport_dll_b03f5f7f11d50a3a_4.0.14305.0_none_c2855cab27647563\ServiceMonikerSupport.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-sos_dll_b03f5f7f11d50a3a_4.0.14305.0_none_3dbb98342db66929\SOS.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.addin.contract_b03f5f7f11d50a3a_4.0.14305.0_none_ad87847cd63b45ea\System.AddIn.Contract.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.addin_b03f5f7f11d50a3a_4.0.14305.0_none_49486a6a2e80f59e\System.AddIn.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.compo..del.dataannotations_b03f5f7f11d50a3a_4.0.14305.0_none_22fa666078551f20\System.ComponentModel.DataAnnotations.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.core_b03f5f7f11d50a3a_4.0.14305.0_none_96ec13f976ef247d\System.Core.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.data.datasetextensions_b03f5f7f11d50a3a_4.0.14305.0_none_166a20db4a37ebb2\System.Data.DataSetExtensions.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.data.entity.design_b03f5f7f11d50a3a_4.0.14305.0_none_e612f8e8b1723cbb\System.Data.Entity.Design.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.data.entity_b03f5f7f11d50a3a_4.0.14305.0_none_222a417bf3b8598b\System.Data.Entity.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.data.linq_b03f5f7f11d50a3a_4.0.14305.0_none_cf61b983362fabc8\System.Data.Linq.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.data.services.client_b03f5f7f11d50a3a_4.0.14305.0_none_2c233a63ce96f121\System.Data.Services.Client.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.data.services.design_b03f5f7f11d50a3a_4.0.14305.0_none_561361643c80c3d6\System.Data.Services.Design.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.data.services_b03f5f7f11d50a3a_4.0.14305.0_none_778526d29812a268\System.Data.Services.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.dynamic_b03f5f7f11d50a3a_4.0.14305.0_none_c2b7513de5be09c3\System.Dynamic.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.net_b03f5f7f11d50a3a_4.0.14305.0_none_62e7f1068c2318bd\System.Net.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.web.abstractions_b03f5f7f11d50a3a_4.0.14305.0_none_7abf9995dfe18bf7\System.Web.Abstractions.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.web.d..isualization.design_b03f5f7f11d50a3a_4.0.14305.0_none_3050159d4013b3ee\System.Web.DataVisualization.Design.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.web.datavisualization_b03f5f7f11d50a3a_4.0.14305.0_none_1c5b5a670561bbbc\System.Web.DataVisualization.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.web.dynamicdata.design_b03f5f7f11d50a3a_4.0.14305.0_none_356b4e2e2ca0f23b\System.Web.DynamicData.Design.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.web.dynamicdata_b03f5f7f11d50a3a_4.0.14305.0_none_54f3541c2fd50079\System.Web.DynamicData.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.web.entity.design_b03f5f7f11d50a3a_4.0.14305.0_none_3dc488d7c2fe2677\System.Web.Entity.Design.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.web.entity_b03f5f7f11d50a3a_4.0.14305.0_none_f64058ef28640cc9\System.Web.Entity.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.web.extensions.design_b03f5f7f11d50a3a_4.0.14305.0_none_33853a9c1cbae698\System.Web.Extensions.Design.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.web.extensions_b03f5f7f11d50a3a_4.0.14305.0_none_95bff917480463f4\System.Web.Extensions.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.web.routing_b03f5f7f11d50a3a_4.0.14305.0_none_bad8fa5542acd340\System.Web.Routing.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.windo..isualization.design_b03f5f7f11d50a3a_4.0.14305.0_none_76231f5052f42538\System.Windows.Forms.DataVisualization.Design.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.windo..s.datavisualization_b03f5f7f11d50a3a_4.0.14305.0_none_1b3758ed60078d60\System.Windows.Forms.DataVisualization.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system.xml.linq_b03f5f7f11d50a3a_4.0.14305.0_none_ab04c1a9ae7892b9\System.Xml.Linq.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system_core_ni_b03f5f7f11d50a3a_4.0.14305.0_none_96307a7a2f4c6676\system.core.ni.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system_enter..eservices_thunk_dll_b03f5f7f11d50a3a_4.0.14305.0_none_b519357267ba6e4c\System.EnterpriseServices.Thunk.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-system_ni_b03f5f7f11d50a3a_4.0.14305.0_none_3f7dfb0ca6ab2808\system.ni.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-tlbref_dll_b03f5f7f11d50a3a_4.0.14305.0_none_1c93a9de4a6d792d\TLBREF.DLL"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-vbc7ui_dll_b03f5f7f11d50a3a_4.0.14305.0_none_cdaa338468d4b252\vbc7ui.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-webengine4_dll_b03f5f7f11d50a3a_4.0.14305.0_none_2ef34cddd452a224\webengine4.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-webengine_dll_b03f5f7f11d50a3a_4.0.14305.0_none_7381f627e0e2b57e\webengine.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-wminet_utils_dll_b03f5f7f11d50a3a_4.0.14305.0_none_20f97dd7c085fde4\WMINet_Utils.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-workflowserv..ormancecounters_dll_b03f5f7f11d50a3a_4.0.14305.0_none_0ce649fe4d345561\WorkflowServiceHostPerformanceCounters.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_netfx4-wpfgfx_b03f5f7f11d50a3a_4.0.14305.0_none_8a5fca872ae9a3d7\wpfgfx_v0400.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_networking-mpssvc-admin.resources_31bf3856ad364e35_10.0.14393.0_en-us_1245eb73f51ecad4\AuthFWSnapIn.Resources.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_networking-mpssvc-admin.resources_31bf3856ad364e35_10.0.14393.0_en-us_1245eb73f51ecad4\AuthFWWizFwk.Resources.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_networking-mpssvc-admin_31bf3856ad364e35_10.0.14393.0_none_76a7fdeae024293b\AuthFWGP.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_networking-mpssvc-admin_31bf3856ad364e35_10.0.14393.0_none_76a7fdeae024293b\AuthFWSnapin.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_networking-mpssvc-admin_31bf3856ad364e35_10.0.14393.0_none_76a7fdeae024293b\AuthFWWizFwk.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_ntprint.inf_31bf3856ad364e35_10.0.14393.0_none_0c566cf919081469\I386\MXDWDRV.DLL"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_ntprint.inf_31bf3856ad364e35_10.0.14393.0_none_0c566cf919081469\I386\PCL4RES.DLL"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_ntprint.inf_31bf3856ad364e35_10.0.14393.0_none_0c566cf919081469\I386\PCL5ERES.DLL"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_ntprint.inf_31bf3856ad364e35_10.0.14393.0_none_0c566cf919081469\I386\PCL5URES.DLL"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_ntprint.inf_31bf3856ad364e35_10.0.14393.0_none_0c566cf919081469\I386\PCLXL.DLL"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_ntprint.inf_31bf3856ad364e35_10.0.14393.0_none_0c566cf919081469\I386\PJLMON.DLL"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_ntprint.inf_31bf3856ad364e35_10.0.14393.0_none_0c566cf919081469\I386\PS5UI.DLL"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_ntprint.inf_31bf3856ad364e35_10.0.14393.0_none_0c566cf919081469\I386\PSCRIPT5.DLL"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_ntprint.inf_31bf3856ad364e35_10.0.14393.0_none_0c566cf919081469\I386\UNIDRV.DLL"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_ntprint.inf_31bf3856ad364e35_10.0.14393.0_none_0c566cf919081469\I386\UNIDRVUI.DLL"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_ntprint.inf_31bf3856ad364e35_10.0.14393.0_none_0c566cf919081469\I386\UNIRES.DLL"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_policy.1.0.microsof..op.security.azroles_31bf3856ad364e35_10.0.14393.0_none_6eda7f57c51a08aa\Policy.1.0.Microsoft.Interop.Security.AzRoles.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_policy.1.2.microsof..op.security.azroles_31bf3856ad364e35_10.0.14393.0_none_be0fd33f89b5fc8c\Policy.1.2.Microsoft.Interop.Security.AzRoles.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_presentationcore_31bf3856ad364e35_4.0.14305.0_none_04b8cb3e135ebcce\PresentationCore.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_prnms003.inf_31bf3856ad364e35_10.0.14393.0_none_24254896323538cd\I386\PrintConfig.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_srmlib_31bf3856ad364e35_10.0.14393.0_none_d35e7ce6c53698cd\srmlib.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_startupapp-task-data_31bf3856ad364e35_10.0.14393.0_none_15dd750273cdf6b1\Startupscan.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_system.data.oracleclient_b77a5c561934e089_4.0.14305.0_none_a335c584d166caf1\System.Data.OracleClient.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_system.data_b77a5c561934e089_4.0.14305.0_none_44964a14a86ef5da\System.Data.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_system.data_b77a5c561934e089_4.0.14305.101_none_3c6315f663749084\System.Data.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_system.enterpriseservices_b03f5f7f11d50a3a_4.0.14305.0_none_85a688c4a2562559\System.EnterpriseServices.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_system.enterpriseservices_b03f5f7f11d50a3a_4.0.14305.0_none_85a688c4a2562559\System.EnterpriseServices.Wrapper.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_system.printing_31bf3856ad364e35_4.0.14305.0_none_7a4dced68804f53b\System.Printing.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_system.transactions_b77a5c561934e089_4.0.14305.0_none_c38a9d6d5ccc9c87\System.Transactions.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_system.web_b03f5f7f11d50a3a_4.0.14305.0_none_a72795b40ac25f28\System.Web.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wcf-m_sm_evt_dll_vista_31bf3856ad364e35_10.0.14393.0_none_49c000dbf6b6d3c4\ServiceModelEvents.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wcf-m_sm_ins_rc_dll_31bf3856ad364e35_10.0.14393.0_none_9a52154ea819d657\ServiceModelInstallRC.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wcf-m_svc_mon_sup_dll_31bf3856ad364e35_10.0.14393.0_none_7733d544a9f39e0e\ServiceMonikerSupport.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wcf-m_svc_mon_sup_dll_31bf3856ad364e35_10.0.14393.479_none_837afc1231401ddc\ServiceMonikerSupport.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wcf-system.identitymodel.selectors_b03f5f7f11d50a3a_10.0.14393.0_none_1a72509ad1415b52\System.IdentityModel.Selectors.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wcf-system.identitymodel_b03f5f7f11d50a3a_10.0.14393.0_none_dca96137e0adade4\System.IdentityModel.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wcf-system.identitymodel_b03f5f7f11d50a3a_10.0.14393.479_none_fab8de7dee16f506\System.IdentityModel.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wcf-system.io.log_b03f5f7f11d50a3a_10.0.14393.0_none_916e968c5b4d79f9\System.IO.Log.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wcf-system.runtime.serialization_b03f5f7f11d50a3a_10.0.14393.0_none_be41a880c0e4344b\System.Runtime.Serialization.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wcf-system.runtime.serialization_b03f5f7f11d50a3a_10.0.14393.479_none_dc5125c6ce4d7b6d\System.Runtime.Serialization.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wcf-system.servicemodel_b03f5f7f11d50a3a_10.0.14393.0_none_cbf9b86c8ba3f1fd\System.ServiceModel.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wcf-system.servicemodel_b03f5f7f11d50a3a_10.0.14393.479_none_ea0935b2990d391f\System.ServiceModel.dll"

C:\WINDOWS\system32>"C:\WINDOWS\system32\regsvr32.exe" /s "C:\Windows\WinSxS\x86_wpf-presentationhostproxy_31bf3856ad364e35_10.0.14393.0_none_fbe0e6a3d824509c\PresentationHostProxy.dll"


......

......

Once it finished try to connect machine.


Reference:

http://answers.informer.com/124255/zkteco-attendance-management-information

DNS client configuration steps in Oracle Solaris 11

root@afi-drsvr:/etc# svccfg -s network/dns/client
svc:/network/dns/client> setprop config/search = astring: ("afigroup.com""afidc01.afigroup.com")
svc:/network/dns/client> setprop config/nameserver = netaddress: (192.0.0.9 192.0.0.10)
Unknown type "netaddress:".
svc:/network/dns/client> setprop config/nameserver = net_address: (192.0.0.9 192.0.0.10)
svc:/network/dns/client> exit
root@afi-drsvr:/etc# svccfg enable -r dns/client
svccfg: Unknown command "enable".
root@afi-drsvr:/etc#
root@afi-drsvr:/etc# svcadm refresh dns/client
root@afi-drsvr:/etc# svcadm restart dns/client
root@afi-drsvr:/etc# pwd
/etc
root@afi-drsvr:/etc# ls -l resolv.conf
-rw-r--r--   1 root     root         249 Feb  6 16:34 resolv.conf
root@afi-drsvr:/etc# cat resolv.conf

#
# _AUTOGENERATED_FROM_SMF_V1_
#
# WARNING: THIS FILE GENERATED FROM SMF DATA.
#   DO NOT EDIT THIS FILE.  EDITS WILL BE LOST.
# See resolv.conf(4) for details.

search  afigroup.com afidc01.afigroup.com
nameserver      192.0.0.9
nameserver      192.0.0.10
root@afi-drsvr:/etc#

root@afi-drsvr:/etc# svccfg -s system/name-service/switch
svc:/system/name-service/switch> setprop config/host = astring: "files dns"
svc:/system/name-service/switch> exit
root@afi-drsvr:/etc# svcadm refresh name-service/switch
root@afi-drsvr:/etc# svcadm restart  name-service/switch
root@afi-drsvr:/etc# ls -l nss*
-rw-r--r--   1 root     sys         1682 Oct  6  2015 nsswitch.ad
-rw-r--r--   1 root     sys          515 Feb  6 16:38 nsswitch.conf
-rw-r--r--   1 root     sys          511 Feb  2 15:46 nsswitch.conf.old
-rw-r--r--   1 root     sys         1392 Oct  6  2015 nsswitch.dns
-rw-r--r--   1 root     sys          925 Oct  6  2015 nsswitch.files
-rw-r--r--   1 root     sys         1221 Oct  6  2015 nsswitch.ldap
-rw-r--r--   1 root     sys         1150 Oct  6  2015 nsswitch.nis
root@afi-drsvr:/etc# cat nsswitch.conf

#
# _AUTOGENERATED_FROM_SMF_V1_
#
# WARNING: THIS FILE GENERATED FROM SMF DATA.
#   DO NOT EDIT THIS FILE.  EDITS WILL BE LOST.
# See nsswitch.conf(4) for details.

passwd: files
group:  files
hosts:  files dns
ipnodes:        files dns
networks:       files
protocols:      files
rpc:    files
ethers: files
netmasks:       files
bootparams:     files
publickey:      files
netgroup:       files
automount:      files
aliases:        files
services:       files
printers:       user files
project:        files
auth_attr:      files
prof_attr:      files
tnrhtp: files
tnrhdb: files
sudoers:        files
root@afi-drsvr:/etc#
root@afi-drsvr:/etc# pwd
/etc
root@afi-drsvr:/etc# ping testdc01
afidc01 is alive
root@afi-drsvr:/etc# ping testgroup.com
afigroup.com is alive
root@afi-drsvr:/qas/QAS_4_1_1_22824# ls
add-ons           autorun.exe       changelog.txt     copyrights.txt    eula.txt          preflight.sh      version.txt
autorun           autorun.inf       client            docs              install.sh        ReleaseNotes.htm  windows
root@afi-drsvr:/qas/QAS_4_1_1_22824# ./preflight.sh

Enter an Active Directory domain: afigroup.com
Enter an Active Directory user with administrator privileges: administrator

Report all results (default: only advisories and failures) (yes|no)? [no]: yes
--------------------------------------------------------------------------------
/qas/QAS_4_1_1_22824/client/solaris8-sparc/preflight  --verbose -u administrator afigroup.com
Starting Preflight Checks ...
Starting Install Checks
  Check for Supported operating system and correct OS patches            Success
    OS and patches checked - OK
  Check for sufficient disk space to install software                    Success
    430675138 kB available on /etc /opt - OK, 430675138 kB available
     on /var - OK
Install Checks complete                                                  Success
Starting Join Checks
Password for administrator@AFIGROUP.COM:
  Check that the hostname of the system is not 'localhost'               Success
    hostname is not localhost
  Check that the DNS Top Level Domain (TLD) is not '.local'              Success
    TLD is not local
  Check if the name service is configured to use DNS                     Success
    DNS lookups enabled in /etc/nsswitch.conf
  Check /etc/resolv.conf for proper formatting of nameservice            Success
   entries and that the nameservers can be resolved
    resolv.conf OK
  Check for a nameserver that has the appropriate DNS SRV records        Success
   for Active Directory
    afidc01.afigroup.com,afibdc01.afigroup.com
  Selects a writable DC with port 389 (UDP) open to use for the checks   Success
    DC for afigroup.com is afibdc01.afigroup.com and port 389 (UDP)
     is open
  Display AD site of user running checks if available                    Success
    Site for afigroup.com is Default-First-Site-Name
  Check if port 464 (TCP) is open for Kerberos Kpasswd                   Success
    Pinged port 464 (TCP) on afibdc01.afigroup.com
  Check if port 88 (TCP) is open for Kerberos traffic                    Success
    Pinged port 88 on afibdc01.afigroup.com using TCP
  Check if port 389 (TCP) is open for LDAP                               Success
    Pinged port 389 (TCP) on afibdc01.afigroup.com
  Check for Global Catalog and port 3268 (TCP) is open to the GC         Success
    Found global catalog at afibdc01.afigroup.com and able to ping
     on port 3268 (TCP)
  Check for a valid time skew against Active Directory DC                Success
    timesync ok with afibdc01.afigroup.com
  Check for QAS Application Configuration                                Success
    CN={786E0064-A470-46B9-83FB-C7539C9FA27C},CN=Authentication
     Services,CN=Quest Software,CN=Program Data,DC=afigroup,DC=com
Join Checks complete                                                     Success
Starting Post Join Checks
  Check if port 445 (TCP) is open for Microsoft Directory Services       Success
    Pinged port 445 (TCP) on afibdc01.afigroup.com
Post Join Checks complete                                                Success

Preflight Checks ... complete                                            Success
root@afi-drsvr:/qas/QAS_4_1_1_22824#


Reference:

https://blogs.oracle.com/gurubalan/entry/dns_client_configuration_guide_for

Oracle 12c database cannot log in as a local user

I created database in Oracle 12c ...and I created local user but when I connect to database getting below error.

SQL> connect / as sysdba

SQL> alter session set container=ptest

SQL> alter user bsp
  2  identified by test123;

User altered.

SQL> conn bsp/test123@ptest
ERROR:

--------------------------------------------------------------------------------------------------------------

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
--------------------------------------------------------------------------------------------------------------

-bash-4.1$ cat listener.ora
# listener.ora Network Configuration File: /ora/app/oracle/product/12.1.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = inforln)
      (ORACLE_HOME = /ora/app/oracle/product/12.1.0)
      (SID_NAME = inforln)
    )
)
#    (SID_DESC =
#      (GLOBAL_DBNAME = inforln)
#      (ORACLE_HOME = /ora/app/oracle/product/12.1.0)

#      (SID_NAME = pinforln)
#    )
#  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.0.106)(PORT = 1522))
  )

ADR_BASE_LISTENER = /ora/app/oracle12c

-bash-4.1$

----------------------------------------------------------------------------------------------------------

-bash-4.1$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /ora/app/oracle/product/12.1.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.




TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.0.144)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = TEST)
    )
  )

LISTENER_TEST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.0.144)(PORT = 1522))


PTEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.0.144)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ptest)
    )
  )

-bash-4.1$

-----------------------------------------------------------------------------------------------------------

Solution:

We have to change the local_listener parameter in spfile.



SQL> connect / as sysdba



SQL> show parameter local_listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string

SQL> alter system set local_listener=inforln;

System altered.


SQL> show parameter local

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      INFORLN
parallel_force_local                 boolean     FALSE



SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

-bash-4.1$ ./sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jan 22 15:07:51 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.
SQL> alter session set container=ptest;

Session altered.

SQL> connect bsp/test123@pitest;
Connected.

SQL> alter session set container=ptest;

Session altered.

SQL> connect bsp/test123@ptest;
Connected.