Kepler Technologies

Kepler Technologies is organizing a walking interview for the post of career counselor (preferably female) from 30 Oct to 2 Nov.

Venue:
D71B Malviya Nagar

Opp. Axis Bank

New Delhi 110017
Contact No: 91-11-41070037, 85-06-05-05-12/13/14/15
Job Location:
Malviya Nagar, New Delhi

Job Description:
Business Development Executive/Career Counselor for US Based IT Training company with its branch in Delhi and Gurgaon with the below responsibilities.

You can also refer this job to your friends who might be interested.

Desired Candidate Profile:
Excellent Communication and Convincing skill is must.
Fluency in English is must.
Proficient in creating PowerPoint presentations.
Listening Skill.
Ability to hold a conversation.
Sound Analytical skills.
Smart, Energetic and motivated candidates with good Computer Skills.
Job will be target driven and incentive based with lots of potential and career growth.
Fresher with good communication skill can apply for trainee position.
Job Responsibilities :
Working with USA office on a regular basis and provide daily, weekly and monthly progress.
Promoting the company brand. Working on ideas to generate revenues.
Working with HR of IT Companies to identify their training needs and arrange for Corporate IT training.
Convincing the B.E, B Tech, MCA graduates to join our Job guaranteed IT training courses.
Arranging seminars/web presentations for students/IT professionals about our courses to create awareness and encourage them to join the IT courses.
Working with HR of IT Companies to help them with their Permanent and Temporary Staffing requirements.
Responsible for placement of students in IT Companies.
Keep track of inquiries from various modes like emails, telephone and direct inquiries during exhibition and maintaining the record of the same.
Other routine office work comprising of data entry, research on the Internet, etc

Company Profile
Kepler Technologies
www.keplertechnologies.com
We are an US based IT company with specialization in Oracle, Microsoft, Sun and Red Hat Consulting,Staffing and Training. We are Oracle Certified Gold Partners to offer their product and services. We have offices in Noida and Gurgaon. We provide excellent career growth opportunities to deserving candidates. Please visit our website keplertechnologies.com for more details.

KEPLER Kepler Technologiesoffers High end technology and Manpower solutions to Individual and Fortune 500 companies. The company’s expertise in consulting, content design, hi-end technology training and assessment helps individuals and corporates to enhance their skill cost effectively and efficiently. It ...

Oracle Network Configuration
Listener is a process which runs on the Oracle Server. This process fulfills connection requests from Clients to connect to the database instance.

By default, the Listener name is LISTENER which runs on port 1521.

A DBA can create multiple listeners for one database. For Example: LISTENER1, LISTENER2, LISTENER_ORA11G etc.

Multiple listeners should run on different ports. For Example: 1521, 1522, 1523 etc

Listener.ora is files that store Listener configuration details.

Tnsnames.ora is file that stores Database addresses and is used mainly by Remote clients/Machines to connect to Oracle Database.

The listener receives a client connection request.
The listener starts a dedicated server process, and the dedicated server inherits the connection request from the listener.
The client is now connected directly to the dedicated server.
Sqlnet.ora is a file that specifies the database domain and naming method used to connect to database.

Oracle Networking Configuration Files

Configuration File Description
listener.ora Located on the database server at the location $ORACLE_HOME/network/admin
Protocol
Host
Port
Database SID or Service Name
tnsnames.ora Required mainly on the client machines at location $ORACLE_HOME/network/adminCan optionally be present on Database Server Machine
sqlnet.ora Located on each client machines and database server computer, this file may include:
Order of naming methods the client should use when resolving a name
Client domain
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
NAMES.DEFAULT_DOMAIN = kepler.com
cman.ora Oracle network configuration manager is an optional component. If a DBA configures it then cman.ora is required.


Sample listener.ora file

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux1)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora11g.kepler.com)
(ORACLE_HOME = /home/oracle/product/11g)
(SID_NAME = ora11g)
)
)

LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux1)(PORT = 1522))
)
)
)

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ora11g.kepler.com)
(ORACLE_HOME = /home/oracle/product/11g)
(SID_NAME = ora11g)
)
)

Sample tnsnames.ora file

ORA11g =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORA11g)
)
)

To validate a tns entry use below command:

$ tnsping ora11g

TNS Ping Utility for Linux: Version 10.2.0.4.0 – Production on 22-MAY-2011 17:55:33

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:

/opt/oracle/product/10g/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = linux1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora11g)))

OK (10 msec)

To validate that listener.ora and tnsnames.ora is configured properly for ora11g database

$ sqlplus scott/tiger@ora11g ( sqlplus username/password@tnsnames )



Commands to Manage Listerner using lsnrctl tool

$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.4.0 – Production on 29-MAY-2012 17:58:30

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Welcome to LSNRCTL, type “help” for information.

LSNRCTL> help

The following operations are available

An asterisk (*) denotes a modifier or extended command:

start stop status

services version reload

save_config trace spawn

change_password quit exit

set* show*

Description of the commands to manage the listener:

start Starts the listener with the name specified, otherwise LISTENER will be used.

Examples :

lsnrctl start

lsnrctl start LISTENER

lsnrctl start LISTENER1

stop Stops the listener.

Examples :

lsnrctl stop

lsnrctl stop LISTENER

lsnrctl stop LISTENER1

status Provides status information about the listener, including start date, uptime, and trace level.

Examples :

lsnrctl status

lsnrctl status LISTENER

lsnrctl status LISTENER1

services Displays each service available, along with the connection history.

Examples :

lsnrctl services

lsnrctl services LISTENER

lsnrctl services LISTENER1

version Displays the version information of the listener.

reload Forces a read of the listener.ora file in order for new settings to take effect without stopping and starting the listener.

save_config Creates a backup of the existing listener.ora file and saves changes to the current version.

trace Sets the trace level to one of the following OFF or 0, USER or 4 , ADMIN or 8, or SUPPORT or 12.

spawn Spawns a program that runs with an alias in the listener.ora file.

change_password Sets a new password for the listener.

quit and exit Exits the listener utility.

set Changes the value of the listener parameter.

Examples :

LSNRCTL> set current_listener LISTENER1

Current Listener is LISTENER1

LSNRCTL>

show Displays current parameter settings

Examples :

LSNRCTL> show current_listener

Current Listener is LISTENER1

http://10.2.0.4/

Convert Non RAC to RAC database for 10g/11g/11gr2

In this demo we are converting a Non RAC database dbtest on host rac01 to a RAC database with instance dbtest1 and dbtest2 on host rac01 and rac02 respectively.

1. on the first node rac01

Make a full database backup of the single-instance database before you change anything.

1) Install Oracle Clusterware on all nodes you intend to have as cluster members.

2) If the Non RAC database is running from a Non RAC RDBMS home Install Oracle Database Software with Real Application Clusters option on existing and all new nodes.

2) Configure the cluster listener using netca or manually from new cluster RDBMS Home or Grid Infrastructure home in case of 11gr2. Eventually stop the single instance listeners when they are running on one of the clustered nodes in case they are using the same listener ports. Ideally, use the ‘LISTENER’ as name for that listener.

3) Restore the backup of datafiles, redo logs, control file to a shared storage.

4) Take a backup of original single-instance pfile.

cp /opt/oracle/product/11gr2/dbs/initdbtest.ora to /opt/oracle/product/11gr2/dbs/initdbtest_bkp.ora

vi initdbtest_bkp.ora

Add the following entry in pfile, e.g. for a two node RAC cluster

*.cluster_database = TRUE
*.cluster_database_instances = 2
*.undo_management=AUTO

*.remote_listener=listeners_dbtest for 10g/11gr1

or

*.remote_listener=‘scan-name:1521’ for 11gr2
dbtest1.undo_tablespace= UNDOTBS1 (undo tablespace that already exists)
dbtest1.instance_name=dbtest1
dbtest1.instance_number=1
dbtest1.thread=1
dbtest1.local_listener=listener_rac01

dbtest2.instance_name=dbtest2
dbtest2.instance_number=2
dbtest2.local_listener= listener_rac01
dbtest2.thread=2
dbtest2.undo_tablespace=UNDOTBS2
dbtest2.cluster_database = TRUE
dbtest2.cluster_database_instances = 2
5) change the location of control file in parameter file

local drive to shared cluster file system location

ie control_files=’/opt/oracle/data/control01.ctl’

to ie control_files=’/opt/oracle/data/control01.ctl’

6) create spfile from pfile( spfile should be stored in shared device)

export ORACLE_SID=dbtest1
sqlplus “/ as sysdba”
create spfile=’/opt/oracle/data/dbtest/spfiledbtest.ora’ from pfile=’ /opt/oracle/product/11gr2/dbs/initdbtest_bkp.ora ‘;
exit

7 ) Create the $ORACLE_HOME/dbs/initdbtest1.ora with below entry

spfile= ‘opt/oracle/data/dbtest/spfiledbtest.ora’

8 ) create new password file for dbtest1 instance.

orapwd file=orapwdbtest password=pass12

9) start the database in mount stage

10) Rename the datafile, redo logs to new shared device

alter database rename file ‘’ to ‘