How to create CMAN listener

Installation & Configuration of Connection Manager (CMAN) Oracle 10g

Just follow below steps and make your life easier.

Click start menu ===> Oracle-OraDb10g_home1 ===> click on Universal Installer

 1. Run universal installer from installed oracle_home.

2. Click on Button “Next”.

 

3. Specify Setup files location and Click on Button “Next”.

 

4. Select option “Custom” and Click on Button “Next”.

5. Select installed DB oracle home and Click on Button “Next”.

 

6. Check both these boxes to be user verified and Click on Button “Next”.

7. Check “Oracle Connection Manager” and Uncheck “Oracle Services for Microsoft Transaction Server”. Click on Button “Next”.

 

8. Click on Button “Install”.

 

9. Click on Button “Exit”.

 

10. Copy this CMAN.ORA file from path “D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\SAMPLE” This file will auto creates just after CMAN installation. Make changes that are in red color and give following values.

cman <alias>

local IP of Database<192.168.1.54>

listener port <1620>

11.Open CMD and type follwing commands,

• cmctl
• administrator cman
• startup

12. Change “Startup Type” of these services to Automatic. 

 

How to Create /Drop /DB link in oracle

Two way to create DB link in oracle Database

1. With TNS entry in tnsnames.ora

2. TNS entry given at the time of db link creation.

Create DB link

1st method: Create DBLINK with TNS entry name made in tnsnames.ora

Put a TNS in tnsnames.ora file with name like “TEST”

CREATE PUBLIC DATABASE LINK 'TEST'

 CONNECT TO 'USER Name'

 IDENTIFIED BY 'Password'

 USING 'TEST'

TNS entry like;

TEST=

  (DESCRIPTION=

    (ADDRESS=

      (PROTOCOL=TCP)

      (HOST=hostname)

      (PORT=1521)

    )

    (CONNECT_DATA=

      (SERVER=dedicated)

      (SERVICE_NAME=test)

    )

  )

2^nd method with full TNS

CREATE PUBLIC DATABASE LINK “TEST”

 CONNECT TO “USER Name”

 IDENTIFIED BY “Password”

 USING TEST=

  (DESCRIPTION=

    (ADDRESS=

      (PROTOCOL=TCP)

      (HOST=hostname)

      (PORT=1521)

    )

    (CONNECT_DATA=

      (SERVER=dedicated)

      (SERVICE_NAME=test)

    )

  )

DROP DBLINK:

DROP PUBLIC DATABASE LINK ‘TEST’

How to create oracle listener

Press window+R and type “NETCA” and press enter

Oracle Net Configuration Assistant Welcome window will be opened

Select “Listener Configuration” and click next

Select “Add” and click next, and at this window you can manage already exist Listener.

Type here Listener name as you want. If not then remain as default like “LISTENER” and click next

At this window select Available protocol like “TCP” and click next

Oracle Listener use 1521 standard port to communicate with networks and applications. If you want to use standard port (1521) then click next otherwise you can change another port here. And click next

At this point select option “No” and click next

Listener configuration complete window will open and then click next

And click finish.

How to uninstall oracle completely.

How to uninstall oracle completely. 

1.       Uninstall all Oracle components using the Oracle Universal Installer (OUI), click on remove button.

2.       If your OS is 32 bit then follow this Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key. This contains registry entries for all Oracle products.
3.       If your OS is 64 bit then follow this Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ Wow6432Node/ORACLE key. This contains registry entries for all Oracle products.
4.       Delete any references to Oracle services left behind in the following part of the registry:
5.       HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora*
6.       Reboot your machine.
7.       Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_HOME.
8.       Delete the "C:\Program Files\Oracle" directory.
9.       Empty the contents of your "c:\temp" directory.
10.   Empty your recycle bin.

At this point your machine will be as clean of Oracle components as it can be without a complete OS reinstall.

Remember, manually editing your registry can be very destructive and force an OS reinstall so only do it as a last resort.

How to solve ora-06413

Unable to open oracle connection (ora-06413)

Cause:

The problem scenario: some time oracle 10g could not open connection with applications like Microsoft Access, Visual Studio, and ODBC connections etc. Those applications are installed in C:\Program Files (x86). And cause is that oracle do not make connection with such these applications due to parentheses.

Solution:

Here's the real trick to making this all work; Set up a symlink to the c:\Program Files (x86) folder without the parentheses.

Open Command Prompt and "Run as administrator" At the command prompt, enter the following command;

mklink /D "C:\Program Files x86" "C:\Program Files (x86)”

Now to onwards run applications from C:\Program Files x86.

ORACLE user create

How to create user in oracle;

CREATE USER TEST IDENTIFIED BY TEST;

DEFAULT TABLESPACE USERS;

TEMPORARY TABLESPACE TEMP;

PROFILE DEFAULT;

ACCOUNT UNLOCK;

How to grant access to user;

-----Role for USER----

GRANT DBA TO TEST;

ALTER USER TEST DEFAULT ROLE ALL;

-------System Privilege for USER------

GRANT UNLIMITED TABLESPACE TO TEST;