OraFAQ Forum: Server Administration » problem with remote administration,help

Home » RDBMS Server » Server Administration » problem with remote administration,help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem with remote administration,help [message #224357]

Wed, 14 March 2007 01:27

aboodlardy
Messages: 80
Registered: November 2006
Location: India

Member

Hi
I have installed oracle 10g on RHlinux ES and i have given the user scott sysdba privilege through password file.
I connected to linux machine(server) from xp(with 9i client) as
scott/tiger@mydata1 as sysdba
from this client i am able to shutdown the database but unable to start it. PLZ help what shall i do?
the error is

SQL> SHUT IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
SQL>

Report message to a moderator

Re: problem with remote administration,help [message #224358 is a reply to message #224357]

Wed, 14 March 2007 01:32

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Can you post your TNSNAMES.ORA file ...

or first you should check your tnsnames.ora file contents correct serivce_name.

and try to connect again.

regards
Taj

Report message to a moderator

Re: problem with remote administration,help [message #224383 is a reply to message #224358]

Wed, 14 March 2007 02:31

aboodlardy
Messages: 80
Registered: November 2006
Location: India

Member

Hi
Actually , Taj i connected to the server and able to execute query, connection is not the problem and i am able to shutdown the database as well but the problem is after shutting down, i am not able to start it again from client side.

The following output is from client side.

SQL> conn scott/tiger@mydata1
Connected.
SQL> conn scott/tiger@mydata1 as sysdba
Connected.
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
SQL>

Any how this is my tnsnames.ora

# TNSNAMES.ORA Network Configuration File: E:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

MYDATA1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = mydata1)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ahmed-17e014c06)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

MYDATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.87)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = mydata)
)
)

Report message to a moderator

Re: problem with remote administration,help [message #224388 is a reply to message #224383]

Wed, 14 March 2007 02:39

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
In your tnsnames.ora file contents three database entry ...

which database are you trying to connect.

regards
Taj

Report message to a moderator

Re: problem with remote administration,help [message #224400 is a reply to message #224388]

Wed, 14 March 2007 03:06

aboodlardy
Messages: 80
Registered: November 2006
Location: India

Member

hi
Of these three, i am trying to connect to host 192.168.10.5 which is with "mydata1" as net service name.and client from where i am trying to connect is 192.168.10.87

regards
Abood

[Updated on: Wed, 14 March 2007 03:07]

Report message to a moderator

Re: problem with remote administration,help [message #224409 is a reply to message #224400]

Wed, 14 March 2007 03:27

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,
try like below

SQL>exit
C:\>set ORACLE_SID=mydata1
C:\>sqlplus /nolog
SQL>conn sys@mydata1 as sysdba

regards
Taj

Report message to a moderator

Re: problem with remote administration,help [message #224539 is a reply to message #224409]

Wed, 14 March 2007 11:29

aboodlardy
Messages: 80
Registered: November 2006
Location: India

Member

HI
Still it is not working.

when i try the above said thing i got this error.

C:\DOCUME~1\SULEMAN>set ORACLE_SID=mydata1

C:\DOCUME~1\SULEMAN>sqlplus /nolog

SQL*Plus: Release 9.0.1.0.1 - Production on Wed Mar 14 09:25:04 2007

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> conn sys@mydata1 as sysdba
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied

SQL>

I am sure my password for sys(given at the time of installation) is correctly typed.
Please help.
I think to connect as sys , we can go through only as sysdba or sysoper , isn't it?Brief me plz

regards
Abood

Report message to a moderator

Previous Topic:	Index segment size estimation
Next Topic:	database profiles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:28:41 CST 2024