Could not resolve service name /vdir/filename.asp , The Oracle(tm) client and networking components were not found asp connection oracle

When trying to connect to Asp to oracle the following error messages may come.

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Oracle][ODBC][Ora]ORA-12154: TNS:Could not resolve service name /vdir/filename.asp, line NNN.

OR

The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation.

You will be unable to use this driver until these components have been installed.

To find out the reason and solutions for this error follow the following steps

1. Try a test connection in oracle's sql plus utility. If the connection fails you have a bad installation or configuration of oracle client components.

2. If the oracle is first installed on IIS you should reboot at once.

3. If theire is multiple copies of OCIW32.dll you have to make sure that there is only one copy of OCIW32.dll which should be in /Bin folder of the oracle home folder.

4. Add the IUSR_machine name account and the IWAM_machine name account to the Oracle home folder. Give both accounts full control.

To do this, right-click on the Oracle home folder in Windows Explorer. Click Properties, and then click the Security tab. Add the appropriate accounts and then give them full control. Restart your computer. IDShop – ID Card Printers, Biometric, Security Systems in Dubai, UAE Cloud Based Card Printing Software UAE ID Card Printer Supplier Dubai | Plastic Card Printer in Abu Dhabi, UAE ID Card Printer

internal error while parsing spatial parameters

internal error while parsing spatial parameters

Its a common error while running query to oracle table

Here is the cause and actions to be taken to avoid this error

Reason


An internal error was encountered while parsing the spatial parameters.


Actions

Check that the parameters passed in the parameter string are all valid.

session references process private memory; cannot detach session

session references process private memory; cannot detach session

This error is comming as usual to oracle DBA in everytime

Here is the cause and ways to avoid this error


Reason

An attempt was made to detach the current session when it contains
references to process private memory.


Action

A session may contain references to process memory (PGA) if it has
an open network connection, a very large context area, or operating
system privileges. To allow the detach, it may be necessary to
close the session's database links and/or cursors. Detaching a
session with operating system privileges is always disallowed.

maximum number of processes (string) exceeded

ORA-00020: maximum number of processes (%s) exceeded

This means that you have too many database connections basically. Unfortunately since the demise of svrctl, it also means that you as a DBA cannot connect internal to do something about it!

You need to either ask a couple of users to log out, or you need to kill some sessions at the OS level. Once you managed to connect, see if you can spot anyone making abnormal numbers of connections. If you can't find anything you will need to increase the init parameter 'processes'. Unfortunately, this will require a restart of the database to take effect:


SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
processes integer 150

SQL> select count(*) from v$process;

COUNT(*)
----------
149

SQL> alter system set processes=300 scope=spfile;

System altered.

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

SQL> startup
ORACLE instance started.

SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
processes integer 300



Note. The maximum allowed processes is one less than the init parameter 'processes'

Note. When connecting via TNS, you may get this error when the database is out of processes:

Cardline Saudi is a leading supplier of badge printers and security systems in Riyadh, Dammam, and other regions. They offer high-quality printers, encoders, and biometric facial recognition systems. Learn more about their products and services.