Tag Archives: TNS

Linux

Connecting+Firing plsql to Oracle DB in one go

Leave a comment

By mohtashims

Hi,

I am using the below command to connect to a remote Oracle DB from my unix shell script.

Code:
sqlplus -s user1/password1@remotedbhost:1252/demo @/tmp/PROC_MS.prc

But I get the below error.

Quote:

ORA-12154: TNS:could not resolve the connect identifier specified

1. Can you confirm if my code is correct ?

2. Can you help me overcome the error ?

From: http://www.unix.com/shell-programming-scripting/221495-connecting-firing-plsql-oracle-db-one-go.html

Linux

403-009 The specified number is not valid for this command.

Leave a comment

By Daniel Gate

PHP Code:


Error Message: dm2_oraver: 9xdm2_oraver2: LT11/w_standard/gold_wh/install/dm2_updatetns.ksh[385]: 11MAR13: 0403-009 The spe
cified number is not valid for this command.

if [385] means the line number in the ksh, it is
((CntNew=Cnt+1)) .

Please let me know the best way to debug and find it out. I am running the built-in ksh, but getting the error.

HTML Code:
#!/bin/ksh

# Mod Date Engineer Change
# 000 07/20/04 AM4598 Created dm2_updatetns.ksh based on updatetns.ksh for new installs.
# 001 01/09/06 EG012557 Modified to default to Oracle 9 path of logic when on Oracle 10
# 002 02/16/06 EG012557 Modify to use : instead of . for chown commands that would run in mode T
# 003 06/23/06 EG012557 Modify to use : instead of . for chown commands that would run in mode A
# Modify listener.ora searching for account for Oracle 10
# Add export UNIX95=Y when on HPUX
# 004 11/17/08 EG012557 Modify to use case-insensitive search when looking for existing TNS entry
# 005 01/29/10 Bg8255 Modifications for Oracle 11.

OnError()
{ # $* = message to write
echo "n$*n"
exit 1
}

CheckUser()
{
if [[ $LOGNAME != $1 ]]
then
OnError "Incorrect user $LOGNAME. Login as $1 and try again."
fi
}

GetPort()
{
if [[ `grep -w $NewPort /etc/services | wc -l` -ne 0 ]]
then
if [[ `grep -w $NewPort /etc/services|egrep -e "oracle|tns"|wc -l` -eq 0 ]]
then
OnError "Port Number $NewPort reserved by a non-Oracle process."
fi
else
echo " "
echo "Execute the following commands as the root user to reserve port # $NewPort in the /etc/services file:"
echo " chservices -a -v'oracle_tns' -p'tcp' -n $NewPort -u'# Oracle

From: http://www.unix.com/shell-programming-scripting/220985-403-009-specified-number-not-valid-command.html

Business, Finance, Occupation & Industry

Huntington Bank Named Winner of the 2013 TNS Choice Award for Consumer Banking in Central Region

Leave a comment

By Business Wirevia The Motley Fool

Filed under:

Huntington Bank Named Winner of the 2013 TNS Choice Award for Consumer Banking in Central Region

Bank recognized for outperforming competitors in acquiring, retaining and developing customers

COLUMBUS, Ohio–(BUSINESS WIRE)– Huntington (NASDAQ: HBAN; www.huntington.com) has been named the winner of the 2013 TNS Choice Award for Consumer Banking in the Central Region. TNS, the largest custom research firm in the world, presented the award to Huntington for outperforming its competitors in acquiring, retaining and developing customers.

Huntington was selected based on an analysis of more than 7,900 consumer interviews conducted in the Central Region in 2012, as part of TNS‘s Retail Banking Monitor research program, which evaluates the competitive momentum of individual financial services firms.

“At Huntington, our customers are our top priority. They have told us they want banking solutions that matter and easier ways to do business with us, and we have responded with continued investments in service and convenience,” said Mary Navarro, Huntington’s retail and business banking director. “It is this foundation of service and dedication to caring about our customers, in addition to making banking easy, that has allowed Huntington to differentiate itself from its competitors.”

Over the past two years, Huntington has developed 24-Hour Grace®, a unique service that provides Huntington consumer checking customers until the next business day to cover overdrafts without any fees. Additionally, the bank has introduced an innovative checking account called Asterisk-Free Checking®, developed mobile applications for the iPhone and Android operating systems, strengthened its commitment to small business by lending $4 billion in the last three years, extended Saturday hours, and opened 107 new branches in Giant Eagle and Meijer grocery stores.

The 20-state Central Region includes: Alabama, Arkansas, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Michigan, Minnesota, Mississippi, Missouri, Nebraska, North Dakota, Ohio, Oklahoma, South Dakota, Tennessee, Texas and Wisconsin.

The TNS Retail Banking Monitor research program is developed to identify strong achievement on both the national and regional level. TNS measured customer acquisition, retention, satisfaction, and share of wallet, across a comprehensive set of competing firms, to identify top performers.

“Customers of Huntington are among the most satisfied bank customers in the country. Among consumers in the 20-state Central Region, Huntington is achieving faster organic growth than any significant competitor,” said James Meyer, executive vice president for TNS. “Huntington is winning new ‘primary bank’ relationships at an exceptional rate, and client loyalty scores are among

Source: FULL ARTICLE at DailyFinance

Business, Finance, Occupation & Industry

Chase Earns Record Four TNS Choice Awards for Outstanding Customer Satisfaction

Leave a comment

By Business Wirevia The Motley Fool

Filed under:

Chase Earns Record Four TNS Choice Awards for Outstanding Customer Satisfaction

NEW YORK–(BUSINESS WIRE)– Chase earned an unprecedented four awards for providing outstanding banking and investment services to its customers in 2013, according to TNS, the world’s largest customer research company.

Chase earned National Achievement in Consumer Banking and in Premier Banking, as well as Regional Achievement in the East United States and West United States categories.

“We work hard to make our customers’ lives easier through customer service, convenience and technology,” said Ryan McInerney, CEO of Consumer Banking at Chase, which serves 52 million U.S. consumer households. “Customers do more business with us because they appreciate that we put their needs first.”

The TNS Choice Awards recognize financial institutions who are the best among their peers in acquiring, retaining and developing customers. TNS conducted interviews with 20,000 consumers across the United States to determine their top selections.

“To win four TNS Choice Awards in a single year is an unprecedented achievement,” said TNS Executive Vice President Jim Meyer. “No other TNS Choice Winner has ever won more than two.”

The Premier Banking award reflects outstanding service to customers with assets greater than $100,000.

“We have put a lot of focus on serving our affluent customers,” said Barry Sommers, CEO of Chase Wealth Management. “These customers expect a higher level of service and we’re extremely pleased that TNS‘s research shows Chase provides that.”

About Chase

Chase is the U.S. consumer and commercial banking business of JPMorgan Chase & Co. (NYS: JPM) , a leading global financial services firm with assets of $2.4 trillion and operations in more than 60 countries. Chase serves more than 50 million consumers and small businesses through more than 5,600 bank branches, 18,700 ATMs, credit cards, mortgage offices, and online and mobile banking as well as through relationships with auto dealerships. More information about Chase is available at www.chase.com.

Media:
JPMorgan Chase & Co.
Lauren Francis, 212-270-4435
lauren.m.francis@jpmorgan.com
Follow us @ChaseNews

KEYWORDS:   United States  North America  New York

INDUSTRY KEYWORDS:

The article Chase Earns Record Four TNS Choice Awards for Outstanding Customer

Source: FULL ARTICLE at DailyFinance

Business, Finance, Occupation & Industry

Revealed: The Fragility of U.S. Wireless Customer Loyalty

Leave a comment

By Business Wirevia The Motley Fool

Filed under:

Revealed: The Fragility of U.S. Wireless Customer Loyalty

WDS study finds 36 percent of U.S. wireless customers at risk of churn in the next 12 months; only 13 percent truly loyal

KIRKLAND, Wash.–(BUSINESS WIRE)– A new study of loyalty among mobile phone users in the U.S., released today by WDS, A Xerox (NYS: XRX) Company, has worrying implications for wireless carriers. The WDS Mobile Loyalty Audit 2013 reveals that 36 percent of U.S. customers are considering leaving their mobile carrier in the next 12 months. The study, which integrates new survey data from research specialist TNS, also finds that only 13 percent of customers show the level of loyalty required to protect them from competitive offers and service disruptions.

For the first time, the WDS 2013 Mobile Loyalty Audit uses “stress-tests” to show the impact of real-world disruptions on a customer’s likelihood to change carriers and delivers a realistic view of the level of loyalty that exists in the US. When stress-tested, the study found customers’ perceived “loyalty” could be easily broken, for example:

What if…your current wireless carrier increased prices by 10 percent?

  • 69 percent of customers who were previously unlikely to switch would now consider leaving.
  • 15 percent of them would switch immediately without further consideration.
  • 70 percent of highly satisfied customers would also consider switching, 17 percent would leave without further consideration.

What if…another carrier could reduce your monthly tariff by 10 percent?

  • Only 31 percent of customers who were previously unlikely to switch could guarantee that they wouldn’t leave for this saving.

What if…there was a privacy breach?

  • 78 percent of those that said they were unlikely to switch would now consider leaving.
  • 27 percent of them would switch immediately without further consideration.
  • 29 percent of highly satisfied customers would switch immediately.

    • …read more
    Source: FULL ARTICLE at DailyFinance

Business, Finance, Occupation & Industry

TNS Delivers Next Generation Data Services Hub Including LTE Roaming Solutions for CCA Members

Leave a comment

By Business Wirevia The Motley Fool

Filed under:

TNS Delivers Next Generation Data Services Hub Including LTE Roaming Solutions for CCA Members

RESTON, Va.–(BUSINESS WIRE)– Transaction Network Services (TNS) will deliver a next generation Data Services Hub solution that includes LTE Roaming Services for CCA members. The TNS Data Services Hub is the only roaming hub of its kind in the industry, and this unique platform will provide participating operators the opportunity to connect for services including 4G LTE roaming, Wi-Fi access and interoperability with requisite 3G roaming fallback. CCA issued a formal request for proposal (RFP) for organizations interested in hosting the Data Services Hub, and TNS was selected by CCA’s Business Innovation Group‘s steering committee, made up of carrier members of various sizes and geographies.

The TNS Data Services Hub will provide a technical and business framework for simplifying LTE and other next generation data connectivity and roaming needs among participating operators. The solution will provide value to competitive carriers by enabling them to work more easily with one another to expand their national footprints. It will also benefit the international community by providing a single point of interconnection to the CCA community for negotiation, execution, implementation, and operation of roaming agreements for LTE and next generation data services.

“For competitive carriers to continue to compete and survive in the marketplace, they must have real roaming solutions, and I am pleased that TNS will provide a platform to achieve this important goal,” said CCA President & CEO Steven K. Berry. “The migration to next generation platforms such as LTE represents one of the most important technology shifts our industry has ever faced. TNS‘s Data Services Hub will provide a unique opportunity for CCA member operators to innovate and create next generation services that are flexible, standards-based and enhance the end-user experience.”

Surendra Saboo, CEO of TNS‘ Telecom Services Division, stated, “Enabling LTE roaming and next generation data services is a critical step for operators to realize high margin roaming revenues, grow ARPU, and prevent the churn of high-value subscribers. As a long-time supplier and partner to CCA operator members, TNS is committed to enhancing a vibrant wireless community and supporting their progression to LTE. We are thrilled to be selected as CCA‘s Data Services Hub and take great pride in serving our customers in their successful migration to the exciting new world of next generation technologies.”

The CCA Data Services Hub solution provided by TNS is an advanced 4G roaming ecosystem that supports scale, provides interoperability across multiple vendor variants and protocols, including LTE, and preserves the flexibility of …read more
Source: FULL ARTICLE at DailyFinance