Cannot remote startup database if dynamically registered with the listener?
Woody Ling
remotely: sqlplus sys@xyzdb as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested
in connect descriptor
I found that I cannot use sqlplus to remote startup my database
without static entry "(SID_DESC=(GLOBAL_NAME........))" in
listener.ora. Since some documents said that we should use dynamically
registered with listener for load balance in RAC environment, is there
any way to startup db without static db register?
Thanks.
Woody Ling
Hong Kong
DA Morgan
Log onto the server at the operating system level as a member of the
DBA group and then:
sqlplus /nolog
conn / as sysdba
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Frank van Bortel
Of course: change your tnsnames.ora on the client, it has
the wrong SERVICE_NAME= entry.
service_name := SID||DB_DOMAIN;
sybr...@hccnet.nl
There is.
You don't mention a version, but this probably works in both 9i and
10g.
It is called OEM.
OEM simply issues a srvctl command on the remote host.
If you don't use OEM, yes, you do need static registration.
Hth
--
Sybrand Bakker
Senior Oracle DBA
Woody Ling
>
> - Show quoted text -
Actually I am using OEM web interface and dynamic registration for
database service so that the listener can "see" the instance and
database when the pmon is started and registered itself to the
listener.
The problem is that when the rac database and all instances are
stopped, there is no pmon process and the listener does not know any
database service is available.
At this moment, when I login SYS as sysdba through an OEM web
interface, the OEM communicates with listener and finds that there is
no database available and reports ORA-12514. There is no way for me to
startup the database.
The problem can only be solved by adding static entry in listener.ora
to use static registration.
Am I correct?
sybr...@hccnet.nl
No, you are not.
You didn't read that one line, where I said:
>> OEM simply issues a srvctl command on the remote host.
Also, you don't mention a version, so it is very difficult to answer.
What OEM does in 9.2.0.8 is, provided the Intelligent Agent is
running, submit a job on the database server. That job issues a srvctl
command. No static registration required.
There may be more at hand in your installation, but as you require the
use of a crystal ball or a magic wand, I can't help you.
Woody Ling
>
> - 顯示被引用文字 -
Thanks for your help. I am using 10gR2 + RAC.
I am sorry that I want to know more detail.
The following are the steps to startup the database through OEM in my
case when using static registeration:
1. Login SYS as sysdba in OEM
2. OEM shows me that the database is not available and I click a
button to start the db.
3. OEM communications with sever process (what is it?)
4. OEM shows me a list of instances and let me choose which one to
startup with the db.
5. I choose some of them and then click next.
6. OEM issues srvctl to start the instances and db base on my choice.
But when I use dynamic registeration, the case becomes....
1. Login SYS as sysdba in OEM
2. OEM reports ORA-12514: TNS:listener does not currently know of
service requested in connect descriptor
3. It seems that OEM does not have chance to issue srvctl.
How to solve it? Thanks.
Woody Ling
>
> - 顯示被引用文字 -
I think I am totally wrong after testing with different setting.
Sybrand Bakker should be correct that listener is not needed for
startup a remote database with OEM.
Thanks Sybrand Bakker .