DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: "service name is not valid": problems to create a new DB on NT

  1. #1
    Join Date
    Nov 2000
    Posts
    42

    Question

    Hello.

    I'm trying to create a new database (Oracle 8.0.5 on Windows NT4.0).

    I've got another database, and the services are running ('OracleTNSListener80', 'OracleStartMYSID' and 'OracleServiceMYSID')

    On MS-DOS, I perform:

    c:> oradim80 -new -sid BACKUP -intpwd xxx -startmode auto -pfile initBACKUP.ora

    + I copied initBACKUP.ora from initMYSID.ora, and modified it.

    + BACKUP is the name of my new database

    When trying to check if OracleServiceBACKUP is running, I notice that it's not.

    So, I do:

    c:> net start OracleServiceBACKUP

    But I get this error message:

    **** service name is not valid ****

    Any experience? Regards.

    ========
    LARRY ELLISON

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Shouldn't the service name be four lettered?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Nov 2000
    Posts
    42

    Unhappy Should it?

    Should it?
    ========
    LARRY ELLISON

  4. #4
    Join Date
    Nov 2000
    Posts
    42

    Fine. It works!

    I'll write it down... Oracle Services must be four-lettered words.

    I did not know until now.

    THANK YOU VERY MUCH
    ========
    LARRY ELLISON

  5. #5
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    execute oradim80, you will see an window opening giving the list of current services runing.If it lists the new service u created then its ok.Other wise the new service has not been created.

    Your sid name need not be a 4 letter word.PLEASE CHECK ON THIS.

    CHEESE
    ANANDKL
    anandkl

  6. #6
    Join Date
    Nov 2000
    Posts
    42

    Question mmm

    But I changed BACKUP into BACK and it works....

    What is the reason???
    ========
    LARRY ELLISON

  7. #7
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    anand,
    That's true sid can be UPTO 4 characters.
    DB_NAME can be max 8 characters.

    Cheers

    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width