OraFAQ Forum: Server Administration » Startup a remote database fails with invalid username

Home » RDBMS Server » Server Administration » Startup a remote database fails with invalid username (Oracle database 11.2.0.4)

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

Startup a remote database fails with invalid username [message #645340]

Thu, 03 December 2015 14:29

raziq
Messages: 7
Registered: July 2015
Location: Houston

Junior Member

Kindly read the whole message before replying. Thanks.

I am getting the following error when I try to startup an oracle database remotely (command prompt from my desktop). Sys of course has sysdba and sysoper. Password file is there. remote_login_passwordfile='EXCLUSIVE' set in the spfile. Listener has been configured to have the entry for this database and service. What am I missing?

H:\>sqlplus sys/xxx@tvlq.world as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 3 13:15:13 2015

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORA-01017: invalid username/password; logon denied
SQL>

Report message to a moderator

Re: Startup a remote database fails with invalid username [message #645346 is a reply to message #645340]

Thu, 03 December 2015 15:30

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Reconnect before executing "startup".

Report message to a moderator

Re: Startup a remote database fails with invalid username [message #645362 is a reply to message #645340]

Fri, 04 December 2015 06:49

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

raziq wrote on Thu, 03 December 2015 14:29

I am getting the following error when I try to startup an oracle database remotely (command prompt from my desktop).

Many organizations consider this in itself to be a security risk. Better to log on directly to the db server with proper credentials and do the shutdown from there.

Report message to a moderator

Re: Startup a remote database fails with invalid username [message #645364 is a reply to message #645362]

Fri, 04 December 2015 06:57

scapy
Messages: 12
Registered: November 2015
Location: Portugal

Junior Member

You have to add a static listener register on database, and use (UR=A) in you tnsname.ora.
Ex:
TVLQ=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <your host>)(PORT = 1521)))
(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = TVLQ)
(UR = A))
)

Hope this helps

Cump

Report message to a moderator

Previous Topic:	Is ASM a solution to a large recovery area
Next Topic:	Why isn't registry$history updated with latest 12.1.0.2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 14 18:02:09 CDT 2026