I would like to connect to database 12c via SQL Developer(in same VM where db is hosted) when it is in restrict mode. Tried below approaches but nothing worked. Kindly help !
Added (UR=A) in tnsname.ora as below: OBIEE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.37)(PORT = 1522)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.37)(PORT = 1521)) (CONNECT_DATA = (UR=A) (SERVER = DEDICATED) (SERVICE_NAME = OBIEE) ) )
Also, defined this in sqlnet.ora: tcp.validnode_checking = YES tcp.invited_nodes = IP address
*Note: I am able to connect to it via cmd.