Home » RDBMS Server » Server Administration » Startup a remote database fails with invalid username (Oracle database 11.2.0.4)
Startup a remote database fails with invalid username [message #645340] Thu, 03 December 2015 14:29 Go to next message
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>
Re: Startup a remote database fails with invalid username [message #645346 is a reply to message #645340] Thu, 03 December 2015 15:30 Go to previous messageGo to next message
Michel Cadot
Messages: 65970
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Reconnect before executing "startup".

Re: Startup a remote database fails with invalid username [message #645362 is a reply to message #645340] Fri, 04 December 2015 06:49 Go to previous messageGo to next message
EdStevens
Messages: 1005
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.
Re: Startup a remote database fails with invalid username [message #645364 is a reply to message #645362] Fri, 04 December 2015 06:57 Go to previous message
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
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:
  


Current Time: Sat Nov 17 08:53:10 CST 2018