| Problem when installing statspack [message #255631] |
Wed, 01 August 2007 06:12  |
chaitanya_krishna
Messages: 8
Registered: August 2007
|
Junior Member |
|
|
When running the spcreate.sql file
it is taking the perfstat password,
perfstat's default table space,
perfstat's temporary table space,
till the point ,it is ok,
but after that
when executing the statement
connect PERFSTAT/&&perfstat_password
it is showing network adaptor error.
what may be the reason and how to scrutiny this.
|
|
|
|
|
|
| Re: Problem when installing statspack [message #255819 is a reply to message #255631] |
Wed, 01 August 2007 23:04  |
chaitanya_krishna
Messages: 8
Registered: August 2007
|
Junior Member |
|
|
Hi,
when executing the spcreate.sql file,
till @@spcuser,it is ok,after that when executing the statement,
see the below file and the statement 'connect PERFSTAT/PERFSTAT6'
SQL> connect PERFSTAT/PERFSTAT6;
ERROR:
ORA-12560: TNS:protocol adapter error
Warning: You are no longer connected to ORACLE.
Rem
Rem $Header: spcreate.sql 16-apr-2002.11:22:55 vbarrier Exp $
Rem
Rem spcreate.sql
Rem
Rem Copyright (c) 1999, 2002, Oracle Corporation. All rights
reserved.
Rem
Rem NAME
Rem spcreate.sql - Statistics Create
Rem
Rem DESCRIPTION
Rem SQL*PLUS command file which creates the STATSPACK user,
Rem tables and package for the performance diagnostic tool
STATSPACK
Rem
Rem NOTES
Rem Note the script connects INTERNAL and so must be run from
Rem an account which is able to connect internal.
Rem
Rem MODIFIED (MM/DD/YY)
Rem cdialeri 02/16/00 - 1191805
Rem cdialeri 12/06/99 - 1103031
Rem cdialeri 08/13/99 - Created
Rem
--
-- Create PERFSTAT user and required privileges
@@spcusr
--
-- Build the tables and synonyms
connect PERFSTAT/PERFSTAT6
@@spctab
-- Create the statistics Package
@@spcpkg
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Problem when installing statspack [message #255908 is a reply to message #255631] |
Thu, 02 August 2007 05:47 |
chaitanya_krishna
Messages: 8
Registered: August 2007
|
Junior Member |
|
|
Hi Cadot,
ok, i got the point,now it-self i am posting the answer.
here onwards i will do it immediately.
This is the solution.
in spcreate.sql change the line
Old line:
connect perfstat/&&perfstat_password
New line:
connect perfstat/&&perfstat_password@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.24.103.424)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = XE)))
Now i was able to coneect it.
|
|
|
|
|
|
| Re: Problem when installing statspack [message #255924 is a reply to message #255631] |
Thu, 02 August 2007 07:19 |
chaitanya_krishna
Messages: 8
Registered: August 2007
|
Junior Member |
|
|
Frankly,
i had not seen the reply.
when i open the script,i got that idea.
i connected by giving the tns string, i tried and i succssed.
then when i open the forum, i had seen the reply.
any way thanks for your suggestion.
for me i am working on a remote one.
|
|
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
