How to use multiple ODBC data sources with Oracle hsodbc / dg4odbc / generic connectivity

 

1.

Create multiple initSID.ora

inithsodbc.ora

HS_FDS_CONNECT_INFO = hsodbc
HS_FDS_TRACE_LEVEL = 0

initz.ora

HS_FDS_CONNECT_INFO = z
HS_FDS_TRACE_LEVEL = 0

 

2.

(SID_DESC =
      (SID_NAME = hsodbc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = hsodbc)

    )
    (SID_DESC =
      (SID_NAME = z)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = hsodbc)

    )

3.

HSODBC =
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA = (SID = hsodbc))
      (HS = OK)
    )

z =
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA = (SID = z))
      (HS = OK)
    )

4.

CREATE DATABASE LINK hsodbc USING 'hsodbc';

CREATE DATABASE LINK z USING 'z';

 

 

 

 

source  : https://knowledgebase.progress.com/articles/Article/6177

Increase sga_max_size on Oracle 10g Windows

 

1:- Check file location of spfile/pfile

SQL> show parameter spfile;
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string

2:- Check the value of SGA

    
SQL> show parameter sga_
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_max_size                         big integer 20G
sga_target                           big integer 20G
unified_audit_sga_queue_size         integer     1048576

Increase sga_max_size on Oracle 10g Windows

alter system set sga_max_size=800M scope=spfile;
 
System altered.
 
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
 
Total System Global Area  838860800 bytes
Fixed Size                  2929936 bytes
Variable Size             390073072 bytes
Database Buffers          440401920 bytes
Redo Buffers                5455872 bytes
Database mounted.
Database opened.
SQL>  alter system set sga_target=800M scope=both;

 

done

 

source : https://dbsguru.com/step-by-step-how-to-increase-sga-size-in-oracle/

https://dba.stackexchange.com/questions/121553/increase-sga-max-size-on-oracle-10g-windows

Check the Usage of SGA in Oracle

 Check the Usage of SGA

select round(used.bytes /1024/1024 ,2) used_mb
, round(free.bytes /1024/1024 ,2) free_mb
, round(tot.bytes /1024/1024 ,2) total_mb
from (select sum(bytes) bytes
from v$sgastat
where name != 'free memory') used
, (select sum(bytes) bytes
from v$sgastat
where name = 'free memory') free
, (select sum(bytes) bytes
from v$sgastat) tot ;

   USED_MB    FREE_MB   TOTAL_MB
---------- ---------- ----------
    799.69      736.3       1536

Find the Total Size of SGA

SELECT sum(value)/1024/1024 "TOTAL SGA (MB)" FROM v$sga;
TOTAL SGA (MB)
--------------
1535.99715

Check size of different pool in SGA

Select POOL, Round(bytes/1024/1024,0) Free_Memory_In_MB From V$sgastat Where Name Like '%free memory%';

POOL           FREE_MEMORY_IN_MB
-------------- -----------------
shared pool                  564
large pool                   108
java pool                     32
streams pool                  32

How do I resolve 'The character device /dev/vboxdrv does not exist' error in Ubuntu 18.04 [closed]

 

It clearly states that you need to install the virtualbox-dkms packages. You can follow these steps to solve the problem.

    Install the virtualbox-dkms

sudo apt-get install virtualbox-dkms

    Once you install those packages you also need to do the reconfiguration:

sudo dpkg-reconfigure virtualbox-dkms
sudo dpkg-reconfigure virtualbox

    If your problem is still not fixed try installing the headers:

sudo apt-get install linux-headers-generic

source : https://stackoverflow.com/questions/60350358/how-do-i-resolve-the-character-device-dev-vboxdrv-does-not-exist-error-in-ubu

Why am I getting this laravel url routing error in .htaccess?

 

http://localhost/example-app/

to

http://localhost/example-app/public

 

just simple create .htaccess on root laravel project and type this script

By default the website will be load from public folder. If you want to remove public from your url,copy .htaccess file from public folder to root and replace the code with the following..

<IfModule mod_rewrite.c>
<IfModule mod_negotiation.c>
    Options -MultiViews
</IfModule>

RewriteEngine On


RewriteCond %{REQUEST_FILENAME} -d [OR]
RewriteCond %{REQUEST_FILENAME} -f
RewriteRule ^ ^$1 [N]

RewriteCond %{REQUEST_URI} (\.\w+$) [NC]
RewriteRule ^(.*)$ public/$1

RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^ server.php




If you don't want to remove all files and folder from the public folder, then just copy .htaccess to your root directory and rename server.php to index.php and last one step is if all resource files in /public directory couldn't find and request URLs didn't work for using asset() helper. Then, you need to add public to your helpers.php file.
function asset($path, $secure = null)
{
    return app('url')->asset($path, $secure);
}

To

function asset($path, $secure = null)
{
    return app('url')->asset("public/".$path, $secure);
}

You will fine the helpers.php in vendor/laravel/framework/src/Illuminate/Foundation/helpers.php.

source : https://stackoverflow.com/questions/58230970/why-am-i-getting-this-laravel-url-routing-error-in-htaccess

How to fix Error: laravel.log could not be opened?

The stream or file "/media/data1/opt/lampp/htdocs/example-app/storage/logs/laravel.log" could not be opened in append mode: failed to open stream: Permission deniecd laravel/

sudo chmod -R 777 storage