Oracle Database

Install Oracle Database 11g R2 on Window Server 2012 R2

If you are installing from distribution media, insert the distribution media for Oracle Database into your computer. The Auto run feature opens the Select a Product to install window automatically. If you have downloaded the installation software from the Oracle Web site, follow the instructions Copy the setup and extract it. Then the setup to …

Install Oracle Database 11g R2 on Window Server 2012 R2 Read More »

Installing Oracle Database 12c Release 2 on Windows Server 2012 R2

The following picture shows the structure of the folder of the Oracle installation files after extraction. Open the folder and run as administrator start the setup The installer asks you to provide your email address to get the latest security issues and updates. You can ignore it by clicking the Next button Oracle installer ask …

Installing Oracle Database 12c Release 2 on Windows Server 2012 R2 Read More »

How to Fix ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

SID is word or DB_UNIQUE_NAME that precedes the DB_DOMAIN. For example, the SID database, as seen in in the full global database name of bookstore.company.com. SERVICE_NAMES, on the other hand, represent the names by which database instances can be connected to. A SERVICE_NAME will follow the format of the SID followed by the database domain, …

How to Fix ORA-12505, TNS:listener does not currently know of SID given in connect descriptor Read More »

Change Oracle Database port from port 8080

From Start | Run open a command window. Assuming your environmental variables are set correctly start with the following: C:\>sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 – Production on Tue Aug 26 10:40:44 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> connect Enter user-name: system Enter password: <enter password > Connected. SQL> Exec DBMS_XDB.SETHTTPPORT(3010); [Assuming you want to have HTTP going to this port]  PL/SQL procedure successfully completed. SQL>quit Then open browser and …

Change Oracle Database port from port 8080 Read More »

Installing Oracle Database 12c Release 1 on Windows Server 2012 R2

Download the setup For Windows Setup Download link below: http://download.oracle.com/otn/nt/oracle12c/121020/winx64_12102_database_1of2.zip http://download.oracle.com/otn/nt/oracle12c/121020/winx64_12102_database_2of2.zip Once download open folder and start the setup. For support you can give email address or skip the option. Choose the option from the following options Like * Create and Configure a database * Install database software only * Upgarde an existing database Now …

Installing Oracle Database 12c Release 1 on Windows Server 2012 R2 Read More »

CHANGING THE CHARACTER SET TO AL32UTF8 in Oracle Database

Open cmd as administrator. And the following command. # sqlplus / as sysdba Like in below screen it’s now connected. Follow the below steps. SQL> SHUTDOWN IMMEDIATE SQL> STARTUP RESTRICT SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8; SQL>ALTER DATABASE CHARACTER SET AL32UTF8; SQL> SHUTDOWN IMMEDIATE SQL> STARTUP SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’ …

CHANGING THE CHARACTER SET TO AL32UTF8 in Oracle Database Read More »

Oracle Database 12 Release 2 Installation Step By Step on Window Server 2008

If you are installing from distribution media, insert the distribution media for Oracle Database into your computer. The Auto run feature opens the Select a Product to install window automatically. If you have downloaded the installation software from the Oracle Web site, follow the instructions on the site to invoke the Oracle Universal Installer. Download …

Oracle Database 12 Release 2 Installation Step By Step on Window Server 2008 Read More »

Change Oracle Database port from port 8080

From Start | Run open a command window. Assuming your environmental variables are set correctly start with the following: C:\>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 – Production on Tue Aug 2610:40:442008Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> connectEnter user-name: systemEnter password: <enter password >Connected. SQL> Exec DBMS_XDB.SETHTTPPORT(3010); [Assuming you want to have HTTP going to …

Change Oracle Database port from port 8080 Read More »

Oracle Database 19c Installation on Oracle Linux 7

Pre-installation settings before installing Oracle Database 19c SELinux If the OS is to be used for an Oracle installation, it is easier if Secure Linux (SELinux) is disabled or switched to permissive. To do this edit the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows. # vi /etc/selinux/config SELINUX=permissive If SELinux is …

Oracle Database 19c Installation on Oracle Linux 7 Read More »

Shares