Home » RDBMS Server » Server Administration » problem with remote administration,help
problem with remote administration,help [message #224357] Wed, 14 March 2007 01:27 Go to next message
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>
Re: problem with remote administration,help [message #224358 is a reply to message #224357] Wed, 14 March 2007 01:32 Go to previous messageGo to next message
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
Re: problem with remote administration,help [message #224383 is a reply to message #224358] Wed, 14 March 2007 02:31 Go to previous messageGo to next message
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)
)
)



Re: problem with remote administration,help [message #224388 is a reply to message #224383] Wed, 14 March 2007 02:39 Go to previous messageGo to next message
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
Re: problem with remote administration,help [message #224400 is a reply to message #224388] Wed, 14 March 2007 03:06 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: problem with remote administration,help [message #224539 is a reply to message #224409] Wed, 14 March 2007 11:29 Go to previous message
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
Previous Topic: Index segment size estimation
Next Topic: database profiles
Goto Forum:
  


Current Time: Thu Dec 08 06:03:43 CST 2016

Total time taken to generate the page: 0.09376 seconds